DSNless ODBC connection

[pdunnigan]

Sorry, re-posting to this forum ...

Let me start by saying this is my first interaction with Ingres.

I have a client on Ingres 2.6. I am attempting to make dsn-less connection to an Ingres database in my Windows application. I have been successful at setting up the vnode, connecting using Visual DBA, setting up odbc and testing the connection, and then connecting to the database in my app using the odbc dsn.

Now, I am trying to figure out how to perform a dsn-less connection. I am getting an error

User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode is missing. Enter connection information for the vnode using NETUTIL.

First I have some questions (again bear with me here). Can an ODBC connection be made directly to the database without using the vnode? The vnode is setup on my local machine, and it seems that odbc is making a connection to it first and going through the vnode before hitting the database server. Can I bypass it?

All other odbc drivers that I've worked with allow you to interact directly with the target database server. Can this be done with the Ingres ODBC driver? If so, would the connection string look like?

Thanks,
Patrick

[andli02]

Hello Patrick,
I believe you want to use a vnodeless connection.
You can do that by following the steps below:
Instead of supplying a vnode in the connection string to access a remote database, such as:
command vnode::dbname[/server_class]
the "vnode" portion can be substituted with the same information that would have been defined for the vnode in one of the Ingres/Net configuration utilities (such as netutil).

This format is referred to as "vnodeless" or "dynamic vnode" or "@host" format.
To achieve replace the "vnode" portion with the following syntax:
@host,protocol,port[;attribute=value{;attribute=value}][[user,password]]

I hope this helps.
Regards,
Linda

[pdunnigan]

Yes, that helps.
I was able to make the dsnless connection using the following conn string and bypass the vnode server:

"driver=Ingres;servertype=ingres;server=@the_serve r_address,wintcp,I2;uid=myuser;pwd=mypass;database =mydb"

Thanks,
Patrick

[nick.bolton]

Dynamic vnode's were not available in 2.6, so you'll need to upgrade the client. I think they were a new feature in 3.0 (aka 9.0).