Setup

This page will guide you on how to setup Database - Connector (ODBC) to connect to your database.

1. Downloading the plugin

If it's not already done, download the plugin through Fab here.

2. Installing the ODBC driver

To connect to your database, Database - Connector (ODBC) uses an ODBC driver specific to your Database. That's why you must first install the driver corresponding to your database.

This table lists the common databases and the download link of their ODBC driver:

You can easily find your database's ODBC driver with Google.

Make sure to pick the 64-bits driver.

3. Getting the ODBC Driver's Name

Now that the driver is installed on your machine, you need to get the exact driver's name. To do so:

1. Use the WIN + R shortcut to open the Run window.
2. Enter odbcad32.exe to open the ODBC Data Source Administrator (64-bit) window.

3. Under the Drivers section, identify the driver you installed and note somewhere the exact name of your driver (version number included).

In the example, the name to remember is MariaDB ODBC 3.1 Driver.

4. You now have to use this name when connecting to your Database using Blueprints and/or C++.

If the driver corresponding to your database doesn't show up, it probably means that the 64-bits version isn't installed on your machine.

4. C++ Setup (Optional)

An additional step is required for C++, you can skip it if you use only Blueprints:

1. Open your module's Module.Build.cs.
2. Add the following line in the constructor:

   PublicDependencyModuleNames.Add("DatabaseConnector");

3. Save the file.
4. Right click on your Project.uproject.
5. Select Generate <IDE> Project Files.

The plugin is now ready to be used with C++.