ODBC Configuration on SOLARIS

[shiv_nm]

Hi,
Kindly Give me some clue how to Configure ODBC driver on SOLARIS.


I have .odbc.ini file which has code like this for SQL connection:

[SQLDSN]
Driver=/export/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=Source
LogonID=odbc01
Password=odbc01
Address=172.28.2.51,1433
QuotedId=No
AnsiNPW=No


Now where i have to have this file?


There is one more file "dsenv".

ond
one more file "uvodbc.config"

Can you specify me what all changes i have to make in these 3 files and which directories i should place these files?

Waiting for the kind Response urgently.

Thanks and Regards
Shiv

[MaheshKumar Sugunaraj]

Hi,

The Steps are as follows:

1. got to the .odbc.ini
Give the name of the connection, then pass the User ID/ PWD and also give the IP Address,Port number.

If needed you can test the connection by going into the example directory and run example and pass the Conenction Name and UserID/PWD

2. Then once the above is done, you should gointo the Project Directory and go to uvodbc.config file and pass the conenctionname and DBMSTYPE = ODBC needs to be set.

3. Then you can open the Data Stage designer and import the Table Definitions.

Issue:

Mostly the issue which you get is the database needs to have access on the Box I mean you should have access to it or the database needs to be added to the box.

Hope this helps. Please let me know incase you have any issues.

Thanks & Regards
Mahesh