?
Solved

ColdFusion error trying to connect to SQL dbase

Posted on 2008-10-21
4
Medium Priority
?
521 Views
Last Modified: 2013-12-20
I have no rights to the coldfusion server or sql server...they were supposed to have setup my datasource today so that I could connect to the SQL database; however, when i try to run a query i get the following:

Security: The requested template has been denied access to SupportNet.  
The following is the internal exception message: access denied (coldfusion.sql.DataSourcePermission MYDNSNAME)  

What needs fixed?
0
Comment
Question by:Lee R Liddick Jr
[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
4 Comments
 
LVL 27

Expert Comment

by:azadisaryev
ID: 22773040
what does your query look like?
are you sure you are using a correct dsn name?
are you sure they have actually set up the dsn already?
0
 

Author Comment

by:Lee R Liddick Jr
ID: 22774825
It's just a simple query, select * from table_a.  <cfquery datasource="MYDNSNAME">.
Using the dsn name that I gave them to setup.
They sent an email and told us it was setup.
0
 
LVL 27

Accepted Solution

by:
azadisaryev earned 1200 total points
ID: 22775020
well, select * from table should run fine - it does not require any special privileges your host might have disabled...

i suggest you double-check with them about correct dsn setup. ask them to make sure it verifies in their cf admin.

also make sure you are not mistyping the dsn name. like in your above example you are using MYDnsNAME, when it is rather likely that it may be MYDsnNAME (ns vs sn). also, if MYDNSNAME is a cf variable, you must enclose it in ##...
0
 

Author Comment

by:Lee R Liddick Jr
ID: 22775058
I just used that as the example name, the actual name is SupportNet (case specific).  I guess I will need to check with them today.  Thanks.
0

Featured Post

Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
What You Need to Know when Searching for a Webhost Provider
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
Suggested Courses

752 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