Solved

Cold Fusion hosting on Network Solutions

Posted on 2013-05-30
6
593 Views
Last Modified: 2013-06-22
I have a client that is hosting their site with Network Solutions.  They have Cold Fusion available... that I have verified,.  I cant seem to connect to the database via the normal connection strings.  Am I missing a key attribute that NetSol requires?


<!--- // connections and such // --->
<cfparam name="request.dsn" default="xxx_dsn">
<cfparam name="request.dsnUsername" default="xxx_user">
<cfparam name="request.dsnPassword" default="xxx_userPass">
<cfparam name="request.dsnDatabase" default="343.22.111.434">

Open in new window

0
Comment
Question by:14_east
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 39212426
did you logged into the control panel of the Network solutions which they have given to the client to manage the account.

check the Coldfusion DSN there and check the following lib by ben forta to verify the DSN

http://cflib.org/udf/VerifyDSN

Ray's Blog:

http://www.raymondcamden.com/index.cfm/2009/4/15/Did-you-know-you-could-verify-DSNs-with-ColdFusion-code
0
 
LVL 36

Accepted Solution

by:
SidFishes earned 300 total points
ID: 39259786
If you haven't set up the DSN using cfadmin, you can't connect to a DSN unless you use DSN-less connections which uses a java classloader to connect to the JdbcOdbcDriver

http://www.hosting.com/support/mysql/coldfusionstring

but that's overly complex. The solution is to set up the DSN in cfadmin. If NetSol doesn't provide access, you need to find another SP.
0
 

Author Comment

by:14_east
ID: 39266425
I've requested that this question be deleted for the following reason:

we moved the website off network solutions.  no need to know anymore...
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 39266426
" If NetSol doesn't provide access, you need to find another SP."

"we moved the website off network solutions.  no need to know anymore..."

How is my answer not exactly what you did?
0
 

Author Comment

by:14_east
ID: 39266460
didnt see it.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question