Did you set the tablename that the views reside in properly? Have you tried accessing them as Tablename.dbo.viewname?
We hit SQL 2000 views here all the time. HTH, Jeff ----- Original Message ----- From: "Van Vliet, Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 10:53 AM Subject: CFMX and SQL 2000 Views Greetings, Has anyone experienced problems on CFMX using the Microsoft SQL Server JBDC Driver to query Views? I have a database with quite a few Views, and every query against a View returns the following error: <snip> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'vActiveModels'. </snip> Your thoughts? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED] "Hello Stupid, and welcome to your crappy computer." - Strong Bad, HomestarRunner.com ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
