ODBC in uvodbc.config

[bigpoppa]

Hi. I have a an odbc connection defined in my uvodbc.config file:


DBMSTYPE = ODBC
network = TCP/IP
service = unix06
host = 1.0.0.0

When I go to Manager-->Import Table Defns-->ODBC Table Defns, 'database1' shows up in the DSN drop down box. When I try to use the ODBC stage, 'database1' does NOT show up in the 'data source name' drop down box. Any ideas why this would happen?

Another clue is that I'm sourcing a ODBC ini file in dsenv, but 'database1' is defined in there too.

- BP

[WoMaWil]

Hi BigPoppa,

To get ODBC right is not easy.

There are 3 place, where you have to look (and mybe change)

(1) The .odbc.ini-file
(2) The uvodbc.config
(3) The dsenv

There are also checkprogramms on the server to check if ODBC is done okay.

Read the manual for this 3 places and you will succeed.

Wolfgang

[ariear]

You'll get the DSN in the ODBC stage the moment you'll import somthing and save it in your repository or just add manually an entry ODBCDSN nameSome_table_name or type in the DSN name - it will work