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]