Re: DSNless ODBC Connection

Hi,
I think if you add AUTO_RECONNECT=1 to your connection string - it 
should do the job.

lawrin

On 22.07.2011 18:09, Mauch Chunk Opera House wrote:
> I connect to a MySQL database from Access using a DSN-less connection. What
> must I change in the ODBC string in order to keep the connection alive for
> more than a minute?
>
>
>
> When I set up a DSN on my machine, I just check off the auto-reconnect
> feature in the MySQL ODBC Connector, then the connections stay up.
>
>
>
> How do I do this using a DSN-less connection string?
>
>
>
> Dan Hugos
>
> Mauch Chunk Opera House
>
> Jim Thorpe, PA
>
> www.MauchChunkOperaHouse.com
>
> 570-325-2082
>
>
>
>

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]