odbc

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 3:28 pm

Forget JobMonApp on this thread - it's irrelevant. Open a new thread for that or, better, Search for it.

Now check your uvodbc.config file for an entry for the DSN.

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 4:05 pm

THE file has got the following entries

<NZSQL>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 8.1.50.40

<NZSQL_PASD_TST>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 8.1.50.40

the pull down menu shows the first one NZSQl but not the second one.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 4:07 pm

Which pull-down menu?

The pull-down menu in an ODBC stage only shows data sources from which you have imported at least one table definition. It is driven by the Repository table in which table definitions are stored.

DSguru2B · Post by **DSguru2B** » Fri Dec 29, 2006 4:09 pm

Check it while importing odbc table definitions. Can you see it in the pull down menu there ?

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 4:12 pm

the data source name pull down menu shows only the first one that is nzsql but does not show me the other me at all.

chulett · Post by **chulett** » Fri Dec 29, 2006 4:13 pm

kishoreramachandran wrote:THE file has got the following entries

THE file where? There's one in your $DSHOME directory and one in each Project, which one is this?

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 4:15 pm

this is in /usr/local/Ascential/DataStage/DSEngine/uvodbc.config

chulett · Post by **chulett** » Fri Dec 29, 2006 4:18 pm

Have a peek at the one in your specific Project you are trying to Import from. Bet it only mentions the one you see in your 'pull down menu'.

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 4:20 pm

what actually you want me to check

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 4:32 pm

what will the name of the file in the home directory

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 5:45 pm

Not the home directory, the project directory.

In the project directory the file you need to check is called uvodbc.config.

There is one in each project directory as well as the one in the DSEngine directory; the latter is a "catch all" in case there isn't one in the project directory.

chulett · Post by **chulett** » Fri Dec 29, 2006 8:17 pm

This file:

/usr/local/Ascential/DataStage/Projects/<yourprojectname>/uvodbc.config