Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

xMII 12.0 SQL connections

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 ShopFloor

PoolMax 100

PoolSize 1

RetryInterval 60000

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

ServerURL jdbc:sqlserver://sapnt187\XMS:1433;databaseName=ShopFloor

Timeout 2

UseCount 256

UserName ShopFloorUser

ValidationQuery SELECT GETDATE()

WaitTime 30

When I click on status it tells me that the status is "Running" and I have no available connections. I attempted to execute a SQL transaction and I get a "Cannot create a connection to the database" error in the Netweaver log. I uploaded and deployed the sqlodbc.jar file from the Microsoft site.

Any help would be appreciated.

Former Member
Not what you were looking for? View more on this topic or Ask a question