Its been quite a while since I posted on this blog. Guess was caught up in the nitty-gritties of life.
Today's post is about the entries needed in the .odbc.ini file for creating a new ODBC Connection.
Here are the steps -
1) Login to the Unix Server.
2) Go to the path
'appl/infosphere/InformationServer/Server/DSEngine'
3) Take a backup of the '.odbc.ini' file.
4) Add the Database entry in the '.odbc.ini' file.
[Database Name]
Driver=/appl/infosphere/InformationServer/Server/branded_odbc/lib/VMmsss23.so
Description=DataDirect SQL Server Wire Protocol driver
Database=#Database_Name#
LogonID=#User ID#
Password=#Password#
Address=IP Address,Port No.
QuotedId=No
AnsiNPW=No
5) Go to the path
'appl/infosphere/InformationServer/Server/DSEngine'
6) Take a backup of the 'uvodbc.config' file.
7) Add the following entry in the 'uvodbc.config' file.
DBMSTYPE = ODBC
DBMSTYPE = ODBC
Tags
Datastage