HELP!!!

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Post Reply
euquebrei
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 16.04.2020, 03:29

HELP!!!

Post 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.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: HELP!!!

Post by marsupilami »

Hello,

which settings do you use in your TZConnection object? Which error message do you get?
Best regards,

Jan
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 796
Joined: 18.11.2018, 17:37
Location: Hungary

Re: HELP!!!

Post 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.
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Post Reply