[unixODBC-support] MySQL Driver Help

[Richard Layton]

Thank you! Got it working.


-----Original Message-----
From: unixodbc-support-bounces at mailman.unixodbc.org
[mailto:unixodbc-support-bounces at mailman.unixodbc.org] On Behalf Of Maxim
Veksler
Sent: Thursday, December 04, 2008 2:25 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] MySQL Driver Help

Hello,

On Thu, Dec 4, 2008 at 11:52 PM, Richard Layton <rlayton at gmail.com> wrote:
> Can someone help with getting MySQL to work with ODBCConfig.
>
>
>
> Specifically what do I put in Driver Properties.
>
> I have:
>
> Driver: /usr/lib/odbc/libmyodbc.so
>
> But what do I put for Setup?
>

We have this in our /etc/odbc.ini file :

"""
[ODBC Data Sources]
myodbc5-medialayers     = MyODBC 5.1 Driver DSN

[myodbc5-OURDB]
Driver       = /usr/lib/libmyodbc5.so
Description  = Connector/ODBC 5.1 Driver DSN
SERVER = localhost
PORT         =
USER         = DBUSER
Password     = DBPASS
Database     = OURDB
OPTION       = 0
charset      = utf8
SOCKET       = /var/lib/mysql/mysql.sock
"""

and it seems to work fine.

>
>
> -Richard
>
>
>
>
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>



--
Cheers,
Maxim Veksler

"Free as in Freedom" - Do u GNU ?
_______________________________________________
unixODBC-support mailing list
unixODBC-support at mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support