Skip to Content
0
Former Member
Aug 04, 2005 at 07:18 AM

MS SQL Server access from VC

22 Views

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