on 09-26-2008 8:23 AM
Hi All,
We have a requirement to connect to MS SQL 2005, We have uploaded the sqljdbc.jar and depolyed and MII 12.0 server.
We have configured the Data Server with following details.
JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver
ServerURL jdbc:sqlserver://<Server_IP>;databaseName=<dbName>;
When we try to see the Status of the connection it shows status as Stopped.
The same server I am able to connect using Java Program.
Please help me on this issue.
Rupesh
Hi
First , Check your JDBC driver , Did you installed JDBC driver for SQL server 2005?
Second, ServerURL should have be like this
jdbc:sqlserver://<servername>:1433;databaseName=<dbname>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.