TOPIC:

Hello,

my configuration:

Typhon 6.9 r61812 FPC 3.3.1 r42912 Platform : x86_64-win64-win32/win64

I've develop an application can connect without problem to Sqlserver 2014:
I use Zeos with protocol 'FreeTDS_MsSQL>=2005' and I set library location with current executable directory, and works fine:
I downloaded from 'www.freetds.org/software.html' the precompiled dll 1.1.21 of Freetds.

From another pc in production I copied executable and all directory and run program but receive this error:
'Client-Library .....dblib.dll' found but could not be loaded. Check compile-target and library compatibility'....
I'm using the same library, the pc is the same Windows 10 64 Bit and I installed codetyphon 6.90 in this machine and I try to recompile,
but nothing of nothing... same error...


I'm really frustrated...

I think the problem is in FreeTDS library registration or security permissions

the dlls are in the executable directory,
I can't understand what the problem is....

But, in production pc with Codetyphon 32 bit, Freetds 32 bit dll, program works fine.....
On my pc both version works well, but if i move 64 bit dll from my pc to production pc I receive the error....
It's very strange error.

Yes, it's very strange error

ok, I can't afford such behavior in production programs, what kind of connection could I use alternatively?
I have seen that the zeos 7.3 support the ado, odbc, my target database is sql server 2014...
Thanks in advance.

I have resolved this problem!!!!!


With the walker dependency I saw the missing dependency ie the MSVCR100.DLL present in Microsoft visual C ++ 2019 Red Pack x64; installed this package and the program work..

Have fun...

I have searched the site of freetds.org but cannot find any dblib.dll, where exact did you find it ?

You can download the binaries here: sourceforge.net/projects/zeoslib/files/3rd%20party/FreeTDS/

Cheers