yup sounds like it. You have to do what dan suggested by selecting a
default database that the DSN points to or be xplicit in your SQL statements
by stating the database, owner and table name e.g.: SELECT * FROM
database.owner.table
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 10:35
To: CF-Talk
Subject: RE: Exposing MS SQL7 Table to CF
I think what you might have done is not select a db in CF Admin when you set
up the datasource.
If you do not set up a database, then it will show you the master database,
which contains a load of system tables with odd names...
Have a look in cfadmin and see if a db has been specified... (Datasources,
ODBC, click datasource link, next to login info there is a box called
database - this should have the name of the db as specified under SQL
server...)
HTH
Dan,
PS (if you havent named the db, I have found that if you then add the db
name in cfadmin, you will be able to retrive it fine in CFML code, but it
wont show up right in cfstudio until you restart CF RDS service (but this
might just be me...))
-----Original Message-----
From: Eric Root [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 06:39
To: CF-Talk
Subject: Exposing MS SQL7 Table to CF
First time submission to CF-Talk and new to CF, so please be kind...
stupid question, but I gotta start somewhere, right?
Setting up a very simple SQL7 table and stored procedure to do my first
stored procedure call. Created the database. Set access to public for
all parameters. Entered data. Set up SP. Ran SQL7 query okay.
Created DNS. Data source shows up in Studio data resource tab. Data
source verified in the CF administrator.
Problem: The table I created is not listed in the data source tree.
Tables such as dbo.MSreplication, dbo.spt_committab, dbo.spt... etc.
etc. show, but not my table.
I tried checking and unchecking Use Trusted Connection in the
administration ODBC page and it didn't make any difference. I have all
the check boxes checked for the CF restrictions parameters. I don't
understand what I am missing, since the table is opened up to the whole
world using public. Why doesn't CF see the table?
--
Eric Root
Environmental Management Systems Inc.
Web Site: http://www.mountainmyst.com/emsi/emsi_home.htm
Phone (Voice): (509) 548-0243
Phone (Fax): (509) 548-0244
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
