can we have two odbc entries in the same DB name?

[albasir]

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=

[chulett]

Nope. They need to be unique.

[albasir]

Thanks Guru!

[chulett]

Technically... my understanding is you can have two with the same name, it's just that it will never find and use the second one.