How to create JDBC data source using SQL Server Driver

[stone2dbone]

I cannot create a JDBC data source using the BIRT Report Design plugin and Eclipse IDE for Enterpise Java and Web Developers Version:2022-09 (4.25.0) Build id 20220908-1902.

Using JDBC Data Source:

I have attempted each of the following URLs:

I repeatedly get the following error:

Using the JDBC Database Connection for Query Builder, with the SQL Server Connection Profile Type,

I get the following error after modifying the driver properties:

If I back out and then start over to create a new data source using the SQL Server Connection Profile Type I previously modified, I get this error:

I am using mssql-jdbc-6.1.0.jre8.jar. I have unsuccessfully tried to use 7.0.0.jre8 and 11.2.0.jre8 as well.

(NOTE: I just installed Eclipse Report Designer package, the portable Eclipse installation with the BIRT plugin pre-installed, and was able to connect without a problem! I'd prefer not to have to switch between IDEs, so if someone can offer a solution to my original problem, it would still be greatly appreciated.)

[speckyspooky]

Hello,

I have on my workstation-laptop an MS SQL Server (SQL-Express) and I tested 2 JDBC drivers for the connection and both works fine.
The first one is the oldest JDBC-driver of MSSQL the JTDS-driver and the second is the original Microsoft JDBC-driver "com.microsoft.sqlserver.jdbc.SQLServerDriver ( v10.2)".

I have located both drivers on an separated folder and added both drivers with the according jar-files on the driver manager (Manage Drivers).

Attached I added 2 screens of the "Manage Driver"-overview and my connection configuration.

Perhaps the screens will help to get some information to solve your problem.

Driver administration:

Connection properties

[stone2dbone]

Thanks, but the only difference I see is that you've added "trustServerCertificate=true". Using the BIRT Report Design plugin I'm still not able to connect after adding that parameter to the URL.

[speckyspooky]

The issue sames to me a local issue becuase the connection is possible.
Can you please retry the connection by removing the drivers -> eclipse restart, add the driver again -> eclipse restart, create your connection and send the error message of the Java stacktrace. Perhaps we can see together some hint.

I don't use connection profiles. I use only the direct connections.

[EAwesomeK]

Hello,

I have on my workstation-laptop an MS SQL Server (SQL-Express) and I tested 2 JDBC drivers for the connection and both works fine. The first one is the oldest JDBC-driver of MSSQL the JTDS-driver and the second is the original Microsoft JDBC-driver "com.microsoft.sqlserver.jdbc.SQLServerDriver ( v10.2)".

I have located both drivers on an separated folder and added both drivers with the according jar-files on the driver manager (Manage Drivers).

Attached I added 2 screens of the "Manage Driver"-overview and my connection configuration.

Perhaps the screens will help to get some information to solve your problem.

Driver administration:

Connection properties

How do you get 2 SQL drivers to show up in the driver class drop down menu? I can have 2 drivers but the newest one is the only 1 that shows up in the drop down list.