Zeoslib Portal

@EgonHugeist

When in dbgrid in TIME cell I enter:
1:1:1 and leave cell then 01:46:34 appears in cell
2:2:2 and leave cell then 01:46:34 appears in cell
3:3:3 and leave cell then 23:27:09 appears in cell
4:4:4 and leave cell then 01:46:34 appears in cell

Lazarus/fpc 32-bits Windows, Firebird 2.5 Windows.

Michal Abramczyk

Michal,

Bug solved.
patch done Rev. 1301. Tested with FPC32 but not with FPC64. Can you test this too?

Michael

@EgonHugeist

Now is correct in 32 and 64 bit version Lazarus/fpc for Windows.

Michal Abramczyk

miab3,

but i made a mistake on the Date-fields. Please update..

Michael

@EgonHugeist

I test the FreeTDS_MsSQL>=2005 on Delphi2006.
I do have two questions.
First Why limiting using fetchRow does not work?
Second How to manage Standard Security/Windows NT Integrated Security?

Michal Abramczyk

@miab3,

hum we (rautgigi and me) are actually not 100% ready with the FreeTDS support. I prepered some parts for rautgigi to get him better in the last changes and i hope he is able to manage the fixing of the remaining parts. So be patient with that stuff please. The repositories are the best way to work together.

Concerning the Nt-authentification:
use 'NTAuth=True' or 'trusted=True' or 'secure=True' on the TZConnection.Properties.

Concering the RowLimitation i think we've to introduce PacketRecords=-1 for the row pendings. But that is actually not ready. Be patiant Michal. I was thinking of suppressing the FreeTDS-plains while working on them, but some help couldn't be wrong..

Michael

@EgonHugeist

Already explained. I did not know that for freetds udp1434 need to be open.
Could you compile FreeTDS.dll for 64-bit Windows.
I'd tried it on DXE2.

Michal Abramczyk

miab3,

i don't understan you here:

Already explained. I did not know that for freetds udp1434 need to be open.

Concerning the 64Bit File: I must admit i didn't tryed it. Actually i got allways linker errors. So i'll ask rautgigi for help...

Michael

Hi,

I manage to build a 64Bit dblib, put I don't have an environment in order to test it.
So I attach the file, and i will appreciate if you can let us know about the results. If it is ok, i will put all the x64 versions it inside the test\lib folder

All the best,
Bogdan

Hi,

The 1434 udp port is for SQL Browser and is not required. It is used by freeTDS if it's available.

Bogdan

@rautgigi

At Delphi XE2 64-bits at a cursory test your library msdblibr.dll(64) and ZEOS works.

(Why is it so small, much smaller than the 32-bit?)

Michal Abramczyk

I tested briefly ZEOS 7 EH rev. 1339 with msdblibr.dll 32 and 64 bits.

It works on Win7 32/64 with MSSQL Express 2008 for:
1. Delphi2006
2. Delphi XE2 32 and 64 bits
3. Lazarus / fpc 2.70 distribution
(http://www.pilotlogic.com/sitejoom/index.php/codetyphon)
Lazarus 1.1.0 Source from SVN 26-5-2012 Rev 37429
FreePascal 2.7.1 Source from SVN 26-5-2012 Rev 21396
32 and 64 bits.

Michal Abramczyk

Thank you Michal.
The size of the library is smaller than the 32 Bit version because is compiled with vs2010, and in the lib folder are the compiled with Borland C++ 5.5.
I will make all the builds : Borland W32 MS/Syb Debug/Releas and VS2010 W32 / W64 and i will put them inside the lib folder.

Bogdan

rautgigi, miab3,

Wow, these are good news! Bogdan add that file to our library folder.

Michal i run always into the same issue: I can connect to 'master' but if i try to connect to my created database 'zeoslib' or 'egon' i get always an exception: 'could not locate 'zeoslib' in the sys.databses. check....' can you help me here? Is there a setting missing? All i've done according FreeTDS was theoretical and base on Bogdan's workout. So i'm happy that it works and and thank him for that support. I'm sure Bogdan will do the maintainance fixes and additional supported functionalities, which we need for FreeTDS. But it would be great to test some things as second pair of eyes too. Actually i see some missing parts like NChar text and binary data on the prepared statements..

While Bogdan is reworking my dblib changes i decided to switch to Oracle and fix that driver too in the 'egon' kind. So he has time and we do not work on the same files..
Michal if you find some FreeTDS leaks write us, or help us if you doupt.


Michael

@EgonHugeist

Try to set the same name for Database and Catalog.

Michal Abramczyk