Page 1 of 1
HELP!!!
Posted: 16.04.2020, 03:33
by euquebrei
Guys, I can't connect to mysql8 using Zeos, you could tell me how you do it so I can see where I'm going wrong.
Re: HELP!!!
Posted: 16.04.2020, 08:16
by marsupilami
Hello,
which settings do you use in your TZConnection object? Which error message do you get?
Best regards,
Jan
Re: HELP!!!
Posted: 16.04.2020, 12:47
by aehimself
object SQLConnection: TZConnection
ControlsCodePage = cCP_UTF16
AutoEncodeStrings = True
ClientCodepage = 'utf8mb4'
Catalog = ''
Properties.Strings = (
'controls_cp=GET_ACP'
'codepage=utf8mb4')
TransactIsolationLevel = tiReadUncommitted
HostName = 'databasehost.lan'
Port = 0
Database = 'database'
User = 'databaseuser'
Password = 'databasepassword'
Protocol = 'mysql'
Left = 560
Top = 376
end
Then SQLConnection.Connect. Be careful in what library you are using; I was struggling a lot because of Oracle lately. For 64 bit apps I'm using libmysql.dll 8.0.18.0; for 32 bit 6.1.11.0 is the latest I could find.