i am using ODBC stage to connect the Netezza database. I am getting the following error,
Could not connect to datasourceError occurred while loading translation library
ODBC entry is available in odbc.ini file and entry to uvodbc.config also done.
Please help me in solving this issue.
Thanks in advance.
ODBC error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
Did u need the odbc.ini file entry if so find below..
[edwtest]
Driver = /usr/local/nz/lib/libnzsqlodbc3.so
Description = NetezzaSQL ODBC
Servername = edwtest
Port = 5480
Database = test_edw
Username = test_edw_etl
Password =
CancelAsFreeStmt = false
CommLog = false
Ksqo = false
Lie = false
Optimizer = false
Parse = false
PreFetch = 256
Protocol = 7.0
ReadOnly = false
ShowSystemTables = false
Socket = 16384
DateFormat = 1
TranslationDLL =
TranslationName =
TranslationOption =
Thanks
[edwtest]
Driver = /usr/local/nz/lib/libnzsqlodbc3.so
Description = NetezzaSQL ODBC
Servername = edwtest
Port = 5480
Database = test_edw
Username = test_edw_etl
Password =
CancelAsFreeStmt = false
CommLog = false
Ksqo = false
Lie = false
Optimizer = false
Parse = false
PreFetch = 256
Protocol = 7.0
ReadOnly = false
ShowSystemTables = false
Socket = 16384
DateFormat = 1
TranslationDLL =
TranslationName =
TranslationOption =
Thanks