Solved

ColdFusion error trying to connect to SQL dbase

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Strange space issue in Chrome browser 8 71
sql help 5 49
Impove long SQL Stored Procedure Performance 14 63
javascript to html map 8 38
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now