on 08-06-2008 6:47 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I wrote directly ip adress in ServerURL string and is's working.
Thanks for help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
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.