ZEOS Component
lazarus / 16-Databases

----------------------------------------------------------------------
Stag76 · 2019-07-25 23:34

I've written a simple application that accesses an MSSQL DataBase
using ZEOS Components.
I've copied the .exe and ntwdblib.dll to another machine, but I can't
get it to run.
It errors stating that the SQL Server Does not exist.
If I compile the application on the target machine, it runs OK,
verifying the SQL Server etc.

Is there any library etc. associated with ZEOS Components that needs
to be copied to the target machine.

----------------------------------------------------------------------
GAN · 2019-07-26 01:11

You must link the location of the library in the
TZConnection.LibraryLocation property, by code (before connecting) or
by using the Object inspector.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ZConnection1.LibraryLocation:=Application.Location+'ntwdblib.dll';
If the library is in the same directory of the executable.

----------------------------------------------------------------------
Stag76 · 2019-07-26 22:03

Thanks for the reply.

I've checked the Library Location and it's OK.

I'm going to try Inno-Setup.

----------------------------------------------------------------------
nouzi · 2019-07-27 10:28

You can  use

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ZConnection1.LibraryLocation:='ntwdblib.dll'; or
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ZConnection1.LibraryLocation:='.\ntwdblib.dll';

----------------------------------------------------------------------
miab3 · 2019-07-27 13:35

Quote from: Stag76 on July 26, 2019, 01:34:14 amI've written a simple
application that accesses an MSSQL DataBase using ZEOS Components.
I've copied the .exe and ntwdblib.dll to another machine, but I can't
get it to run.
Stop using ntwdblib.dll to connect to MSSQL. This is a very old only
Win32 M$ library.
Start using libraries from the project freeTDS or ODBC or OLE DB (the
last in Zeos 7.3).
https://www.freetds.org/
https://sourceforge.net/projects/zeoslib/files/3rd%20party/FreeTDS/
ftp.freepascal.org/fpc/contrib/windows/

Michal

----------------------------------------------------------------------
Stag76 · 2019-08-06 07:46

Solved - I had left an entry in the SQL component of a TQuery (Select
* from dbo.TableName) that I had been using in the "Edit Fields"
Process. This was masked when the application was in development mode,
but failed when the .exe was deployed on another PC.