java sql connectivity

Question

I have created a user dsn named "harshi"
To insert rows in a table getting data from Java code I want to insert in SQL table. The connection statement is:

String url = "jdbc:odbc:Harshi"; 
Connection conn = DriverManager.getConnection(url,"",""); 
Statement st = conn.createStatement();

Still I am getting output as:

Got an exception!
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

How can I solve it?

p.campbell · Accepted Answer · 2010-09-26 17:50:05Z

1

To troubleshoot this error, try one of these:

does the DSN contain good credentials?
If using SQL Server Authentication, try logging in using those exact credentials via SQL Server Management Studio
If using Windows Authentication, does the account making the request have permissions to the SQL Server?
Are there any firewalls in between the application machine and the database machine?
Has the IP address of the destination machine changed since the DSN was created?
Try deleting & recreating the DSN.

answered Sep 26, 2010 at 17:50

p.campbell

101k70 gold badges264 silver badges326 bronze badges

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

Collectives™ on Stack Overflow

java sql connectivity

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related