Re: RE: [PHP] PHP/MS SQL7 problems

Hi Jason, Both php3 and php4 has ODBC build in, if you are using pre compiled binaries. you dont need any extentions. - Frank >Frank, > >Yeup it's system DSN, I've got one thing I just stumbled across that I am >waiting for my sysadmin to check and that is the php.ini file line >extension=php3_odbc.dll - apparently it is commented out by default, but >that is php3_odbc not php4 right? > >As for Andrew's comments, the first way with the DSN, UID, PWD in one string >reteruns the invalid string or buffer length, the other two ways return the >Data Source not found error... > >Thanks again, >jb > >-----Original Message----- >From: Frank M. Kromann [mailto:fmk@swwwing.com] >Sent: Thursday, November 02, 2000 2:11 PM >To: Jason Bouwmeester >Cc: 'php-general@lists.php.net' >Subject: Re: [PHP] PHP/MS SQL7 problems > > >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 >> >> >> > > > >-- >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 > > >