Thanks Daniel,
It was a combination of your suggestions. The CF admin page was a little misleading:
Login Information: Database.
But I put the database name in there and then it worked AFTER I restarted RDS. It
make sense now.
CF-Talk is a great resource. Since this is my first day using it, I find that I am
getting hundreds of email.
What is the Digest option offered by CF-Talk?
Eric
Daniel Lancelot wrote:
> 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
