mx7 connect to sql server 2000

[*guyute*]

I have been able to set up a datasource that verifies and connects to the
database. But when I run queries through coldfusion, I get 'invalid object
name' errors on tables that I create with enterprise manager. I can run
queries on system tables just fine through coldfusion but I cannot run queries
on tables I create.

Any ideas?

[swathi]

Hi,
Looks like a permissions issue to me. Make sure the user you have created
the datasource with has permissions to query the tables you created ( basically
the user who created the tables). Your DB administrator might be able to help
you with it.

Thanks,
Swathi.

[Mountain Lover]

I can confirm this type of behavior (CFMX 701 Dev, IIS 5.1). I add a
field to a table via enterprise manager and then try to query the field
and then get the same error you describe. I haven't been able to take
the time to find a fix (a cf restart fixed it for me)...I'm wondering if
it is the maintain database connection switch for the DSN???

and yes, the user in the CF DSN has permissions on the table/field.

--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[MikerRoo]

Originally posted by: Newsgroup User...I'm wondering if it is the maintain
database connection switch for the DSN??? ...

I think so.
And you can see the same behavior even using Query Analyzer if you don't
"refresh" after some changes made in EM.