Odbc

[spider99]

I'm new to using Linux CentOS and do not know how odbc works at all with Linux, i've read a few guides and i've downloaded unixODBC and installed it by running

./configure
make
makeinstall

so far so good, but now what do i do to create/remove and run odbc and is there any way i can have some sort of gui when adding odbc?

[scathefire]

http://www.unixodbc.org/doc/

chances are you will be putting freetds on there as well, but i suppose it depends on what you are doing with ODBC.

[spider99]

I will be using Freetds with unixodbc, does unixodbc or freetds come with a gui program on setting up odbc links? if so then which and how will i be able to run them?

[scathefire]

when i did it i did it like this basically, since it was a PHP application. not sure about a GUI:

http://www.unixodbc.org/doc/FreeTDS.html

[spider99]

I'm trying to set up ODBC links using ODBCConfig, i've downloaded unixodbc and installed it using configure,make and makeinstall but when I go to the shell, su, and enter ODBCConfig I get command not found. I've searched my hard drive and cannot find it anywhere. Is there another package I need to install?

[scathefire]

on my system it was called odbc_config, but again i did not do it via the GUI so YMMV.

[scathefire]

you may want to also do a yum search for unixODBC-gui-qt, or maybe even unixODBC to see what packages are available to you

[spider99]

odbc_config and OBDCconfig are 2 completely different commands. ODBCconfig is the command to launch the GUI interface for adding or removing ODBC links, but when i try the ODBCconfig command is says command not found...does anyone know the package i must download/install to get this to work?

[scathefire]

did you try unixODBC-gui-qt or unixODBC-gui? might warrant a 'yum search' to see the packages are available on centos.