yep I think your right, I think Francis should go in and
make sure that the login name and password for the DSN are
actually entered in. or include the username and password
options in the <<cfquery>
Fred
----- Original Message -----
From: "Lee Moore" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 01, 2000 10:15 AM
Subject: Re: SQL7 + CF studio pb !
> I'm not exactly a guru but it sounds like the login info
specified in your
> ODBC connection being used in CF studio does not have the
proper permissons
> set up to see those particar tables. You might try going
into sql enterprise
> manager and double clicking on the table you want to see.
There you will see
> a permisissions button on the upper right hand cornor of
the pop up
> properties box. Click on it and you will be able to
specify permissions for
> that table to the user specified in your ODBC connection.
>
> I'm could be wrong. I'm just shootin from the hip here.
>
> Lee
>
>
> ----- Original Message -----
> From: Francis NART <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 01, 2000 9:54 AM
> Subject: SQL7 + CF studio pb !
>
>
> > I'm brand new to SQL server 7 and I have a little pb.
> > Each time I want to access my tables through CF studio
in the database
> Tab,
> > I only get the system tables and not the one I created
manually.
> >
> > I get an error when I try to access those newly created
tables.
> > Using the SQL server query analyser I've got no problem
accessing thoses
> > tables...
> >
> > Could a "SQL server Guru" help me on this ?
> >
> > Thanks
> >
> > Francis.
>
> ----------------------------------------------------------
----------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or
> send a message to [EMAIL PROTECTED] with
'unsubscribe' in
> the body.
> >
>
> ----------------------------------------------------------
--------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
