BI JDBC Connection For MSSQL 2005

[Former Member]

Hi All,

I am trying to establish an BI JDBC Connection with MSSQL 2005 Server. I follow the steps exactly mentioned in the guide but i was not successfull. I doubt the problem could be with the adapters and again downloaded a JAR file for MSSQL 2005 from microsoft website and proceeded with steps. But no luck this time also.

How do i make a successfull connection. Below is the result of a test page

==================================================

Details:

com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:238) at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getConnection(JDBCModel.java:797) at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getTables(JDBCModel.java:132) at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller.Control2.doPost(Control2.java:23) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170) Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:123) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectionFactory.createManagedConnection(JdbcManagedConnectionFactory.java:119) at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:320) at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:233) ... 19 more Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:394) at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connect(Connection.java:106) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:118) ... 23 more Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]End of stream was detected on a read. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:376) ... 25 more

====================================================

regards,

Anand

[Former Member · Accepted solution]

Hi Anand,

did you check the WIKI:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup">https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup</a>

Best Regards,

Marcel

[Former Member]

Praveen,

Thanks for ur info. But i have already gone through these steps. But i could not succeed with these steps. I have already gone through this.

Looking forward for your suggestions

regards,

Anandh.

[Former Member]

I suggest you to test the connection through a standalone JAVA class.

Lets make sure that a normal JDBC connection establishment is possible.

[former_member193545]

Hi

Have you tried using the following:

Connection URL: jdbc:sap:sqlserver://<Hostname>:<Port>;DatabaseName=<databasename>

Driver Class Name: com.sap.portals.jdbc.sqlserver.SQLServerDriver

[Former Member]

Hi Marcel,

Thanks for the link. But no luck. Any other suggestions.

regards,

Anand

[praveenkumar_kadi]

Hi,

It's more of connection configuration issue.

Visit this pdf check the steps (though it says for VC)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a0...

Hope that helps