ZEOS Component

[Stag76]

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]

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][+][-]

1. ZConnection1.LibraryLocation:=Application.Location+'ntwdblib.dll';

If the library is in the same directory of the executable.

[Stag76]

Thanks for the reply.

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

I'm going to try Inno-Setup.

[nouzi]

You can  use

Code: Pascal  [Select][+][-]

1. ZConnection1.LibraryLocation:='ntwdblib.dll';
2.  

or

Code: Pascal  [Select][+][-]

1. ZConnection1.LibraryLocation:='.\ntwdblib.dll';
2.  

[miab3]

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.

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]

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.