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!