Hi, The problem is that a Progress 9.1c is not available at openlinksw.com for:
Client: Linux glibc2.1 (x86) Server: UnixWare 7 (x86) Only Progress 8.3b is supported. So you are saying that a setting in the .ini files or some environment variable could be missing. I will have a look at it. Thanks, Simon. > -----Original Message----- > From: Andrew Hill [mailto:[EMAIL PROTECTED]] > Sent: woensdag 31 oktober 2001 20:25 > To: Kraa de Simon; Php-General (E-mail) > Subject: RE: [PHP] Desperate: odbc_connect() does not work! > Please help! > > > Kraa, > > I'm not sure why the two sample apps are using different > connection calls; > It's not terribly relevant - both are legal. > > Driver manager and driver are not typically dependent on each > other, no. > The fact that the connection fails in odbctest is probably > due to a missing > parameter that iODBC wants in the DSN or the environment > variables. You can > look at error messages for the Merant driver - I'm not going > to get into > debugging it :) > > If you want to try OpenLink's ODBC drivers, you will find > they work fine > with PHP and Progress. > I suggest you download the Multi-Tier driver from our site - > they comes free > with a 2 user connection. I would also suggest that you > compile --with-iodbc, as it is in greater use and has been > more thoroughly > tested with PHP. > > Free support is available as well if you have difficulties, at: > http://www.openlinksw.com/support/suppindx.htm. > > 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 1:59 PM > > To: '[EMAIL PROTECTED]'; Php-General (E-mail) > > Subject: RE: [PHP] Desperate: odbc_connect() does not work! > Please help! > > > > > > Hi Andrew, > > > > I'm using the Merant DataDirect 3.6 Progress SQL92 ODBC > drivers and they > > seem to be working fine when I try their test C program. I > can connect to > > the Progress database en retrieve data. > > > > I'm using their driver manager as well (--with-custom-odbc). > > > > The test C program uses: > > > > SQLConnect (hdbc, driver, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS); > > > > SQLConnect is executed without problems. A connection can be made. > > > > When I try odbctest (from iODBC / odbcsdk) the connect fails > > (same drivers, > > same odbc.ini, same odbcinst.ini). > > > > SQLDriverConnect (hdbc, 0, (UCHAR *) dataSource, SQL_NTS, > (UCHAR *) buf, > > sizeof (buf), &buflen, SQL_DRIVER_COMPLETE); > > > > SQLDriverConnect returns -1. A connection cannot be made. > > > > Why is the first program using SQLConnect() and the other > > SQLDriverConnect()? > > > > Are ODBC driver and ODBC driver manager dependent on each other? > > > > Or can I use the iODBC driver manager and the Merant ODBC drivers > > together? > > > > Are there alternatives to the Merant ODBC drivers? > > > > I am connect a Progress 9.1c database on SCO UnixWare 7.1.1 > from Red Hat > > Linux 7.1 with Merant DataDirect 3.6 Progress SQL92 ODBC > drivers and ODBC > > driver manager. > > > > Any ideas? > > > > Regards, > > > > Simon. > > > > > -----Original Message----- > > > From: Andrew Hill [mailto:[EMAIL PROTECTED]] > > > Sent: woensdag 31 oktober 2001 16:12 > > > To: Kraa de Simon; Php-General (E-mail) > > > Subject: RE: [PHP] Desperate: odbc_connect() does not work! > > > Please help! > > > > > > > > > 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] > > > > > > -- 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]
