Zeoslib Portal

@EgonHugeist

Probably missed the # 0 at the end.
It is good but would not it be easier, faster way?

Michal

@EgonHugeist

Delete Integrated 'Security=SSPI;' from connection string and try.

Michal

@EgonHugeist For version ZEOS7eh_1381 A cursory check ADO works in Delpi2006 DelphiXE2-32 and DelphiXE2-64. Slow but it works. :lol: Update too. For now, I have tested only a connection to MS SQLEXPRESS 2008-64: Provider=SQLNCLI10.1;User ID=sa;Initial Catalog=master;Data Source=SERV\SQLEXPRESS;Init...

@EgonHugeist

Are you sure about this patch?

(1377) Length(AnsiString(RowAccessor.GetString(ColumnIndex, Result))));

It seems to me that for me it causes some strange effects, repeated insertions at the ends of text fields in Delphi XE2.

Michal Abramczyk

@jujibo

Thanks,
After today's patch
Fixed: TJDbGridTimeCtrl, store time value
looks to be good.

Michal Abramczyk

@EgonHugeist

Michael,
What do you think about this patch?:
http://zeosbugs.firmos.at/view.php?id=261

Michal Abramczyk

@EgonHugeist

False alarm. This is a bug of TJDBGridControl in Lazarus.

Michal Abramczyk

@EgonHugeist I tested Zeos7EH version 1370 for FB2.5 and Win7 (32/64) and D2006, DXE2 32/64 and Lazarus 32/64 and it seems that it is good. I found an error in Lazarus for TIME field in the DBGrid always saved time is 00:00:00. Returning to the ADO: - It is used only for Delphi - It works properly ...

@EgonHugeist Still observe two drawbacks ZEOS library. 1st For the Unicode version of Delphi (DX2), ADO(only) does not see the metadata and is in readonly mode (everything is fine for Delphi2006) 2nd There is freezing applications and data destruction for Firebird 2.5 and Delphi DX2 on the structure...

@EgonHugeist My sample settings: object ZConnection1: TZConnection UTF8StringsAsWideField = True PreprepareSQL = False Catalog = 'Northwind' Connected = True HostName = 'U7-PC\SQLEXPRESS' Port = 0 Database = 'Northwind' User = 'sa' Password = 'pass' Protocol = 'FreeTDS_MsSQL>=2005' Left = 12 Top = 1...

@EgonHugeist

Try to set the same name for Database and Catalog.

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 R...

@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

@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

@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