Thanks for your replies, it was a DSN problem (passwords...).
Francis.
At 14:51 31/05/00 -0500, vous avez �crit:
>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.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
