Ingres connection

Shibu · October 1st, 2004, 06:31 AM

Can anybody guide me, how to connect a asp program with INGRES Database.

I had tried with following code:

str_datasource="Provider=MSDASQL.1;DRIVER=Ingres 3.0;SRVR=PM;DB=dbs_test;Persist Security Info=False;uid=Administrator;pwd=12345678;SELECTLO OPS=N;Extended Properties=""SERVER=PM;DATABASE=dbs_test;SERVERTYP E=INGRES"""

Dim obj_con
SET obj_con = SERVER.CreateObject("ADODB.Connection")
obj_con.open str_datasource

But It showed up following error.

Error Type:
Provider (0x8000FFFF)
Catastrophic failure
/test/test_connection.asp, line 17

dalewright22 · October 1st, 2004, 07:56 AM

Shibu

its a problem with Microsoft SQL Server ODBC driver (Sqlsrv32.dll) . I would recommend that you upgrade to the latest MDAC version which should solve your problems. Or you could Revert back to an earlier SQL ODBC driver or even use
the SQL Server native provider (Sqloledb.dll) instead.

Cheers

DJWright

Shibu · October 1st, 2004, 08:03 AM

DJWright
   Thanks for your reply.

   I have got MDAC 2.8 already installed in my system.

   please suggest, if there exist any newer version for MDAC.

Shibu

happygv · October 1st, 2004, 08:55 AM

Check if this works.

Code:

"Provider=MSDASQL.1;DRIVER=Ingres;SRVR=xxxxx;DB=xxxxx;Persist Security 
Info=False;uid=xxxx;pwd=xxxxx;SELECTLOOPS=N;Extended 
Properties="""SERVER=xxxxx;DATABASE=xxxxx;SERVERTYPE=INGRES""

Refer Connection strings

There seems to be difference in quotes usages in the last line of connectonstring from the one you posted with that of the one I find in that link posted above. I haven't used this before, so I am not sure if that is the cause for this error.

Though you can take a look at this which is similar to what DJWright suggested.

0x8000FFFF "Catastrophic failure" Message with SQL Server ODBC Driver

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

dalewright22 · October 1st, 2004, 09:00 AM

you have the latest MDAC installed, emmm... let me think... Has this problem only recently happend??? what is happening on line 17?? ie what code??? is when your trying to open a recordset ??? is it poss u could post the code up until line 17??? can u connect to other data stores???

after looking at your connection string, just double check that all of ur params are right, ie. password / uid etc..

Try taking out the 3.0 from the driver i.e

str_datasource ="Provider=MSDASQL.1;DRIVER=Ingres;SRVR=PM;DB=dbs_ test;Persist Security Info=False;uid=XXXX;pwd=XXXXX;SELECTLOOPS=N;Extend ed Properties=""SERVER=xxxxx;DATABASE=xxxxx;SERVERTYP E=INGRES"""

where XXXX is your values

Cheers

DJWright

Shibu · October 2nd, 2004, 12:46 AM

Thanks Wright

Code at line No 17 is :
obj_con.open str_datasource

I have tried almost all combinations with the connection string.
I have got no problem while accessing a sql server database.

Shibu

happygv · October 2nd, 2004, 05:56 AM

Shibu,

Was that solved? If so what was that you were missing? Can you post your connection string that finally worked?

Cheers!

_________________________
- Vijay G
Strive for Perfection

Shibu · October 3rd, 2004, 11:31 PM

Hai vijay.

Thanks for your interest.
But I am still in search of a solution.

Shibu