when i executed the code taken freshly the following was the error
+6
A:
The account that CF is using to access your SQL Server doesn't have permission to run that stored procedure.
orthod0ks
2009-09-16 20:25:31
i have admin access to SQL 2005 and the CFserver is my Devsevert opn which i have been working since feww months.
Rames
2009-09-16 20:32:07
@dan: An "access denied" error is unambiguous. Check your configuration (data sources in CF Administrator, ColdFusion ODBC Service account, SQL Server). I'm sure you find a glitch in there somewhere.
Tomalak
2009-09-17 08:57:34
CFIDE is missing in my CF folder.
Rames
2009-09-17 13:03:41
and I? cannot find the SQL stored procs, tables etc in my SQL DB
Rames
2009-09-17 13:04:33
If you suddenly can't find anything in your database, either everything was deleted, or somehow your access has been revoked (more likely since you're getting the access denied error).
orthod0ks
2009-09-17 13:22:12
i had the data base showing corrupt message ,DB was restarted and the error rectifyed.
Rames
2009-09-18 03:04:45
A:
Another possibility is that the data source as defined in ColdFusion Administrator has specifically turned off Stored Procedures under "Allowed SQL". Check the advanced settings for that data source.
Al Everett
2009-09-17 12:17:30