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
uvodbc.config
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
For more information refer to the coredev.pdf manual.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
You can specify the service/database details in .odbc.ini. Please refer to the online documentation for details
parameswar wrote:Thanks Roy and Chulett for your information.chulett wrote:Interesting... I''ve always used 'Case 2' without issue regardless of database server location.
Even in case 2, what is the Service ? Is it database name ?
Thanks,
Param
Edward Yuan