Java query SQLServer encountered a problem: the object name is invalid.

sunzoutao

There is a problem with the capitalization and encoding!

chinaholy

In Java, take a look at the written string of the SQL statement.

cm200red

Back tosunzoutao: I did choose the library soku built by myself, and I also queried the table userInfo in the soku library.
           Where is the problem with capitalization and encoding?

cm200red

Back tochinaholy:
The writing of sql statement should be no problem. The problem now is that there is no problem when I query the system tables in all the databases, but when I check the user tables, an error occurs. I tried several databases in SQL Server and they were all the same.

I don't know if there is a problem with the SQL Server configuration, or the SQL Server Driver configuration, or other problems.

fire_fly

It should be a direct connection problem. You can set your SA in your SQL SERVER user, change the library under SA to the library you want to operate, and you can also set it if you want to set a password!

fire_fly

Because your sa is master by default

舍义取生

No, I also encountered the same problem, and I tried a good program yesterday, and it reported the same error as the original owner when I ran it directly today!

舍义取生

The host can turn off the query analyzer, and then re-open the enterprise manager to try! I just reopened the enterprise manager once.

鬼方丈

Agree tofire_fly

至少还有自由

The databasename and the name of the table are correct. Put the same SQL statement in MSSQL's query analyzer to see.