JDBC drivers

[Former Member]

Hi

I am following this blog

but soap client throws this error

"DeliveryException: Database connection could not be established"

this is my previous question

How can I check whether the JDBC drivers are installed on my MSSQL server. Is there any application available to check the installed drivers

thanks

manian

Edited by: manian on Sep 26, 2008 7:26 AM

[former_member183906 · Accepted solution]

In Visual Admin go to Service.

Find JDBC connector.

Select the JDBC connector.

Find the drivers.Choose the driver.

There you can able to find the JDBC Driver.

Find below link will help u for more information

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#02_02

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html

[Former Member · Accepted solution]

is this right path to log on to Visual Administrator ?

D:\usr\sap\D10\DVEBMGS01\j2ee\configtool.bat

thanks

manian

[Former Member · Accepted solution]

Hi,

This is the path to Login to Visual Admi

J2EE Visual Admin

D:usr\sap\SID\DVEBMGS01\j2ee\admin\go.bat

Regards

Seshagiri

[Former Member · Accepted solution]

Hi,

No.

To start the Visual Administrator, perform the following:

● On UNIX platforms, enter on the command line /usr/sap/<SAPSID>/<Instance_Name>/j2ee/admin/go.sh

● On Windows platforms, run <Drive>:\usr\sap\<SAPSID>\<Instance_Name>\j2ee\admin\go.bat

Carlos

[Former Member · Accepted solution]

thanks guys, now i have got the visual admin.

how can i find the JDBC drivers on my MDM machine having the MSsql database ?

any idea

thanks

manian

[Former Member · Accepted solution]

Hi,

You have to search in XI Server's Visual Admin not on MDM Server

REgards

Seshagiri

[Former Member · Accepted solution]

Hi Sheshagiri

this is what i am trying to do

(SOAP request) (JDBC request)

SOAP Client--

---

>XI--

---

>MDM server(MSsql database)

(JDBC response) (JDBC Response)

I have the table in MDM server(MSsql database)

my questions are

1. Do i have to check whether JDBC drivers are present in my MDM server ?

2. Should i have to check only in my XI server (visual admin)

3. my XI integration with MDM is on a right way?

Thanks

manian

Edited by: manian on Sep 26, 2008 8:46 AM

[Former Member · Accepted solution]

Hi,

>>1. Do i have to check whether JDBC drivers are present in my MDM server ?

NO

>>2. Should i have to check only in my XI server (visual admin)

YES

>>3. my XI integration with MDM is on a right way?

Id Depends on Your Req, which adapter needs to use correclty

Regards

Seshagiri

[Former Member · Accepted solution]

thanks sheshagiri for your inputs.

manian

[former_member192295]

Hi,

We can find driver information, find below link for more help

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html