[unixODBC-dev] Connection to MS-SQL

Peter Harvey peterh at mysql.com
Fri Jul 23 11:30:03 BST 2004

Use the following to determine the place where unixODBC wants the ini files.

$ odbcinst -j
The System DSN file can exist but be empty.

Be careful - you do not want multiple versions of unixODBC installed. In
general; when you install a binary package the files go in /usr while
building and installing from source will place the files in /usr/local.

Peter Harvey, Software Developer MySQL AB 
Office: +1 619 251-6923 
Are you MySQL certified? www.mysql.com/certification 

-----Original Message-----
From: unixodbc-dev-bounces at mail.easysoft.com
[mailto:unixodbc-dev-bounces at mail.easysoft.com] On Behalf Of Alejandro
Sent: Tuesday, July 20, 2004 9:06 AM
To: Development issues and topics for unixODBC
Subject: Re: [unixODBC-dev] Connection to MS-SQL

Thanks!! to both...

I found the following

/usr/local/etc/odbc.ini with my system DSN ~/.odbc.ini with the local DSN

AND ....
with [default] section pointing to MySQL driver... maybe from the original
setup of Mandrake or whatever...

But now I have another question... (If I can abuse)

If "isql pp3 root" and "isql pp4 sa" works OK against both databases, means
that they are using the .ini I prepare during installation
(/usr/local/etc/....)... Right? As a matter of fact, ODBCConfig (GUI) shows
me what I have in this .ini also.

But now that I know that up to now I was just -VERY- lucky (my program
stopped working at all when I renamed  /etc/odbc.ini with the nasty error
"Data source name not found and not default driver")...

My question is, How can I tell everybody to use the same .ini?

Thanks again

----- Original Message -----
From: "Peter Harvey" <peterh at mysql.com>
To: "'Development issues and topics for unixODBC'"
<unixodbc-dev at mail.easysoft.com>
Sent: Monday, July 19, 2004 7:01 PM
Subject: RE: [unixODBC-dev] Connection to MS-SQL

> Please check your User AND System data source name entries.

unixODBC-dev mailing list
unixODBC-dev at mail.easysoft.com

More information about the unixODBC-dev mailing list