Using DSN alternatives with MYSQL

[ajetrumpet]

all,

does anyone know where I can get a list of all connectivity methods for Access and MySql? the MYSQL documentation pages are not very helpful.



I have found out that on a Linux-based platform, DSN is not supported with MYSQL unless it is through coldfusion scripts. Now, what that means I have no idea. I know what cold fusion is, but I'm not sure how the 'scripting' part of that relates to a FILE DSN.

So what I have got from my hosting company is that there is more than one method to connect to a mysql server, and that I should use one of those if I want to use Access with mysql. does anyone have experience? More than that though, I need a resource of the different ODBC methods that are out there so I can figure out which one would be the best for an Access/Mysql partnership.

thanks much!

[ssanfu]

Try

http://www.connectionstrings.com/

or

http://www.dofactory.com/Connect/Connect.aspx

[ajetrumpet]

I will take a look. tx.