I am working on a remote ColdFusionMX 6.1 server and want to be able to query my (home) remote MySql server with my queries from a remote host. I fully understand dsn's when i use them with the MySql server that our hosting company provides, but i am trying to use one from home so that i am not limited on space. I imagine i need a dsnless connection string to connect to a remote mysql right? when i run my winmysql 1.4 it tells me the server information (at home) is 4.0.18-nt. I would really appreciate a little snippet of code on how to impletment it with something like this..anyway, this is how i use it when i am not trying to access my home. Thanks for all the help.
<cfquery name="test" datasource="howden">
Select * from mold4 ORDER BY mold ASC
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.