DSXchange

Hi,

I want to configure uvodbc.config file. Entries in sample uvodbc.config file is as given below:

**************case 1**************
<ODBC Name>
DBMSTYPE = ODBC
network = TCP/IP
service = XXXX
host = XXXX

***************case 2*****************
<ODBC Name>
DBMSTYPE = ODBC
*****************************************
My doubts are:
1. To configure the file, which one I have to follow, case 1 or case 2 ?
2. If I have to follow case 1, then what is service? Is it database name ?

Thanks,
Param

You use whichever case is appropriate - mainly driven by whether the database server is on the same machine as the DataStage server or not.

For more information refer to the coredev.pdf manual.

Interesting... I''ve always used 'Case 2' without issue regardless of database server location.

chulett wrote:Interesting... I''ve always used 'Case 2' without issue regardless of database server location.

Thanks Roy and Chulett for your information.
Even in case 2, what is the Service ? Is it database name ?

Thanks,
Param

Maybe, maybe not. Ultimately it's the service name that has to be requested. For UniVerse, for example, it's uvserver.

You can specify the service/database details in .odbc.ini. Please refer to the online documentation for details

parameswar wrote:

chulett wrote:Interesting... I''ve always used 'Case 2' without issue regardless of database server location.

Thanks Roy and Chulett for your information.
Even in case 2, what is the Service ? Is it database name ?

Thanks,
Param