Zeoslib 8 + mssql error

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
carlos_tedex
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 07.04.2023, 04:40

Zeoslib 8 + mssql error

Post by carlos_tedex »

Goodnight!

I'm trying to connect to a SQL SERVER 2008 Express database with Zeos 8.0.0-beta, but the following error is occurring:

"The connection to the server failed, no proper handle was returned. Insufficient memory, unable to connect for any reason"

The following DLL is already in my executable folder "sybdb.dll"

Already in the version of Zeos 7.2.14 I can connect without problems with "ntwdblib.dll"

Any tips for using Zeos 8.0.0-beta connecting to SQL Server 2008?

Grateful!

-------------------
compile and run on:

Delphi XE2 - Windows
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeoslib 8 + mssql error

Post by miab3 »

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

Re: Zeoslib 8 + mssql error

Post by aehimself »

A more recent version can always be downloaded from here.
I'm using these builds for years now and they work like a charm.
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
carlos_tedex
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 07.04.2023, 04:40

Re: Zeoslib 8 + mssql error

Post by carlos_tedex »

It worked just fine with "libsybdb-5.dll".

Thank you all! :D
Post Reply