-----Original Message-----
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 12:07 PM
To: CF-Talk
Subject: RE: sql new user woes
That was it. God, I felt like such a dumbass - thank you thank you thank you
Ray
http://www.crystalvision.org
At 01:01 PM 3/30/2004, you wrote:
>make sure the user you used to set up the datasource connection in CF
>Administrator is the same you are using in the SQL. Did you check the
>table persmission directly for that user?
>
>-----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]
