MS SQL Server access from VC

[Former Member]

Hi,

I am trying to access MS SQL tables from BI wizard through VC.

I created a BIUDDI JDBC SQL system, the test connection has failed, but the normal JDBC system is working fine.

Is there any additional settings do I need to do in J2EE connector service as specified in the document (How configure BI JDBC System.pdf).

The following properties I filled in the connection, I done user mapping also.

<b>URL:</b> jdbc:sap:sqlserver://EP6SP11:1433;DatabaseName=Northwind

<b>Driver:</b> com.sap.portals.jdbc.sqlserver.SQLServerDriver

<b>Field Catalog:</b> Northwind

<b>Field Schema :</b> dbo

Can you please give me a suggestion to get it done.

Thanks

Srinivas Sandaka

[Former Member · Accepted solution]

Hello.

At a first sight it seems that you misused jdbc driver and url in system definition.

Please try:

URL: jdbc:microsoft:sqlserver://<hostname>:<port>;database=Northwind

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Hope that helps

Marek

[Former Member]

Hi,

I done the same steps as you mentioned. Except the name <b>library:com.microsoft.jdbc.sqlserver</b>, actually I gave a name <b>mssql</b> so by the time I am configuring the Connection Container I gave the name <b>library:mssql</b>.

Can you please suggest if any thing I missed.

Thanks

Srinivas Sandaka

[Former Member]

Hi Srinivas

If you still could make it work, there is useful hint in the forum:

Regards

Marek

[Former Member]

Hi,

Thanks for your quick replies.

I am using SAP standard SQL Server connector, it is successfully executing through JDBC system.

I downloaded the microsoft driver also and configured it in JDBC service, I created a JDBC system (not BIUDDI) the test connection is failed.

I just import 3 jar files which are given my microsoft into JDBC service.

Thanks

Srinivas Sandaka

[Former Member]

Hello.

I did it successfully.

As far as I remember, I created new driver and called it "com.microsoft.jdbc.sqlserver" under Drivers in VA->Server...->Services->JDBC Connector. I also added there 3 jar libraries you mentioned.

Next in VA->Server..->Services->Connection container find SDK_JDBC. On Resource Adapter tab I added entry "library:com.microsoft.jdbc.sqlserver".

Then restart the service in VA->Server..->Services->Deploy.

That's all. The test in both regular JDBC and BIUDDI system test should succeed, or at least BUIDDI.

Regards

Marek

[former_member188977]

Hi,

You need download and install new jdbc drivers.

(in www.microsoft.com )

then, you need to upload it in WAS with Visual Administrator (services - JDBC connector) and then, you'll be able tu use it how Marek says.

Regards.