Skip to Content
0
Former Member
Dec 01, 2008 at 02:08 AM

Data Services 3.1 and Ingres DB Connection Error

207 Views

Hi,

Trying to do a workaround to a Data Insight lack of access to an Ingres DB, I developed I dataflow to download data from Ingres DB (2006 r2, Patch 12724) to an Oracle DB (10g). The Ingres ODBC(3.50.0011) was setup in the MS ODBC Admin as a System DSN. The Ingres Vnode contains the user and password for the DB that I want to access, a SQL test was done and extract the desired rows from it. Data Services 3.1 can access that definition and navigate through the DB and the metadata from several tables were imported into the datastore. But when I tried to execute an extraction from the same table tested in the SQL statement I'm getting the next error:

(12.1) 12-01-08 08:41:07 (E) (3444:1936) CON-120302: |Session OSR_LTAX_Address_job ODBC call <SQLDriverConnect> for data source <LTAX> failed: <[CA][Ingres ODBC Driver][Ingres]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.>. Notify Customer Support.

The user and password were provided in both the datastore and in the NetUtil Vnode definition.

Any ideas on what could be happening?

Thanks.