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

i think you forgot to make your ODBC entry in sistemsetings , and do not make it in user but in system odbc almir "Frank M. Kromann" <fmk@swwwing.com> schrieb in im Newsbeitrag: <200011022237.XAA08801@swwwingsun>... > Hi Jason, > > Build in ODBC support is only on Win32 though ! > > - 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 > > > > > > > > > > > -- > 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 >