EP 7.4 VC JDBC system missing in search

[Former Member]

We recently upgraded our portal from 7.0 to 7.4. I made the JDBC system object to SQL server 2005 on EP 7.4 worked and tested connection successfully. Went to /VC, found the JDBC system object was not shown in Search tab.

I checked the system object permission, user id permission and system mapping. Still not showing.

Any idea what went wrong, where to check, how to fix this issue?

Appreciated.

[mark_moshkovich · Accepted solution]

Hello,

Please review the blog:

https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13944

(http://scn.sap.com/docs/DOC-4094)

Regards,

Mark

[Former Member]

I followed the document when I configured my JDBC on EP7.4.

My question is what JDBC version should I use in EP7.4 if I want to connect to MS SQL server 2005. I think EP 7.4 requires jdk 1.6. Then should I use MS SQL server diver 3.0 or 4.0? Which jar should I included when I configure the driver, sqljdbc.jar or sqljdbc4.jar?

Thanks.

[mark_moshkovich]

Hi Natalie,

I am using  sqljdbc.jar, without any problems.

Regards,

Mark

[Former Member]

Thank you. I made sqljdbc4.jar worked on my systems.