DSNless ODBC Connection
"Mauch Chunk Opera House" <[email protected]> Fri, 22 Jul 2011 11:09:35 -0400
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <006901cc4881$5e6b1980$1b414c80$@net> |
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