Access tables which are created in dbo in MSSQL server using jdbc connection

Question

I have connect MSSQL server through java using following Code

Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DATABASENAME=;instanceName=MSSQLSERVER", "DB_USER_NAME", "DB_PASSWORD");

After that I am able to connect database and execute sql script without giving any object name. for example

SELECT * FROM TEST_TABLE

Now, I have some tables which are got created under dbo and I want to access them using same connect. How Can I go with this? I have try with

SELECT * FROM dbo.TEST_TABLE1

but it says that this table is not there in database.

jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true; — Khurram Ali
– Khurram Ali, Commented Feb 23, 2015 at 8:42
Immediately after establishing your JDBC connection do SELECT DB_NAME() AS currentdb and verify that you are actually using the database you think you are using. If so, then log into SQL Server Management Studio (SSMS) with the same credentials you are using in your Java code and try to access the dbo. tables that way. — Gord Thompson
– Gord Thompson, Commented Feb 23, 2015 at 12:13
@Navnath Please provide more details of your problem so that we can help you in a more accurate way — Khurram Ali
– Khurram Ali, Commented Feb 23, 2015 at 14:33

Gren · Accepted Answer · 2015-02-23 12:12:27Z

0

Make your DB user to the DB owner.

answered Feb 23, 2015 at 12:12

Gren

1,8641 gold badge12 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access tables which are created in dbo in MSSQL server using jdbc connection

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related