cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Issue

Former Member
0 Kudos

I have created a new stored procedure on the sql server database. However, when I "find Data" through VC, it does not show up in the list of available procedures. The connection to the sql server is fine.

Any thoughts?

Kevin

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Kevin,

In order to get the Stored Procedures in SQL Server, you need a JDBC system.

So make sure that you have given the Connection URL & Driver class name with correct values in the JDBC system.

Regards,

Shemim

Former Member
0 Kudos

Hi,

1) You must use a Portal JDBC connector as it is mentioned here:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/Cannot%20see%20tables">https://wiki.sdn.sap.com/wiki/display/VC/Cannot%20see%20tables</a>

Refer this wiki for JDBC setup connection

<a href="https://wiki.sdn.sap.com/wiki/display/VC/JDBC%20Connection%20Setup?focusedCommentId=14341">https://wiki.sdn.sap.com/wiki/display/VC/JDBC%20Connection%20Setup?focusedCommentId=14341</a>

Regards,

Hemalatha