Support > Forums > OpenBots Studio > How to connect external databases?

How to connect external databases?

Lakshman Duggineni

  • Reporter
  • Calender Icon September 24,2021 at 6:01 AM

I am trying to connect external Databases like MariaDB, MySQL, etc. while connecting am getting the following error. Exception Type: ArgumentException, Exception Message: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc). How to connect external databases? please help? Thank you.

This forum has 313 topics, 680 replies, and was last updated 16 days ago by Faheem Syed

Nataly Alvarado...

  • Participant
  • Calender Icon September 29,2021 at 6:49 PM

Hi Lakshman,

In order to connect to an external database, you need to use the "Define Database Connection Command". Use the "Build Connection String" option to build the correct connection string for your database and the "Test Connection" feature to ensure the bot is able to connect to the database using the generated connection string. To test the connection string, make sure the database password is mapped correctly by following the tooltip guide.

The shared error indicates that the wrong driver option was selected when building the query string. Based on the shared information, you should probably be using one of the following (the driver should be selected depending on the database trying to stablish a connection):

Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Simple Provider

You are not authorized to reply, please click here to login and add your reply to this topic.