Anthony, Is the DSN usable from the ODBC Administrator control panel? E.g. test it there first. Also, you mention File DSNs? PHP can only use System DSNs on Windows, AFAIK.
Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Anthony [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 1:01 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] help connecting to ODBC > > > I can't connect to an ODBC data source. I have done this before many > times. I am now trying to connect to a new driver for new data. This > is the first time I have tried to access a file DSN. I have the driver > setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to > connect to the data source I get "SQL error: , SQL state S1000 in > SQLConnect". What does this mean? does anyone know where I can get a > list of SQL errors and their meaning? Thanks to anyone that can lend > their thoughts. > > - Anthony > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
