Asp Merant Progress Problems-Error

[pcsama]

I have the Merant 3.7 32-bit progress driver installed on my pc and on the progress server. Using VB, ADO, or MS Access I can use the Merant driver with no problems with either a configured DSN or just a connection string. However when I try the same DSN or connection string in an ASP page I get the following error Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[MERANT][ODBC PROGRESS driver]Optional feature not implemented.
I have read previous posts suggesting that error trapping would work. However I did try that and was unsuccessful. Any help would be most appreciated.

 

[harebrain]

Is your PC the Web server? It doesn't sound like it. Remember that your ASP scripts are executed in IIS, and that the ODBC driver must therefore be installed on the Web server.

 

[pcsama]

I do have IIS installed on the pc. I have successfully used MS Access tables in the ASP pages on the PC.

 

[harebrain]

How about posting the connection string?

 

[pcsama]

The connection string is as follows:

lsConStr = "DB=cf" _
& ";UID=username" _
& ";PWD=password" _
& ";OIDP=TCP;OIDS=OIBRKR" _
& ";OIDH=ntlebadg01;DBAM=Direct;DBPR=TCP;" _
& ";DBOS=Windows;DBPath=e:\CCURE800\4GL\DATABASE" _
& ";DRIVER={MERANT 3.70 32-BIT PROGRESS}"

Like I said earlier, I use this string in VB frequently.
Thanks in advance

 

[harebrain]

I'm still confused about your computer configuration. You have a VB program that accesses the database: are you running that program on the same computer as the Web server? If not, the discrepancy could be caused by different versions of MDAC on the client computers.

There are a lot of properties that I don't recognize in that connection string; it looks like you're trying to make it DSN-less, which I don't think buys you anything with ODBC. Have you tried setting up an ODBC system DSN? Then you can reference it in your connection string and omit many of those properties. An added benefit is that you can debug the connection apart from the program. Here's a sample connection string referencing an ODBC DSN:

Provider=MSDASQL.1;
Password=password;
Persist Security Info=True;
User ID=username;
Data Source=DSN_NAME;
Mode=Read;
Initial Catalog=cf

HTH,
David

 

[pcsama]

Thank you for your response. I have built a DSN entry and it works just fine through VB or Access. However when I try to use it with your string or a working one from VB the same error appears. I have checked the MDAC versions. Both the server and my machine are running 2.7.
As far as the setup goes, the progress database I am trying to access is on a machine I call "server." The VB applications I develop on my machine. The ASP pages are being run from the IIS setup on my machine. Both my machine and the server have the MERANT 3.7 Progress driver installed.
Any more suggestions would be appreciated.
Thanks

 

[harebrain]

We're running the Merant v3.60 driver and Progress SQL92 v9.1D -- that combination turned out to be key for us to get things running. (There are still outstanding problems that we can work around.)

Which version of Progress are you on?

 

[pcsama]

v9.1b I believe.