[unixODBC-dev] Connection to MS-SQL

Martin J. Evans martin at easysoft.com
Mon Jul 26 09:10:10 BST 2004


You could also try file DSNs. FILEDSN=file in connection string.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development


On 23-Jul-2004 Stefan Radman wrote:
>> Be careful - you do not want multiple versions of unixODBC 
>> installed. In
> 
> He's very right. You better don't ...
> 
>> My question is, How can I tell everybody to use the same .ini?
> 
> ... but if you have no choice use
> 
>   ODBCSYSINI=/usr/local/etc; export ODBCSYSINI
> 
> and any unixODBC installation will ignore your /etc/odbc*.ini
> If you continue to have the same problem after all you probably have
> some driver or dsn in /etc/odbc*.ini that you need to move over to
> /usr/local/etc/odbc*.ini
> 
> Stefan
> 
>> -----Original Message-----
>> From: unixodbc-dev-bounces at mail.easysoft.com 
>> [mailto:unixodbc-dev-bounces at mail.easysoft.com] On Behalf Of 
>> Peter Harvey
>> Sent: Friday, 23 July, 2004 12:30
>> To: 'Development issues and topics for unixODBC'
>> Subject: RE: [unixODBC-dev] Connection to MS-SQL
>> 
>> 
>> 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
>> Rotolo
>> 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 ....
>> /etc/odbc.ini
>> 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
>> Alejandro
>> 
>> ----- 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
>> http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
>> 
>> _______________________________________________
>> unixODBC-dev mailing list
>> unixODBC-dev at mail.easysoft.com
>> http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
>> 
> 
> _______________________________________________
> unixODBC-dev mailing list
> unixODBC-dev at mail.easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-dev




More information about the unixODBC-dev mailing list