Connection to an MariaDB database

There is asked to me to evaluate a number of databases for use with our customers. This database has to be installed on several (500) systems. You can think of windows 32 and windows 64. Neither of the databases I studied do install support for making connection. That is very strange because without a connection nobody can evaluate or use a database.

With a connection I personally mean a connection from Delphi (XE5) but the same applie to VB, C++, etc. Database connection from Delphi are typically established with the file DBXConnections.ini. In this file are several predifined connections. The format of this definitions are:

[OdbcMaria]
driver=C:\Program Files\MariaDB\MariaDB ODBC Driver 64-bit\maodbcs.dll
DriverName=Odbc
Database=C:\Program Files\MariaDB 10.0\data\ibdata1
User_Name=root
Password=***********
IsolationLevel=ReadCommitted
RowSetSize=20
ConnectionString=

The problem were I am faced with is the 'name of the driver and the name of the database'. May be there are other strings important. May be there has something to be done with the PATH or the registry.

Without a working set of strings there isn't a connection. Without a connection any databasesystem is useless.

Please make an item in the knowledge base with a clear example of a working connection string with a MariaDB database. I asume, that such will work for every compiler ?

heidisql does not use ODBC. Look elsewhere.

heidisql does not use ODBC. Look elsewhere.

Gents

I makes no any difference how a database is communicating with the outside world. The only thing I am interesting is the connection. With OBDC admin on my computer I got a connection. But when I have to do this in another way it is OK to me.

For the time being I need the name of the driver. I need the name of the database. Example of working connection with interbase with DBExpress:

[mmx_server]
DriverName=InterBase
DriverUnit=Data.DBXInterBase
DriverPackageLoader=TDBXDynalinkDriverLoader,DbxCommonDriver190.bpl
DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borland.Data.DbxCommonDriver,Version=19.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
MetaDataPackageLoader=TDBXInterbaseMetaDataCommandFactory,DbxInterBaseDriver190.bpl
MetaDataAssemblyLoader=Borland.Data.TDBXInterbaseMetaDataCommandFactory,Borland.Data.DbxInterBaseDriver,Version=19.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
LibraryName=dbxint.dll
LibraryNameOsx=libsqlib.dylib
VendorLib=GDS32.DLL
VendorLibWin64=ibclient64.dll
VendorLibOsx=libgds.dylib
Database=C:\frits\sysadres.ib
User_Name=sysdba
Password=masterkey
Role=RoleName
MaxBlobSize=-1
LocaleCode=0000
IsolationLevel=ReadCommitted
SQLDialect=3
CommitRetain=False
WaitOnLocks=True
TrimChar=False
DisplayDriverName=InterBase Server
BlobSize=-1
ErrorResourceFile=
RoleName=RoleName
ServerCharSet=
Trim Char=False
SEP=

The only thing I am interesting is the connection.

Not doubt about that. But you cannot spam a random forum with your problems, just like you don't walk into a bakery and ask them how to repair your microwave oven.

Very nice comparison, kalvaro :)