UCS connection to MSSQL with Named instance

[cavagnaro]

Hi guys,
I'm facing a strange issue...configuring UCS I need to connect to a DB with a Named instance and failing to connect, my query is:
[quote]
jdbc:jtds:sqlserver://s247va1\BDT:1433;DatabaseName=UCS
[/quote]

But I have been able to connect to Interaction Server DB, I do know UCS connects via Java and INX uses DBServer...so I wonder if any one has a tested query string to connect via JDBC?

DB guys are validating that TCP/IP is enabled on the MSSQL server, but they are 99% sure it is...


Thanks

[cavagnaro]

Complete error is:

[quote]

15:39:25.949 Std 21111 [Ucs-Main] The Database Access Point 'DAP_UCS_MesaDinero' has been configured with an infinite timeout.
15:39:25.980 Trc 29998 [Ucs-Main] DataSource configured with properties (password=****,delete-locking-hint=ROWLOCK,dbengine=mssql,user=SQLGENE,queryTimeout=0,select-locking-hint=NOLOCK,charset=Cp1252,loginTimeout=10,port=7006,jdbc-debug=TRUE,appname='UCS_Main_MesaDinero' on 'DAP_UCS_MesaDinero',dbname=UCS,inactive-connection-timeout=0,insert-locking-hint=ROWLOCK,host=s286va3,update-locking-hint=ROWLOCK,username=SQLGENE,role=Main,query-timeout=0,dbcase=any,dbserver=s286va3,connection-failed-retry=2,database=UCS)
15:39:25.980 Dbg 29999 [Ucs-Main] JDBC debug is on
15:39:25.980 Trc 29998 [Ucs-Main] Datasource connection pool initialized with maximum size set to 40 connections, maximum login time set to 10000s, and maximum connection idle time set to 310s.
15:39:25.996 Trc 21284 [Ucs-Main] JDBC: registerDriver: driver[className=com.inet.pool.PoolDriver,com.inet.pool.PoolDriver@c8376b]
15:39:26.011 Trc 21284 [Ucs-Main] JDBC: registerDriver: driver[className=com.inet.ora.OraDriver,com.inet.ora.OraDriver@6e4365]
15:39:26.027 Trc 21284 [Ucs-Main] JDBC: [TDS Driver]Try: s286va3:7006
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: SQLException: SQLState(08S01)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: com.inet.tds.at: java.net.ConnectException: Connection refused: connect
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.aq.a(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.<init>(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.a(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.TdsDriver.connect(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.TdsDataSource.getConnection(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.PDataSource.getPooledConnection(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.g.b(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.PoolManager.a(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.PoolManager.getConnection(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.PDataSource.getConnection(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.DataSource.getDatabaseInfo(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.OptaDataSource.<init>(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.NewDataSourceFactory.createDataSource(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.NewDataSourceFactory.createDataSource(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.byte(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.a(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.access$400(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine$5.run(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.lang.Thread.run(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: Caused by: java.net.ConnectException: Connection refused: connect
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.socketConnect(Native Method)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.doConnect(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.PlainSocketImpl.connect(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.SocksSocketImpl.connect(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.connect(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.connect(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.<init>(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at java.net.Socket.<init>(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.a(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.a(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: at com.inet.tds.w.run(Unknown Source)
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: ... 1 more
15:39:27.089 Trc 21284 [Ucs-Main] JDBC: [TDS Driver]{password=#######, insert-locking-hint=ROWLOCK, dbcase=any, charset=Cp1252, sql7=true, url=jdbc:inetdae, dbserver=s286va3, loginTimeout=10, port=7006, connection-failed-retry=2, delete-locking-hint=ROWLOCK, inactive-connection-timeout=0, dbengine=mssql, database=UCS, select-locking-hint=NOLOCK, host=s286va3, appname='UCS_Main_MesaDinero' on 'DAP_UCS_MesaDinero', query-timeout=0, queryTimeout=0, jdbc-debug=TRUE, db=UCS, role=Main, update-locking-hint=ROWLOCK, user=SQLGENE}
15:39:27.089 Std 05066 Initialization of UCS DAP failed, reason 'DataAccessPoint registration failed: java.net.ConnectException: Connection refused: connect'
15:39:27.089 Trc 21007 [Ucs-Main] LCA Status changed to 'Service Unavailable'.
15:39:35.949 Dbg 29999 [LogMon] Log reconfiguring task running
15:39:35.949 Dbg 29999 [LogMon] Log reconfiguring task period = 30000 ms
[/quote]

[René]

Hi Cav,

Try to use this connection string:

[code]jdbc:jtds:sqlserver://s247va1:1433/BDT;instance=<instance name>[/code]

You can find more details about the JTDS driver for MS SQL Server here - [url=http://jtds.sourceforge.net/]http://jtds.sourceforge.net/[/url]

R.

[cavagnaro]

Yup already tried before René, thanks for the point. I think the fact they haven't answer about the TCP connection seems to be the 1% missing...