开发者

java sql connectivity

开发者 https://www.devze.com 2023-01-17 21:21 出处:网络
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.

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?


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.
0

精彩评论

暂无评论...
验证码 换一张
取 消