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