[RESOLVED] ODBC_connect and SQL Error MSG

[yogicasey]

I am trying to connect to a SQL db and I am receiving the following error msg:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\WINDOWS\Temp\IW718E.tmp on line 5

I have created an ODBC and tested it and it does connect.

Here is my code:

<?php
$sqlconnect="DRIVER={SQL Server};SERVER=xxx;DATABASE=yyy";
$DB_User="";
$DB_Passwd="";
$Connect = odbc_connect( $ConnString, $DB_User, $DB_Passwd );
if (!$sqlconnect)
{
echo "Couldn't connect!";
exit;
}
?>

Thanks.

[yogicasey]

I changed my odbc to SQL authentication and the problem went away.