Re: MySQL ODBC Connector and iODBC woes.

Patrick B. Day wrote:

> Hello,
>
> Firstly, I know unixODBC works best with MySQL's ODBC drivers, but I'm
> trying to get Stata 9 Linux (a commercial statistical package) to work
> with MySQL and it uses iODBC. So I'm stuck, which sucks because everything
> was working fine with unixODBC.
>
> So I compiled and installed iODBC latest (3.52.3) in /usr/local. unixODBC
> is still installed as a SuSE package under /usr and I'm hoping they'll not
> interfer with each other.
>
> Now will compiling from source mysql-connector-odbc-3.51.12, there was a
> conflict in the definition between MySQL's SQLColAttribute defined in
> result.c and iODBC's sql.h. I noticed that using the __APPLE__ define the
> definitions are correct for OSX. I'm guessing that's because OSX uses a
> variant of iODBC.
>
> Now my question. Can I change the definition in result.c so everything
> will compile or will there be side effects elsewhere?
>
> Also what problems can occur by having both unixODBC and iODBC installed?
>
> Thanks for any help you can offer.
>
> -Pat.
>
> ============================
>
> Patrick Day
> uf069@xxxxxxxxxxxxxx
>
>  

Yes; iODBC (or version thereof) is used on OSX so I would expect that 
you can use the apple defined code you speak of in this case.

I do not recommend having two driver managers on the same system - 
however; it is possible that this will work for you.

Let us know how your effort goes.


--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx