I have created a user named DSN "harshi". The connection details to include in the SQL table are:
string URL = "JDBC: ODBC: Harshi"; Connection conn = DriverManager.getConnection (url, "", ""); Description st = conn.createStatement (); Still I'm getting the output:
An exception was found!
[Microsoft] [ODBC SQL Server Driver] [shared memory] SQL Server does not exist or is not denied access.
How can I solve it?
To troubleshoot this error, try one of these:
- Does DSN have good credentials?
- If you are using SQL Server authentication, then those exact credentials through SQL Server Management Studio
- If using Windows authentication, then what are the requesting accounts Is Permission for SQL Server?
- Is there a firewall between a machine or a machine?
- DSN was created because the IP address of the destination machine has changed?
- Try removing & amp; Rebuilding DSN
Comments
Post a Comment