MATLAB: How to get the .net dll to locate the proper JDBC driver

.net dllDatabase Toolboxjdbc connectionjdbc driverMATLAB Compiler

We have a script that was written in Matlab R2015b. The script uses a JDBC driver to connect to SQL Server.

(This driver, sqljdbc_auth.dll, was originally placed into C:\Program Files\MATLAB\R2015b\bin\win64 in order to connect.)

We are compiling the script into a .net DLL so we can call it from a powershell script. When we run the script as a dll and not in Matlab we get this error:

Error using database/fetch (line 22) Unable to find JDBC driver.

What do we need to do to make sure the DLL can find the JDBC driver at runtime?

Best Answer

In order to add JDBC driver with Windows Authetication for SQL Server, you need to add the full path of sqljdbc_auth.dll to javalibrarypath.txt.

In MATLAB,

prefdir

will return the path of preferences folder. By default, it's C:\Users\<user>\AppData\Roaming\MathWorks\MATLAB\R2015b.

Navigate to the preference folder ($prefdir) and edit or create if not exist javalibrarypath.txt.

Add the folder path of sqljdbc_auth.dll (in your case, C:\Program Files\MATLAB\R2015b\bin\win64) to the $prefdir\javalibrarypath.txt.

Next, you need to add the JDBC driver file path of SQL Server to $prefdir\javaclasspath.txt.

In my case, sqljdbc_auth.dll is in "C:\Tools\jdbc\sqljdbc_6.2\enu\auth\x64" and JDBC driver(mssql-jdbc-6.2.1.jre7.jar) is in "C:\Tools\jdbc\sqljdbc_6.2\enu", so these 2 files are as follows.

$prefdir\javalibrarypath.txt

C:\Tools\jdbc\sqljdbc_6.2\enu\auth\x64

$prefdir\javaclasspath.txt

C:\Tools\jdbc\sqljdbc_6.2\enu\mssql-jdbc-6.2.1.jre7.jar

After these files are edited properly, you can compile to deployed MATLAB applications in which SQL Server is used.

Ref: Deploying Database Application with MATLAB Compiler and Microsoft SQL Server JDBC for Windows

Related Solutions

MATLAB: How to connect Microsoft SQL Server 2000 with Matlab R2011b

Download Microsoft SQL Server JDBC Driver 2.0. And configure it as following(demo information): Configure MATLAB to Use JDBC Drivers for Authenticated Database Connection

To connect to a SQL server database with integrated Windows authentication using a JDBC driver, do the following:

   1.
      Close MATLAB if it is running.
   2.
      Insert the path to the database driver JAR file in the classpath.txt file. The classpath.txt file is located at:
      $MATLABROOT\toolbox\local\classpath.txt
      The updated path entry should now include the full path to the driver. For example:
      C:\DB_Drivers\sqljdbc_2.0\enu\sqljdbc4.jar
   3.
      Insert the path to the folder containing sqljdbc_auth.dll in the librarypath.txt file. The librarypath.txt file is located at:
      $MATLABROOT\toolbox\local\librarypath.txt
      The path entry should not include the file name sqljdbc_auth.dll:
      C:\DB_Drivers\sqljdbc_2.0\enu\auth\x64
      The sqljdbc_auth.dll file is installed in the following location:
      <installation>\sqljdbc_<version>\<language>\auth\<arch>
      where <installation> is the installation directory of the SQL server driver.
      If you are running a 32-bit Java Virtual Machine (JVM), use the sqljdbc_auth.dll file in the x86 folder, even if the operating system is the x64 version. If you are running a 64-bit JVM on a x64 processor, use the sqljdbc_auth.dll file in the x64 folder. If you are running a 64-bit JVM on a IA-64 processor, use the sqljdbc_auth.dll file in the IA64 folder.
   4.
      Start MATLAB.
   5.
      Append the string integratedSecurity=true; to the database URL:
      conn = database('dbName','','', ...
         'com.microsoft.sqlserver.jdbc.SQLServerDriver', ...
         ['jdbc:sqlserver://servername:portnumber; '...
          'database=dbName;'] 'integratedSecurity=true;')

MATLAB: How to fix a get sort row error

You might have to add the Microsoft SQL Server Windows Authentication library to the javalibrarypath.txt file.

Create 'javalibrarypath.txt' in MATLAB preferences directory (Obtained by entering 'prefdir' command in MATLAB), and add the location of 'sqljdbc_auth.dll' to it as described in Step 3 of the following documentation:

Microsoft SQL Server JDBC for Windows

Best Answer

Related Solutions

MATLAB: How to connect Microsoft SQL Server 2000 with Matlab R2011b

MATLAB: How to fix a get sort row error

Related Question