RE: [PHP] PHP/MS SQL7 problems

Check the PHP-ODBC HOWTO at www.iodbc.org. I'm in the process of revising it for PHP4, but you may find it helpful. Things that jump out are: 1. what driver are you using? 2. have you configured your DSNs? 3. have you passed the appropriate envrionment variables (ODBCINSTINI, ODBCINI, LD_LIBRARY_PATH) in? Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Jason Bouwmeester [mailto:jason@intervisual.com] > Sent: Thursday, November 02, 2000 12:14 PM > To: 'php-general@lists.php.net' > Subject: [PHP] PHP/MS SQL7 problems > > > I am having problems with PHP4 and ODBC. > > $db=odbc_pconnect("DSN=bkcontent;UID=user;PWD=password","",""); > > results in the error: > > Warning: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or > buffer length, SQL state S1090 in SQLConnect in D:\Live > Sites\www.bloodykisses.com\phptest\moviedb.php on line 10 > > $db=odbc_pconnect("bkcontent","user","password"); > > results in error: > > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not > found and no default driver specified, SQL state IM002 in SQLConnect in > D:\Live Sites\www.bloodykisses.com\phptest\moviedb.php on line 10 > > At a glance do you know what might be causing this? Acording to > phpinfo() I > have ODBC enabled... is there anything else I need to be checking? > > Jason Bouwmeester > New Media Consultant > InterVisual > > Suite 200, 709 - 11th Ave SW > Calgary, AB T2R 0E3 > Ph: 403.264.9199 > Fax: 403.264.9225 > www.intervisual.com > "Internet Solutions Developer" > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >