how to connect remote coldfusion to remote mysql
Posted on 2005-04-02
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