PHP/MS SQL7 problems
| From: | Jason Bouwmeester | Date: | Thu, 02 Nov 2000 17:13:49 +0000 |
| Subject: | PHP/MS SQL7 problems | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-23425@lists.php.net to get a copy of this message | ||
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"