Ingres II Database Connection

[nder]

Does anyone know how to connecte to an Ingres II database in VB6? Been searching Google and finding nothing. Most I found was:

"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""

But I can't get it to work.

I have Ingres installed and the databases configured in the ODBC Control Panel. Tested connection and it worked. Now need to figure out how to connect from VB.

[Arch_Angel]

Your connection string looks wierd, but try something like this:

MyConnectionString = "SERVER=xxx.xxx.xxx.xxx;SERVERTYPE=INGRES;DATABASE=database_name;SELECTLOOPS=N;UID=username;PWD=password;"

Or likewise, you can use your dsn connection:

DSN=dsn_name

This was taken from thier Connectivity Guide document found here: http://opensource.ca.com/projects/ingres/documents

[Arch_Angel]

I am noticing the CODE tag is inserting some space into the connection string. There is no space in the string, just to let you know.

[nder]

Thanks. Ill try this. And thanks for the link. I've been searching for the support site too.,

[nder]

The DSN connection worked. Thanks.