I run Redhat 9, but this should be similar for you. I installed unixODBC (rpm -i unixODBC-2.2.3-6) /etc/odbc.ini is
[db] Driver = MySQL Server = 192.x.y.z Database = db Port = 3306 Socket = Option = Stmt = /etc/odbcinst.ini is [MySQL] Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so FileUsage = 1 CPTimeout = CPReuse = The above works. >We are trying to install ODBC on Linux (Red Hat 8.0) so as to connect >with MySQL. Our Linux admin wrote the following about the problem. >Can anyone provide some insight or point us to a cogent installation >guide for ODBC on Linux? Many Thanks! > > >The test (using isql) fails, and it's not clear why. Details below... >I'm wondering if the Witango people have some info or be able to help? > > [EMAIL PROTECTED] etc]# isql -v folklife > [unixODBC][Driver Manager]Data source name not found, and no >default driver specified > [ISQL]ERROR: Could not SQLConnect > >However I believe the .ini files should be right. And if I use the >odbcinst -j (show config) option, it points to these files. > > >The libmyodbc (driver files) that are installed are: >/usr/lib/libmyodbc3-3.51.06.so >/usr/lib/libmyodbc3_r-3.51.06.so >(the files mentioned below also exist as softlinks to these) > > >/usr/local/etc/odbcinst.ini: > [MySQL] > Description = MySQL driver > Driver = /usr/lib/libmyodbc3.so > Setup = /usr/lib/libmyodbc3_r.so > > >/usr/local/etc/odbc.ini > >[ODBC Data Sources] > >myodbc = MySQL ODBC 2.50 Driver DSN >myodbc3 = MySQL ODBC 3.51 Driver DSN > >(default ones still there plus this one I added:) > [folklife] > Driver = /usr/lib/libmyodbc3.so > Description = MySQL ODBC 3.51 Driver DSN > SERVER = localhost > PORT = > USER = root > Password = > Database = folklife > OPTION = 3 > SOCKET = > > >Also, I tried using the odbcinst program, but that's failing too. Here's >the template file I have in my home dir: > [MySQL-test] > Description = MySQL test database > Trace = Off > TraceFile = stderr > Driver = MySQL > SERVER = localhost > USER = root > PASSWORD = > PORT = 3306 > DATABASE = test > > >If I run it (as root) I get this: > > odbcinst -i -s -f odbctemplate > odbcinst: SQLWritePrivateProfileString failed with General >error request failed. > odbcinst: SQLWritePrivateProfileString failed with General >error request failed. > >I couln't find anything about the error, there's no man page, and no >--help option... >________________________________________________________________________ >TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
