AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  SQL Server tables not owned by "dbo" - how to reference them          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message ITM Guest Posted: Fri Jan 23, 2004 4:49 pm    Post subject: SQL Server tables not owned by "dbo" - how to reference them This is a follow-up from a previous post, which for some reason I can't find on my news server!.... I have a SQL Server 2000 database which has been restored from a backup. The restored database contained a user called "X", which is the owner of all of the tables in the database. When I try to execute an SQL SELECT against any of the tables in the database (using the JDBC/ODBC bridge) I get an "invalid object name" error - it seems to be requiring me to prefix the table names with "X.", even though the ODBC data source has been set up with the user "X". Since this is a client's database, I have no control over ownership of the tables, but I need to access them via ODBC in my application. JDBC also isn't an option. I've tried referring to tables using X.tablename syntax, but that doesn't work. Can anyone tell what the correct syntax should be to refer to these tables? TIA Isabel Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.