Zeoslib Portal

EgonHugeist,

I'm working with Lazarus 1.0.2 over FPC 2.6.0, with FreeTDS 0.91, all over Debian Linux 64 bits (and also in 32 bits). The example with "Ñandú" was compiled with 2.6.0 and is working ok.

I can compile in Linux whatever, or make tests if you want.

Hi EgonHugeist :
I was able to insert chars into MsSQL 2000, with the correct encoding, words like "Ñandú".
For this to work, for example in Lazarus over Linux (native UTF8), in the sources I use:
use LConvEncoding;
QQ.sql.add(' set nombre = '''+UTF8ToCP1252('Ñandú')+''' ');

Mario

- The error "None of the dynamic libraries can be found: ntwdblib.dll" appears because you choose protocol mssql , which is intended only for native Microsoft library on a Windows client. - For Debian, you can use FreeTDS libraries with Lazarus. For example, you put TZConnection with proto...

I was able to connect to MSSQL server 2000 with Zeos over Lazarus: - First of all, for FreeTDS you have to be sure that the server is listening TCP/IP on port 1433 (o whatever you defined), you can test it with command netstat -an on the server prompt. - Windows client Native: You can use TZConnecti...

I'm a bit confused about the FreeTDS libraries to use. Form SVN revision 1907, in ZPlainDbLibDriver.pas the libraries are: NTWDBLIB_DLL_LOCATION ='ntwdblib.dll'; LIBSYBDB_WINDOWS_DLL_LOCATION = 'libsybdb.dll'; LIBSYBDB_LINUX_DLL_LOCATION = 'libsybdb.so'; FREETDS_MSSQL_WINDOWS_DLL_LOCATION = 'msdblib...

Trying to compile revision 903 of ZeosDBO trunk (20110806) with Free Pascal Compiler 2.4.2 on Debian GNU/Linux amd64 x86_64 gives errors on ZClasses.pas file like: Error: No matching Implementation for interface method "IUnknown.QueryInterface (constref TGuid, out <Formal type>) LongInt; Cdecl;...