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]
