I checked openlinksw and the driver for Progress 9.1b is indeed available... (for client is Linux glibc2.1 (x86) and server is UnixWare 7 (x86))
...but we are on Progress 9.1c. When will the Progress 9.1c driver for this client/server config be available? Regards, Simon. > -----Original Message----- > From: Andrew Hill [mailto:[EMAIL PROTECTED]] > Sent: woensdag 31 oktober 2001 21:32 > To: Kraa de Simon; Php-General (E-mail) > Subject: RE: [PHP] Desperate: odbc_connect() does not work! > Please help! > > > Kraa, > > Sorry for the confusion; we should have that component > available by the end > of the week. > > Best regards, > Andrew > > > > -----Original Message----- > > From: Kraa de Simon [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 31, 2001 2:50 PM > > To: '[EMAIL PROTECTED]'; Php-General (E-mail) > > Subject: RE: [PHP] Desperate: odbc_connect() does not work! > Please help! > > > > > > 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]
