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:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]]
> > 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:[EMAIL PROTECTED]
> >
> > ---
> >
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
