Showing posts with label CTGDIJ037E. Show all posts
Showing posts with label CTGDIJ037E. Show all posts

Wednesday, June 5, 2013

TDI 7.1 Error CTGDIJ037E. Cannot connect to Database when configuring JDBC Connector.

Problem:
Cannot connect to database configuring TDI JDBC connector. Getting CTGDIJ037E error or SQLCODE=-204, SQLSTATE=42704 (which means 'no such table').
Here's an example:
or another one:
Answer:
Both errors mean 'Wrong schema name'. Let's see. Username is LCUSER. Then default schema name is LCUSER. But my actual schema name is EMPINST. That means I should specify my schema name somewhere. In second case I tried to give it in a table name field but that didn't work. I also cannot do it using connection string. But lower there's a field for Extra Provider Paramaters. There I point real schema name like this:
and press Connect. The problem is solved.