Unable to connect to Ingress Server using odbc

[anuprai]

Hi,
I am trying to connect to a remote ingress server using unixODBC. I have configured the vnode using netutil utility. But while trying to connect using uNIX odbc I get an error "[08004][unixODBC][Ingres][Ingres ODBC Driver][Ingres]Database does not exist: 'bodb01'."

But I have been able to connect to ingress server using the same details in the windows client.

My $ODBCINI has the following details

[evalkit_Ingres2006]
ReadOnly = no
Driver=/opt/Ingres/IngresII/ingres/lib/libiiodbcdriver.1.so
Description=Ingres
Database=bodb01
Vnode=test
Username=evalkit
Password=evalkit
DriverODBCVer=3.50
DriverReadOnly=N
DriverType=Ingres
Vendor=Ingres Corporation
DontDlClose=1


netutil shows the same details as in windows.

Could any one tell me what could be the issue?

Any help is greatly appreciated.

[thoda04]

Hi Anuprai,

Was your DSN definition in $ODBCINI created by hand-edit or by the iiodbcadmin utility?

If you replaced the database name with "iidbdb" as an experiment, are you able to connect in that case?

Dave

[loera01]

Hello Anuprai,

I suspect you hand-edited your $ODBCINI file, possibly by extrapolating what the entries would look like based on a connection string, because if you had used the Ingres ODBC Administrator (iiodbcadmin), the DSN entry would look like this:

[evalkit_Ingres2006]
Driver=Ingres
Description=Ingres
Vendor=Ingres Corporation
DriverType=Ingres
Server=test
Database=bobd01
ServerType=Ingres
PromptUIDPWD=
WithOption=
RoleName=
RolePWD=
DisableCatUnderscore=N
AllowProcedureUpdate=N
UseSysTables=N
BlankDate=N
Date1582=N
CatConnect=N
Numeric_overflow=Y
SupportIIDECIMAL=N
CatSchemaNULL=N
ReadOnly=N
SelectLoops=Y

You may be able to connect if you substitute the keyword "server" for "vnode".

If you are using a version of Ingres later than 2.6, You may use the iiodbdcadmin utility as Dave recommended. Early versions of Ingres name the utility as iiodbdcadmn (no "i" in 'admin').

Before using iiodbcadmin, be sure to configure the ODBC for Ingres by running iisuodbc.

Note that if your $ODBCINI file contains connection information about other drivers, iiodbcadmin will ignore the information for those drivers, but you can add, modify or delete Ingres driver entries as required.

You will find more information about using the Ingres ODBC driver in an Ingres environment in the Connectivity Guide at http://esd.ingres.com/product/docs/Ingres_2006/docs.

Regards,
Ralph Loen

[anuprai]

Hi Ralph,
Thanks a Lot for the timely help. I am able to connect to the ingress server now using ODBC after changing vnode to Server. One more modification that was required was to mention the so file responsible for connection that is
Driver=ingres changed back to
Driver=/opt/Ingres/IngresII/ingres/lib/libiiodbcdriver.1.so.
Once again Thanks A lot for the help

Thanks
-Anup-