DSNless ODBC connection

[pdunnigan]

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

[pdunnigan]

I was able to make the dsnless connection using the following conn string and bypass the vnode server:

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