Ingres ODBC connection

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Ingres ODBC connection

Post by admin »

I am trying to get connected to Ingres via the ODBC driver supplied via DataStage. I have an .odbc.ini file with the following settings:

Driver=/app/datastage/P12/ds40/uv/../branded_odbc/lib/VMoing15.so
ServerName=kahiwi_l6
Database=lprod
Workarounds=1

However when I connect I get the following error. Ideas anyone?

DSR.MetaGeta(GET.TABLES)(SQLConnect(lprod,dsgprod)): BCI Error: SQLSTATE=S1000,CODE=-34000,[Ardent][SQL Client][ODBC][MERANT][ODBC INGRES driver][INGRES]E_US0002 User does not have permission to use one of the flags given.
(Mon Nov 20 12:13:31 2000)

I was thinking I may need to add a OPTS entry.

Regards,

Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz
Locked