Results 1 to 2 of 2
-
01-09-2010, 03:40 PM #1
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.
-
02-02-2010, 11:18 AM #2
problem solved
Similar Threads
-
Directory submission tips
By eusha in forum DirectoriesReplies: 92Last Post: 05-20-2012, 09:36 PM -
Free Search Engine Submission Links
By Nazia in forum All Other Search EnginesReplies: 28Last Post: 01-31-2012, 02:50 AM -
Backlink, grow ur Knowledge!!!
By Oglacs in forum Search Engine OptimizationReplies: 36Last Post: 12-22-2011, 03:57 AM -
Web Hosting Service
By shovakoirala in forum Web HostingReplies: 7Last Post: 10-04-2011, 05:06 AM -
All You Need To Know About SEO
By articleenterprise in forum Search Engine OptimizationReplies: 19Last Post: 04-13-2009, 02:14 AM




Reply With Quote

