[AccessD] Connect Access app to MySQL using a connection string not a DSN

Found this at http://kb.globalscape.com/KnowledgebaseArticle10063.aspx

*DSN-less connections to a MySQL database*

The following string demonstrates an example connection string for a MySQL
database:

Provider=MSDASQL;DRIVER={MySQL ODBC 3.51
Driver};SERVER=10.10.10.1;DATABASE=Example;UID=myusername;PWD=mypassword;

 *NOTES:*

   - Do not put any line breaks in your connection strings.
   - You must have MDAC version 2.7 or higher to use a DSN-less connection.



On Sat, Mar 9, 2013 at 3:36 PM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> I have the string itself. I'm not sure how to use it. New connection object
> and assign the string to it? Normally I've used DSNs to connect, but I need
> to learn how to do it DSN-lessly.
>
> TIA
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>