Data Sever Status Pending

[Former Member]

Hi all,

I am using MII 12.0.2. I tried to connect SQL Server 2000 with MII it shows the data server status is Pending.

I deployed the oracle-jdbc14.jar in to the JDBC drivers.

Server URL: jdbc:inetdae:<ServerName>:1433?database=Northwind&sql7=true

JDBC Driver: com.inet.tds.TdsDriver

Please help me how to avoid this problem.

Thanks.

John R

[Former Member]

John

Point 1: You need to deploy JDBC driver for SQL Server 2000 and not the oracle-jdbc14.jar . This is for Oracle Database, You Can get the Driver from [here|http://www.microsoft.com/downloads/details.aspx?familyid=9f1874b6-f8e1-4bd6-947c-0fc5bf05bf71&displaylang=en]

Refer to Documentation Available there

Point 2: Change the URL for SQL Server 2000 as jdbc:microsoft:sqlserver://<ServerName>:<PortNumber>;

Point 3: Change the JDBC Driver to "com.microsoft.jdbc.sqlserver.SQLServerDriver"

You can also follow [this Thread|;,

Hope this helps

Regards

Edited by: Rupesh Bajaj on Aug 8, 2008 3:06 PM