HELP!!!
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: HELP!!!
Hello,
which settings do you use in your TZConnection object? Which error message do you get?
Best regards,
Jan
which settings do you use in your TZConnection object? Which error message do you get?
Best regards,
Jan
Re: HELP!!!
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.
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
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