ODBC DSN Help
 

I'm not exactly a Linux Newbie. But this is an appropriate question for this forum, I think.

I've read : http://www.easysoft.com/developer/in...ystem_unixodbc

But, unfortunately the current unixodbc package is broken in Linux Mint 12.0 or probably all Linux distros (installs fine and the tools it includes work fine). The Gui management tool has been removed from the package. There is no gui install candidate. So the directions for creating a DSN in the above mentioned link and all the other links I could find are useless. There is no odbc manager (except as a svn code source).

Could someone provide a real life example of an entry for the odbc.ini file. I want to create a System DSN, manually. I have a VPN tunnel to a MS SQL Server server, and want to open up a connection in TOra. But I need a DSN beore I can start to do that. I don't really want to include a uid and password in the file, but whatever it takes. This is a commercial client's database, not some toy or personal db.

Thanks!
Jack

If you haven't seen these samples already, how to create DSN is described here with example:

http://stackoverflow.com/questions/4...a-dsn-in-linux
http://download.oracle.com/otn_hoste...nix_linux.html

Thanks!

I'd seen the first link. Not really a real world example. It didn't help me. The second however, I think answers my need. Although, I'm still not positive on what I need to put on the driver line to connect to a Windows SQL Server from my Linux desktop with unixodbc, libqt4-sql-odbc.so is the only candidate I can think of to use. But the qt4 part disturbs me.

Thanks.