If you want to use Precision Bridge to extract data from or push data to SQL Server then you must configure the path to the SQL Server JDBC driver on the Precision Bridge Configuration Screen before you are able to open or create projects referencing SQL Server.
The Configuration screen is presented when you select File->Configure->Application from the menu.
From the Precision Bridge configuration screen, first, check the 'Support SQL Server Data Source' checkbox. Then use the Browse button to navigate to the Java 8 JDBC driver file. The filename should be one of the following:
For Precision Bridge 6.2 or below use one of:
- sqljdbc_4.2
- mssql-jdbc-x.x.x.jre8.jar
For Precision Bridge 6.3 or above use one of:
- mssql-jdbc-x.x.x.jre11.jar
- mssql-jdbc-x.x.x.jre17.jar
These drivers are usually located in your SQL Server installation folder.
The SQL Server JDBC driver required to connect to a SQL Server database is not distributed with Precision Bridge. If not present on your local machine, the driver files can be downloaded from the Microsoft Website (https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16). The actual driver files are found in the folder sqljdbc_12.2\enu of this download. These drivers will support SQL Server 2008 through to present and Microsoft Azure SQL Server Databases.
Comments
0 comments
Article is closed for comments.