cancel
Showing results for 
Search instead for 
Did you mean: 

File to JDBC

Former Member
0 Kudos

Hi Friends,

Can any one tell me the answer. I am doing File to JDBC Scenario. I got this:

Error: Accessing database connection 'jdbc:microsoft.sqlserver.//SQLSRV:1433;DatabaseName=J2ee' failed: java.sql.SQLException: No suitable driver

Regards,

Santosh

Accepted Solutions (0)

Answers (5)

Answers (5)

nikhil_bose
Active Contributor
0 Kudos

hi venkata,

see if you might have misspelled the driver specification or not

thanks and regards

nikhilbos

Former Member
0 Kudos

Hi Venkat,

Just check the JDBC Adapter that is installed in u r senario, if not u got to install it..............below is the link which can help you in configuring this kind of senario.

<b>Configuring the Receiver side JDBC Adapter</b>

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Reward with points if helpfull

Regards

Sai Ganesh

GabrielSagaya
Active Contributor
0 Kudos

Check your connection string. Try this format:

jdbc:microsoft:sqlserver://<host>:<port>

(notice the microsoft)

prateek
Active Contributor
0 Kudos

The JDBC driver is not properly deployed on your XI server. U have to install it before proceeding with ur scenario.

Regards,

Prateek

Former Member
0 Kudos

hi venkata,

u need to install jdbc driver on j2ee engine for jdbc adapter.

refer this:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

[reward if helpful]

regards,

latika.