uvodbc.config

parameswar · Post by **parameswar** » Sun Jul 15, 2007 2:46 am

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

ray.wurlod · Post by **ray.wurlod** » Sun Jul 15, 2007 6:18 am

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.

chulett · Post by **chulett** » Sun Jul 15, 2007 6:42 am

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

parameswar · Post by **parameswar** » Sun Jul 15, 2007 8:51 am

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

ray.wurlod · Post by **ray.wurlod** » Sun Jul 15, 2007 1:10 pm

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

Yuan_Edward · Post by **Yuan_Edward** » Sun Jul 15, 2007 6:22 pm

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