RE: [PHP] PHP/MS SQL7 problems

Hi Jason, My suggestions were unfortunately targeted towards *nix environments. To determine what is happening in Windows, you can enable ODBC tracing in the ODBC Administrator control panel (essentially the driver manager). Walk through the trace, and see where the error shows up. Before you try that though, you may wish to try changing $db=odbc_pconnect("DSN=bkcontent;UID=user;PWD=password","",""); to $db=odbc_pconnect("DSN=bkcontent","user","password"); or even (depending on the version of your driver manager) $db=odbc_pconnect("bkcontent","user","password"); Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider 781.273.0900 x 27 > -----Original Message----- > From: Jason Bouwmeester [mailto:jason@intervisual.com] > Sent: Thursday, November 02, 2000 4:05 PM > To: 'php-general@lists.php.net' > Subject: RE: [PHP] PHP/MS SQL7 problems > > > Andrew, > > Thanks for the reply. > > 1. I am using SQL driver... > 2. DSN is configured. > 3. I am unclear on this, my setup is MS SQL 7 on a W2K Server, > running IIS 5 > and PHP 4.0. > > Thanks, > jb > > -----Original Message----- > From: Andrew Hill [mailto:ahill@openlinksw.com] > Sent: Thursday, November 02, 2000 12:21 PM > To: Jason Bouwmeester; php-general@lists.php.net > Subject: 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 > > > > > > > > -- > 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 > > >