Re: [Info-Ingres] .NET Data Provider with Ingres 2.6

Hi Mark

Just wondering if anyone has used the .NET Data Provider against Ingres 2.6? I have had some success but certain connection
string parameters do not work as expected.

You need to go through an Ingres 2006 DAS; you can set up a 2006 installation and connect to the 2.6 installation through Ingres Net;

There are some authorization issues you have to deal with: specifically, you must decide whether you need to validate authentication on the DAS installation or not. For example, let's say you have an Ingres 2006 installation on machine "my2006Host". You create a vnode (on the 2006 install) called my26vnode which points to your second machine that runs Ingres 2.6, "my26Host". You can construct your connect string in two different ways:

1) validate user and password only on the remote 2.6 installation:

"Host=my2006Host;Database=my26vnode::my26db;Port=ii7;User Id=my26user;PWD=my26pwd;"

In this case, the vnode "my26vnode" must be defined as global and owned by the installation owner. The authorization entry will be ignored, and the "User Id" / "PWD" will be validated only on the remote installation. In other words, no authentication will take place on the intermediate 2006 installation (where DAS is installed).

2) validate user and password *both* on the remote 2.6 installation and the intermediate 2006 installation.

"Host=my2006Host;Database=my26vnode::my26db;Port=ii7;User Id=my26user;PWD=my26pwd;Vnode_usage=login"

In this case, "Vnode_usage=login" indicates that the vnode authentication entry should be used to validate the user/password (associated with "my26vnode") on the remote target installation. The authentication entry can be global or private, and can use installation passwords. This scenario allows authentication on both installations, but may require vnode maintenance on the DAS server installation (unless you use installation passwords).

Note that either of these examples work whether or not the remote installation is Ingres 2.6 or Ingres 2006.

Hope that helps!

Regards,

Jim Gramling
Rio de Janeiro

.