Hi guys,
I would like to know, which "driver" should i select/use for creating System DSN for a Universe & Unidata Stage.
Driver for creating DSN for Universe & Unidata
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Driver for creating DSN for Universe & Unidata
Shantanu Choudhary
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You still don't need a driver. You need to specify the hostname (and maybe some additional information) in uvodbc.config where you define the UniVerse data source.
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.
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
ray.wurlod wrote:You still don't need a driver. You need to specify the hostname (and maybe some additional information) in uvodbc.config where you define the UniVerse data source.
I have already tried that.
In the uvodbc.config file I have added.
Code: Select all
<TESTUV>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 172.17.60.250
Code: Select all
Milind3..UniVerse_11: DSD.BCIConnect connecting to TESTUV, call to SQLConnect failed.
SQLSTATE=IM002, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Shantanu Choudhary
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: