I'm going to go the route of creating the tables
manually.
Is there any other tables I need to create besides
cdata and cglobal?
Thanks,
Chris
--- Daryl Banttari [EMAIL PROTECTED] wrote:
Sounds like you have either (A) disabled one or more
operations for that
datasource through the CF Administrator or (B)
restricted the rights of the
database user in the datasource setup, and that user
is not allowed to
create tables.
If you can create the tables manually, do so, and
just create the client
store without having CF create the tables for you.
Or, briefly "fix" the
permissions problem in the CF Administrator.
Daryl Banttari
Macromedia Consulting (Still getting used to
that...)
- Original Message -
From: "Chris" [EMAIL PROTECTED]
To: "KCFusion-List" [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 9:57 AM
Subject: [KCFusion] Changing client variable storage
I am wanting to change the client variable storage
on
our webserver from the registry (default) to a
datasource. However when I go through the CF
administrator I get this error.
SQL operation unrecognized
The SQL operation you specified is unrecognized
(only
SELECT, INSERT, UPDATE, DELETE, and CALL are
supported). SQL = 'create table CDATA ( cfid
char(20),
app char(64), data text )'
http://cfide/administrator/variables/editcbsinfo.cfm
I've logged in through query analzyer and I can
run
the create table command without any problems.
Any ideas of why I would be getting this error?
Chris
__
The KCFusion.org list and website is hosted by
Humankind Systems, Inc.
List Archives
http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise..
mailto:[EMAIL PROTECTED]
To Subscribe
mailto:[EMAIL PROTECTED]
To Unsubscribe
mailto:[EMAIL PROTECTED]
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]