1

Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

view story
linux-howto

http://www.unix.com – Hi , I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0 I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH, ODBCINI , ODBCSYSINI etc . Getting the error as Code: [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect Kindly help Moderator's Comments: Video tutorial on how to use code tags in The UNIX and Linux Forums. (HowTos)

robot1's picture
Submitted by robot1 on 05/25/2012

Stories similar to Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

[ubuntu] libmdbodbc1 32 weeks 5 days ago

Running 12.04 precise and libmdodbc1 with unix odbc.

Hi, I installed Db2 9.7 on RHEL5 32bit . Instance Name is db2inst1 amd in that i created database as mydb. I exported env variables for classpath ,db2dir,db2instance LD_LIBRARY_PATH ,PATH ,ODBC, ODBCHOME ,ODBCINI My application needs ODBC connectivity and so I modified odbc.ini file .

I have installed unixODBC from source and mysql-odbc connector from .dmg installer on Mac OSX Lion. This was done a while ago, and at that time I successfully installed a data source (let's call it foo). Now I am trying to add another data source (DSN).

RHEL5 Linux ODBC Issues 5 weeks 5 days ago

Am trying to move my compiled C code that connects to mssql database servers from using the datadirect odbc drivers to using the unixodbc driver manager (version 2.3.1)/ freetds drivers (version 0.91) which are already compiled for 64 bit and available.

Am able to successfully compile it on 64 bit RHEL5 Linux by linking in libodbc which has already been compiled.

I am using Linux RHEL5 64 bit and installed oracle 11g. I want to check ODBC connection , i had modified odbc.ini file when i use this command -isql I am getting following error . bash: isql: command not found

Kindly help

I've just setup unixODBC with libmyodbc.

isql -v mydb Works perfect. I can run SELECT commands, updates etc. no worries.

I'm trying to access an MSSQL server via ODBC and FreeTDS - I've hit a strange config issue. The isql command allows me to access the server perfectly, but only when I'm in the /usr/lib64 directory, where the odbc .so files are located. Anywhere else it throws the above error, even with /usr/lib64 in my path.

Any insight?

I'm trying to get MSSQL working on Ubuntu 12.04 via ODBC, and I've followed these steps to the letter:

http://jamesrossiter.wordpress.com/2...ubuntu-server/

However, this omits both of these files that are pointed at in odbcinst.ini:

Code: Driver = /usr/lib/odbc/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so So, I googled a bit and found this:

http://ubuntuforums.org/showthread.

unixODBC dbf(xbase) driver 47 weeks 2 days ago

Hello everybody.I installed the Centos 6 packages qt3-ODBC, unixODBC, etc.. I can see the odbc driver for Postgres and Mysql by ODBCAdministrator.Does anyone know whether th... [by jlgazoli]