Hi Gurus,
Can we have two odbc entries with the same DB name only difference is server name?
Thanks for your effort and time. I appreciated it.
KFT_4875_STGQ29=NetezzaSQL
Driver=/opt/nz/lib/libnzodbc.so
Description=NetezzaSQL ODBC
Servername=<serer1>
Port=5480
Database=KFT_4875_STGQ29
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=
KFT_4875_STGQ29=NetezzaSQL
Driver=/opt/nz/lib/libnzodbc.so
Description=NetezzaSQL ODBC
Servername=<server2>
Port=5480
Database=KFT_4875_STGQ29
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=
can we have two odbc entries in the same DB name?
Moderators: chulett, rschirm, roy