How to install MS SQL Server driver in SAPBC

, ,
1

Hi,

How to install MS SQL Server driver in SAPBC

2

do you have the SQL Sever JDBC jars with you?

search the forum on any of these terms:
msbase.jar, mssqlserver.jar, msutil.jar

HTH.

3

Yes iam having the jar files with me but where to place these jar files ?

and how to configure, pleae tell me the procedure to configure ?

4
  1. Read the SAP BC documentation.
  2. Post any specific questions you have if the documentation is unclear or incomplete.
5

Hi,

we have gone through the documentation and kept msbase.jar, mssqlserver.jar, msutil.jar in sapbc\Is\lib folder, updated server.sh file and restarted the server but still we are getting error “No suitable driver”.

6

You don’t need to update the classpath in server.sh. The script builds the classpath automatically.

Place the ms jar files in sapbc/IS/lib/jars

Can you post the connection settings you’re using? Incorrect settings there can result in the same message.

7

Hi reamon,

I have pasted the 3 jars files in sapbc/IS/lib/jars folder and

the connection settings which i gave

Alias: xyz
DB URL: xyz:123.com
DB Username: xyz
DB Password
DB Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
Minimum Connections
Maximum Connections
Expiration Time (ms)
Loaded Drivers : (selected)

after this submitted and i have restarted the dev server

but still iam getting “No suitable driver error”

please suggest me names of few drivers to connect to SQL Server 2000.

we have used this driver DB Driver : com.microsoft.jdbc.sqlserver.SQLServerDriver