[egenix-users] MS SQL ODBC connect problem ("Option not supported")

[M.-A. Lemburg]

Tim Jones wrote:
> sorry I thought I was replying to the message. Anyways the subject of the message is the same with date being Tue Aug 17 10:43:36 2004 started by Robby Dermody. Specifically you mentioned taking the ; out of the DSN string after PWD and checking the odbc.ini file. Like Rob said I can use isql, tsql, and iodbctest fine but the mx unixODBC or iODBC does not seem to work properly with FreeTDS.

I haven't heard of any reports in either direction.

Looking at the old posting (appended below) and the version numbers
mentioned in it, I'd suggest that you simply upgrade to the latest
versions of all components. FreeTDS has seen a lot of development
since 0.61, egenix-mx-commercial is now at version 2.0.7 and
the other components have also had a lot of development since August
2004.

> thanks
> Tim Jones
> 
> -----Original Message-----
> From: M.-A. Lemburg [mailto:mal at egenix.com]
> Sent: Friday, April 29, 2005 12:02 PM
> To: Tim Jones
> Cc: egenix-users at lists.egenix.com
> Subject: Re: [egenix-users] MS SQL ODBC connect problem ("Option not
> supported")
> 
> 
> Tim Jones wrote:
> 
>> 
>>-----Original Message-----
>>From: Tim Jones 
>>Sent: Friday, April 29, 2005 10:58 AM
>>To: egenix-users at lists.egenix.com
>>Subject: [egenix-users] MS SQL ODBC connect problem ("Option not supported")
>>
>>
>>
>>Has anybody solved problem.  The things suggested by Marc-Andre do not work. I have the exact same setup on Redhat Linux and it works fine ... it just does not work on AIX 5.1
> 
> 
> Can you provide some context with your problem report. What have
> I suggested and where ?
> 

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Apr 29 2005)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

> Robby Dermody wrote:
> 
>> Hi guys,
>>
>> This problem has been causing me to pull my hair out for the last day or
>> two. I'm trying to use mxODBC under Debian Linux 'unstable' to connect
>> to a MS SQL database via either unixODBC or iODBC.
>>
>> Relevant versions:
>> mxODBC: 2.0.6
>> mx-base: 2.0.5
>> unixodbc: 2.2.4-9
>> iodbc: 3.51.2
>> freetds: 0.61
>>
>> With both unixODBC and iODBC, I have installed them, configured
>> odbc.ini, and can use their test programs to connect to this database
>> and query it fine. No problems there. However, when I mix mxODBC into
>> the picture and try to connect via that, I get something like the
>> following:
>>
>>
>>>>> db =
>>
>>
>> mx.ODBC.unixODBC.DriverConnect("DSN=testdsn;UID=testuser;PWD=pass;")
>> Traceback (most recent call last):
>>   File "<stdin>", line 1, in ?
>> mxODBC.NotSupportedError: ('S1C00', 1, '[unixODBC]Option not supported',
>> 5921)
>>
>>
>> Here's the mxodbc.log output (when compiled in 'debug' mode):
>>
>> mxODBC_New_UseDriverConnect: dsn='DSN=testdsn;UID=testuser;PWD=pass;',
>> clearAC=1
>> mxODBC_ReportError: sqlstate='S1C00' code=1 text='[unixODBC]Option not
>> supported' lineno=5921 rc=-1 mxODBC_New_UseDriverConnect: failed.
>> mxODBC_New_UseDriverConnect: dsn='DSN=testdsn;UID=testuser;PWD=pass;',
>> clearAC=0
>> mxODBC_ReportError: sqlstate='S1C00' code=1 text='[unixODBC]Option not
>> supported' lineno=5921 rc=-1
>> mxODBC_New_UseDriverConnect: failed.
>>
>>
>> I get the same output from iodbc, "Option not supported". Any idea how
>> to find out WHAT option they're talking about? Note I get the same error
>> when using Connect(), and as you can see, I've tried it with both clear_auto_commit=1 and clear_auto_commit=0 ...same thing each
>> time.
>>
>> I'm thinking this is a problem between mxODBC and unixodbc/iodbc....and
>> that it has nothing to do with freeTDS or the MS SQL server itself.
> 
> 
> mxODBC does work with FreeTDS, so the problem must be with your setup.
> 
> Two things:
> 
> 1. try to remove the final ";" in your DSN
> 
> 2. check your odbc.ini file whether you are using unsupported
>    connection options.
> 
> -- 
> Marc-Andre Lemburg
> eGenix.com
> 
> Professional Python Services directly from the Source  (#1, Aug 17 2004)
>>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> ________________________________________________________________________
> 
> ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::