JDBC driver not supported for MS_SQL_SERVER database

[Former Member]

HI,

After deployed JDBC driver in NWA, i created SQL Server 2000 JDBC system in portal.when i try test connection i am getting this exception in log\system \database

Dedicated_Application_Thread]#Java#com.sap.sql.log.OpenSQLResourceBundle#

Exception of type caught: .#2#com.sap.sql.log.OpenSQLException#JDBC driver not supported for MS_SQL_SERVER database.#

in BI_SDK_Trace i got this exception

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:240)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:78)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:43)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:42)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:425)

at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:250)

at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:45)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:109)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:314)

Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

-

---

Loader Info -

---

ClassLoader name: [sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc]

Living status: alive

Direct parent loaders:

[system:Frame]

[service:servlet_jsp]

[service:ejb]

[library:com.sap.ip.bi.sdk]

Resources:

E:
usr
sap
CE1
J00
j2ee
cluster
apps
sap.com
com.sap.ip.bi.sdk.dac.connector.jdbc
connector
bin
com.sap.ip.bi.sdk.dac.connector.jdbc.rar
bi_sdk_jdbc.jar

-

---

at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:274)

at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:243)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:363)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:164)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:313)

... 124 more

What i have to do to over come this error.

I am using SQL server 2000,

I deployed all three JAR files.

I checked JDBC URL. its correct

After deploye JDBC Driver its in unknown state but JDBC Custom Datasource in Green .

Thanks,

Babu

[Former Member]

Hi,

Kindly let me know which version of VC are you using? VC 7.0, VC 7.1 or VC 7.1. Ehp 1

Thanks,

Dharmi

[Former Member]

Hi,

i am using both VC 7.1 and VC 7.1. Ehp 1.i am getting same problem.in VC 7.0 Its working correctly.

Thanks,

Babu

[Former Member]

Hi Babu,

JDBC is not supported in VC 7.1. to be able to connect to MS SQL Server, have a look at this [wiki|https://wiki.sdn.sap.com/wiki/x/FYDzAQ ] . JDBC support is available from VC 7.1. Ehp1 onwards....

Regards,

Dharmi

[Former Member]

Sorry Dharmi,

I solved the problem now i can connect JDBC system in VC7.1 also.

Thanks,

Babu

[Former Member]

Hi Babu,

Can you let us know the solution?

Regards,

Dharmi

[Former Member]

Hi Dharmi,

Just deploy the JDBC driver(SQL or Oracle) and create New JDBC Custom datasource with correct connection property.and add loader reference(Library:your custom datasource name) in com.sap.ip.bi.sdk.dac.connector.jdbc .

In portal just create BI JDBC system with correct property.just check connection test .if you face any problem let me know.

Thanks

Babu.

[Former Member]

Hi Babu,

Please can you provide a step by step guide on how to add a loader reference - I can do it in 7.0 with Visual Admin but cannot see where to do it in NW CE (EHP1)

Thanks

[Former Member]

Found it. Thanks

[Former Member]

Found it. Thanks

[Former Member]

I cannot see the newly created BI_JDBC data service in Visual Composer [search]. Any known reason why?