RE: [PHP] Desperate: odbc_connect() does not work! Please help!
| From: | Andrew Hill | Date: | Wed, 31 Oct 2001 15:12:07 +0000 |
| Subject: | RE: [PHP] Desperate: odbc_connect() does not work! Please help! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73027@lists.php.net to get a copy of this message | ||
Kraa,
The 01000 error is a 'General Error', probably at connect time.
This suggest that your DSN settings might be bad or not being passed into
PHP.
Is your DSN named "results" and is that the one you are using in your tests?
Also, are you setting your environment variables as appropriate? e.g.:
setenv("ODBCINI=/path/to/odbc.ini");
setenv("LD_LIBRARY_PATH=/path/to/your/driver/manager/lib");
You may also which to try this connection with odbctest, a sample
application available in the iODBC SDK at www.iodbc.org.
HTH!
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Kraa de Simon [mailto:Simon.de.Kraa@icl.nl]
> Sent: Wednesday, October 31, 2001 8:44 AM
> To: Php-General (E-mail)
> Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help!
>
>
> So desperate I even forgot the attachment...
>
> > -----Original Message-----
> > From: Kraa de Simon [mailto:Simon.de.Kraa@icl.nl]
> > Sent: woensdag 31 oktober 2001 14:40
> > To: Php-General (E-mail)
> > Subject: [PHP] Desperate: odbc_connect() does not work! Please help!
> >
> >
> > Hi,
> >
> > When I execute:
> >
> > <? odbc_pconnect("results", "sysprogress", "mls"); ?>
> >
> > I get error:
> >
> > Warning: SQL error: , SQL state 01000 in SQLConnect in
> > /usr/local/apache/htdocs/odbc.php on line 1
> >
> > See attachment for phpinfo().
> >
> > BTW 1
> >
> > The ODBC config itself works fine. I can make a connection
> > and retrieve data
> > from the database using a test C program.
> >
> > BTW 2
> >
> > I used --with-custom-odbc and set env var CUSTOM_ODBC_LIBS to
> > the lib dirs
> > and env var CFLAGS to the include dirs.
> >
> > Met vriendelijke groet / With kind regards,
> >
> > ICL Nederland B.V. Simon de Kraa
> > e-Applications / Logistic Systems Systems Architect
> > Het Kwadrant 1 Tel. +31 346 598865
> > Postbus 4000 Fax +31 346 562703
> > 3600 KA MAARSSEN
> > The Netherlands
> > mailto:Simon.de.Kraa@icl.nl
> >
> > ---
> >
> > Progress 9.1c, Roundtable 9.1c, NuSphere Pro Advantage 2.3.1
> > @ MS Windows
> > 2000 5.00.2195 SP 2
> > Progress 9.1b @ SCO UnixWare 7.1.1
> >
> > --
> > 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
> >
>
>
>