Thread: How to link MySQL database to .cfm page on a hosting server

Dear All,

I need your help to guide me how to link MySQL to the web site on the hosting server.

I’ve received an email from my hosting provider explaining what I need to put in my code in order to link MySQL database to my web site:

“In your connection string, localhost or my sql server IP is the default which is used as server name. On our server we have mapped MySQL Server IP to mysql.server
If you have a script which connects to the database or you are creating a ColdFusion DSN, than you must use mysql.server as server/hostname instead of localhost or mysql server IP. “

So far I was using MSAccess and I had not problems using it. In my new project for the first time I am using MySQL instead.

It is working fine on my developing machine (CF8 + DW + MySQL 5.0). When using MSAccess I only created variable on Application.cfm where I set Request.DSN = “dbname" without specifying any connection strings as the email suggested and it worked fine after uploading otno their hosting server.

However reading the email from the hosting company I have no clue as to how to link both MySQL database and the web site.

I would realy appreaciate if you could help me in this . Please let me know if you hav e any questions or you need more info regarding this case.

problem solved