cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to detemermine maximum number of connections MII 12.0 MSSQL 2005

Former Member
0 Kudos

I've searched the forms and I've looked at the questions regarding setting up SQL 2005 connections. I haven't been able to find a solution. Here's the information on my connection:

Connector IDBC

ConnectorType SQL

Enabled T

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

MaxRetryCount 5

Name MIIDatabase

PoolMax 100

PoolSize 1

RetryInterval 60000

ServerPackage com.sap.xmii.Illuminator.connectors.IDBC

ServerURL jdbc:sqlserver://MOWN60161\SQLEXPRESS:1433;database=MIIProjector

Timeout 15

UseCount 256

UserName MII_User

ValidationQuery SELECT GETDATE()

WaitTime 30

When I click on status it tells me that the status is "Pending". I get a "Unable to detemermine maximum number of connections from JDBC driver" error in the Netweaver log.

I uploaded and deployed the sqljdbc.jar file ver 1.2 from the Microsoft site.

I turned on TCP/IP connection in SQL 2005 and has set port 1433

Any help would be appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Mikhail,

Same issue is reported in [this |;Thread,

Please follow the that thread, Might be helpful to you

Regards

Rupesh

Answers (1)

Answers (1)

Former Member
0 Kudos

I wrote directly ip adress in ServerURL string and is's working.

Thanks for help.