Re: PHP/MS SQL7 problems
| From: | Frank M. Kromann | Date: | Thu, 02 Nov 2000 21:10:44 +0000 |
| Subject: | Re: PHP/MS SQL7 problems | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-23460@lists.php.net to get a copy of this message | ||
Is the datasource you are trying to use crated as a user or system DSN ? it should be a system DSN
in order for the web server (iusr_xxx) to find the DSN.
- Frank
>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
>
>
>