[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]
RE: [PHP-DB] help connecting to ODBC
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]
Re: [PHP-DB] help connecting to ODBC
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]
RE: [PHP-DB] help connecting to ODBC
Anthony, Then enable ODBC tracing in the ODBC Administrator and see where the calls are failing. Or try a different ODBC driver - you can download free ones from our site for most databases. 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:21 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] help connecting to ODBC 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] -- 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]