yes, I can use the source from other programs. The source is a System DSN, based on a file DSN for the driver. The I_USR_<servername> user has the correct access rights to the files being accessed and to the file DSN driver.
Andrew Hill wrote: > 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]