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.
精彩评论