Solved

ColdFusion error trying to connect to SQL dbase

Posted on 2008-10-21
4
518 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 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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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 add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

739 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