Friday, March 23, 2012

Invalid object name one_two_threefour_five_six11.

Hi,

I am trying to connect sql server 2005 with JDBC driver from a java program.(got from microsoft).It is simple class that retreving all the data of table.

i am doing "select * from one_two_threefour_five_six11 " . But it is giving
Exception of type 'com.microsoft.sqlserver.jdbc.SQLServerException Detail Message: Invalid object name 'one_two_threefour_five_six11'.

But the table is there in the database i given in configuration.This program is working for other tables. when i do the same query in Query analyzer it is showing data.

Please help me..

Thanks in advance.

venkateither something is wrong with your connection string or there is a ownership or permissions issue.|||Personally, I think sql server is making fun of you with a table_name like that

Check the owner|||Try this query instead:

select db_name()sql

No comments:

Post a Comment