JDBC System Connection VS BI JDBC System Connection

[Former Member]

Hi All,

I've created a BI JDBC System which connects to the MS SQL Server 2005, and the connection tested successfully. I am now able to browse for tables.

But I need to access stored procedure as well, so i created a JDBC System with the same Database URL, Driver Class Name, and User Mapping. But i failed the connection test with the error:

com.sap.guimachine.portalconnector.commandhandler.CommandException: Failed to connect to backend system. Check your system definition and user privileges.#

Any idea?

Thanks & Regards,

Sarah

[Former Member · Accepted solution]

Is there any SAP note or configuration steps regarding this issue? I can't find any so far.

I am using Visual Composer 7.0 SP20.

Please help.

Thanks & Regards,

Sarah

Edited by: kityein lai on May 12, 2010 10:28 AM

[former_member192774 · Accepted solution]

Hi!

See http://wiki.sdn.sap.com/wiki/display/VC/Step-by-Step%2bguide%2bMaxDB%2bJDBC.

and notes - 773401

attention to: change_ref -m com.sapportals.connectors.database library:MAXDB_DRIVER

and: user mapping to database user with necessary authorities

very usefull testing connection through VA-JDBC Connector- create datasource (fill url + user/psw) and "db initialization" - select * from la-la

Vlad

Edited by: Skif on May 18, 2010 7:37 AM

Edited by: Skif on May 18, 2010 9:04 AM

[Former Member]

This is in the error log, i show you a print screen of it:

http://www.glowfoto.com/viewimage.php?img=10-184654L&rand=8545&t=jpg&m=05&y=2010&srv=img6

Please help me.

Thanks in advance.

Regards,

Sarah