Solved

ColdFusion error trying to connect to SQL dbase

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Connect to MS-SQL server from Linux/PHP 8 85
Why is the output of this function is like this? 4 34
Restrict result set 1 39
Gulp not seeing Changes 4 56
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
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…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

773 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