Connect to MS SQL Server 2008 using JDBC Driver with PB12.5?

[former_member216444]

I want to connect to MS SQL Server 2008 using JDBC Driver with PB12.5? Please advise on this.

[Former Member · Accepted solution]

Hi,

-Download the MS Jdbc driver from :

Microsoft JDBC Driver for SQL Server

- Add sqljdbc4.jar to the system CLASSPATH variable

-In Powerbuilder create a connection JDB

Driver Name  : com.microsoft.sqlserver.jdbc.SQLServerDriver

URL :jdbc:sqlserver://your_server;databaseName=repro

For more details, see Connecting to SQL Server with the JDBC Driver

Regards.

Abdallah.

[former_member216444 · Accepted solution]

Thanks for the reply. I tried the steps mentioned and while creating the profile, got the below error

"could not load class com.microsoft.sqlserver.jdbc.sqlserverdriver"

Am I missing something?

[Former Member · Accepted solution]

beware that Java is case sensitive. So set the driver name :

com.microsoft.sqlserver.jdbc.SQLServerDriver

[Former Member · Accepted solution]

Also did you add the sqljdbc4.jar file to the classpath in PowerBuilder using  Tools > System Options... > Java tab?