VC and SQL connection problem

[Former Member]

Hi Everybody,

We are working on EP 7 SP10, we are trying to connect the VC 7 and MSSQL 2000 server. For that i have downloaded the sql drivers and added them in the Visual Administrator. After that using the connector name of the driver i have created a system for MSSQL database. Then i mapped user to the system. But the problem is connection is not working. Even i tried with various BI systems adding the drivers, even web service system connections are also not working. We have followed the same procedure to connect to EP 6.0 to MSSQL server. It is working fine, but where as in the case of EP 7.0 after following the same procedure also it is not working. What could be the problem any ideas and suggestions ???

Thanks

Rajesh

[Former Member]

hi

please check the following steps

This link tells how to configure a BI JDBC system...

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

This thread has some points about how to create a data source, you can cross verify your connection

This link tells what the driver class name and connection url string should be for different back end connections....

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/jdbcConnectionSetup&

Thanks & Regards

Harsimran

[Former Member]

Hi Rajesh,

you have to use a JDBC Connection. Have a look into the VC Wiki:

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

Best Regards,

Marcel