DSN Names

Indrani · Post by **Indrani** » Fri Oct 28, 2005 1:24 am

Hi
We have installed DS Client, DS Server, Database Server are all in different machines. Iam not able to get the DSN names, when I import through the ODBC table definitions. In the ODBC Table Definition - I get the server name where DS server is installed. Should I do anything in the machine where DS Server is installed? I also tried to make a ODBC Connectivity in the DS Client (through control panel). But still Iam not getting the DSN names. Please help me out to get the DSN names. Hope I explained the situatin clear, If it is not understable, please let me know. I will try to explain still clear.

Thanks in advance.

ArndW · Post by **ArndW** » Fri Oct 28, 2005 1:29 am

Which database are you connecting to? If it is Oracle, can you use tnsping on your DataStage system?

Indrani · Post by **Indrani** » Fri Oct 28, 2005 1:37 am

We are using DB2 as our source. All the DSN are already created.

ArndW · Post by **ArndW** » Fri Oct 28, 2005 1:43 am

Indrani,

can you db2connect to the database from the DataStage server?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 28, 2005 1:52 am

DSNs with associated database information need to be set up in .odbc.ini and a reference to each DSN must be set up in the uvodbc.config file in your project.

There has been a recent thread on just this topic; search should find it fairly easily. A good search term might be DBMSTYPE.

Indrani · Post by **Indrani** » Fri Oct 28, 2005 2:00 am

"One important thing to remember: the DataStage Server is the ODBC client, so you need to configure ODBC on the machine where the DataStage server is running.

Mike "

We have connected the DS Server and the DB2 server machine.
So you need to get the ODBC connectivity and place all the DSN names in the DS Server machine.

So If I place just the DSN names in the server machine , will it bring the datas from DB2 source?

In the above, Mike seems to say the same in a question from yesterday 's forum.

Indrani · Post by **Indrani** » Fri Oct 28, 2005 2:04 am

ray.wurlod wrote:DSNs with associated database information need to be set up in .odbc.ini and a reference to each DSN must be set up in the uvodbc.config file in your project.

There has been a recent thread on just this topic; search should find it fairly easily. A good search term might be DBMSTYPE.

Ray, I still didn't get you about the odbc.inin and the uvodbc.config

ray.wurlod · Post by **ray.wurlod** » Fri Oct 28, 2005 2:18 am

There is a (hidden) file called .odbc.ini in the DataStage Engine directory (the directory specified by $DSHOME). Sometimes an environment variable $ODBCINI has been created to refer to the location of .odbc.ini.

The .odbc.ini file contains the definitions of all DSNs visible from the DataStage server machine. (If you're old enough you'll remember that this is how things used to be done in Windows 3.1 and earlier, too. Now the Registry entry is still called OBDCini, maybe as a commemoration.)

You edit the .odbc.ini file to create and configure DSNs.

There is a uvodbc.config file in each project. This determines which DSNs are visible from that particular project. Each DSN must also have a value for DBMSTYPE of either ODBC (which means look in .odbc.ini) or UNIVERSE (which means use BCI/UCI functions rather than an ODBC driver to connect to a UniVerse (or DataStage) data source).

Indrani · Post by **Indrani** » Fri Oct 28, 2005 2:38 am

Ray,
I understood about the odbc.ini and uvodbc.
So If I make the ODBC connectivity with the DSN names in the DS Server machine, will I get the data in the DS client machine.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 28, 2005 2:44 am

DSNs only appear in the drop-down list in the ODBC stage if you've imported at least one table definition from the data source.

When you're going through the process of Import > Table Definitions > ODBC Table Definitions in the Manager client, all DSNs named in the project's uvodbc.config file appear in the drop down list of available DSNs.

Indrani · Post by **Indrani** » Fri Oct 28, 2005 2:50 am

ray.wurlod wrote:DSNs only appear in the drop-down list in the ODBC stage if you've imported at least one table definition from the data source.

When you're going through the process of Import > Table Definitions > ODBC Table Definitions in the Manager client, all DSNs named in the project's uvodbc.config file appear in the drop down list of available DSNs.

Yes, But Iam not getting any DSN names in the Import > Table Defn> ODBC Table Defn in the DS client machine. It says empty DSN names.

Indrani · Post by **Indrani** » Fri Oct 28, 2005 2:52 am

ray.wurlod wrote:DSNs only appear in the drop-down list in the ODBC stage if you've imported at least one table definition from the data source.

When you're going through the process of Import > Table Definitions > ODBC Table Definitions in the Manager client, all DSNs named in the project's uvodbc.config file appear in the drop down list of available DSNs.

Yes, But Iam not getting any DSN names in the Import > Table Defn> ODBC Table Defn in the DS client machine. It says empty DSN names.

Should I make the necessary changes in the DS Server / DS client machine?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 28, 2005 3:34 am

You must make the changes on the DS server, particularly the uvodbc.config file in the project and the .odbc.ini file in the "home" directory.

No changes are required on the DS client machine.

Indrani · Post by **Indrani** » Fri Oct 28, 2005 3:37 am

Ok, Thanks Ray

drostnu · Post by **drostnu** » Fri Aug 18, 2006 11:25 am

so far i have the same problem i know i have to configure /uvodbc.config

but how should i set this.

[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

i have oracle and sybase dbs running .

please help me

thanks!