14

Adding data sources for unixODBC/isql on Mac OSX Lion

view full story
linux-howto

http://serverfault.com – 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). I've done this through both ODBC Manager and the command-line tool myodbc-installer given with the tar bundle of the mysql-odbc connector from the mysql website. An entry shows up in /Library/ODBC/odbc.ini, which looks like this: [ODBC Data Sources] bar = MySQL ODBC 5.1 Driver [ODBC] Trace = 0 TraceAutoStop = 0 TraceFile = TraceL (HowTos)

u85500's picture
Submitted by u85500 on 06/03/2012 – Made popular on 06/03/2012

Stories similar to Adding data sources for unixODBC/isql on Mac OSX Lion

I've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have MySQL 5.5.19 installed on the laptop, and was able to connect to it via the Windows Data Source Administrator app and the MySQL Connector/ODBC using a TCP/IP connection to 'localhost'.

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:

Question:

I want to access a sybase database with mono. The only way that is currently possible is with ODBC. But I have problems setting up the Sybase ODBC connection.

I have successfully set up ODBC connections for MySQL, PostGre, FireBird, Oracle 11g and even Microsoft Access.

unixODBC dbf(xbase) driver 47 weeks 22 hours 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]

[ubuntu] libmdbodbc1 32 weeks 3 days ago

Running 12.04 precise and libmdodbc1 with unix odbc.

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?

Basically, my question is "Does this combo work for anyone," and, "Can you see what I am doing wrong"

I have installed 64 bit ODBC driver for sqlite, downloaded from this page. I am running powershell version 2 on window 7. In ODBC configuration I create a system DSN with name LoveBoat, pointing at a valid file.

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.