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
Friday, March 23, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment