note 30554 added to function.odbc-connect

I fighted with the "Data source name not found and no default driver specified, SQL state IM002 in SQLConnect" error for a while trying to connect via ODBC to a SQL Server 2000. Finally I found this workaround: $cn = odbc_connect("Driver={SQL Server};Server=MyServer;Database=MyDatabase", "MyUser","MyPassword") Change "MyServer", "MyDatabase", "MyUser" and "MyPassword" to the right values. I guess that adding the "Integrated Security=YES" will work too. Regards, Yvan Ecarri, MCDBA, MCSD -- http://www.php.net/manual/en/function.odbc-connect.php http://master.php.net/manage/user-notes.php?action=edit+30554 http://master.php.net/manage/user-notes.php?action=delete+30554 http://master.php.net/manage/user-notes.php?action=reject+30554