Invalid object name for accessing SQL Server using Java

 

Java. SQL. sqlexception: [Microsoft] [sqlserver 2000 driver for JDBC] [sqlserver] Object Name 'xxx'Invalid

 

Solution:

 

1. The user has logged in, but cannot access the data table in it. The cause of this problem is that the SA user is a system user, although it can log in to the database, however, the storemanager database does not have the access permission of this user. Therefore, we create a new user share for this database. The creation process is as follows: select "Duplicate User" in the storemanager database> "new user"> select the name (this step has two key points. 1. Select SQL for identity authentication. The default database is storemanager) -> Create a new teaching share. Change the program and change the user login name and password.

2. All statements are written as follows: Select * from database name. DBO. Table name.