Solved

ColdFusion error trying to connect to SQL dbase

Posted on 2008-10-21
4
514 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
  • 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 300 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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

856 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