Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread Micah Gersten
Is it set up as a system DSN or User DSN. Try testing an app as the same user as the webserver and see if you can connect to the DSN. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: > Here are the messages that are currently displaye

Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread kitfox69
Here are the messages that are currently displayed and my current script: 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 D:\xampp\htdocs\test2.php on line 11

Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread Micah Gersten
What does the connector return to you when you connect in PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: > Yes I am sure the ODBC works as it is installed on my laptop and I use Excel > to import many various queries of data. >

Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread kitfox69
Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten <[EMAIL PROTECTED]> > Have you tested the DSN outside of PHP? Openoffice.org Database has > facilities t

Re: [PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread Micah Gersten
Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: > Hello Everyone! > > I am currently writing a sequence of php pages to help me r

[PHP-DB] PHP5 and Multiple Database Connections

2008-08-05 Thread kitfox69
Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problem