-----Original Message-----
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 11:57 AM
To: CF-Talk
Subject: sql new user woes
Hi all:
Up until now I have only used Access as a backend for all of our apps. I
have recently installed SQL 2000 on my computer and am trying to get a
simple query running, but I keep getting the error:
[Macromedia][SQLServer JDBC Driver][SQLServer]SELECT permission denied on
object 'test_data_table', database 'RayTestDB', owner 'dbo'.
<cfquery name="testq" datasource="RCTestTable" dbtype="ODBC">
SELECT *
FROM test_data_table
</cfquery>
I have messed around with all the permissions that I could find, but I
still get the same error. I know that I have registered the database
correctly in CFAdmin. I am at a loss as to why this is happening...this is
my first go at this, so I could be 180 degrees off and not know it. And
this stupid 'dummies' book is about as worthless as...well, I will leave
that up to your imagination.
Does this throw up any big flags for anyone? Sure could use a boost after
sitting here for the better part of my morning!
Ray
http://www.crystalvision.org
=============================================
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=============================================
The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
