Driver for creating DSN for Universe & Unidata

talk2shaanc · Post by **talk2shaanc** » Wed Jun 08, 2005 10:09 pm

Hi guys,

I would like to know, which "driver" should i select/use for creating System DSN for a Universe & Unidata Stage.

kduke · Post by **kduke** » Wed Jun 08, 2005 10:30 pm

You do not need one for Universe. Use a UV stage. The DSN is localuv for hash files. I do not know about UniData. Maybe Dr. Ray does.

talk2shaanc · Post by **talk2shaanc** » Wed Jun 08, 2005 10:57 pm

I can give localuv, if my hash file lies on my local server. But what if it lies on some other server.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2005 2:59 am

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.

talk2shaanc · Post by **talk2shaanc** » Thu Jun 09, 2005 3:16 am

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

It gives me an error:

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

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2005 3:27 am

OK, install the UniVerse ODBC driver (it's on the UniVerse clients CD), configure it, and away you go.