I am trying to connect to mysql
When seting the properties of SQLConnection1
I change the following:
object SQLConnection1: TSQLConnection
ConnectionName = 'MySQLConnection'
DriverName = 'MySQL'
GetDriverFunc = 'getSQLDriverMYSQL'
LibraryName = 'libsqlmy.so'
Params.Strings = (
'DriverName=MySQL'
'HostName=ServerName'
'Database=Database Name'
'User_Name=user'
'Password=password'
'BlobSize=-1'
'ErrorResourceFile=./DbxMySqlErr.msg'
'LocaleCode=0000')
VendorLib = 'libmysqlclient.so'
Left = 64
Top = 80
end
When trying to connect seting connected to true
I get the following message "unable to load libmysqlclient.so
What am I doing wrong
Doing find
/var/www/html/php User=root -->$ find / -name libmysqlclient*
/usr/lib/mysql/libmysqlclient.so.10.0.0
/usr/lib/mysql/libmysqlclient.so.10
/usr/lib/mysql/libmysqlclient.so.9.0.0
/usr/lib/mysql/libmysqlclient.so.9
/var/www/html/php User=root -->$ls /usr/lib/mysql/libmysqlclient.so