Search found 17 matches

by Alfa000
08.01.2015, 16:47
Forum: OleDB (Microsoft Windows)
Topic: OleDB Alpha testers thread!
Replies: 5
Views: 1895

Re: OleDB Alpha testers thread!

I can't download last SVN revision because is not available on the sf.net today. Bu i found next issue. var u: TZURL; con: IZConnection; stat: IZStatement; RS: IZResultSet; SQL: string; begin u := TZURL.Create; u.Protocol := 'OleDB'; u.Database := 'Provider=SQLNCLI11.1;Trusted_Connection=yes;Encrypt...
by Alfa000
08.01.2015, 00:44
Forum: OleDB (Microsoft Windows)
Topic: OleDB Alpha testers thread!
Replies: 5
Views: 1895

Re: OleDB Alpha testers thread!

Hello. In metod TZOleDBResultSet.GetString(ColumnIndex: Integer) you have missing this line: begin Result := ''; //This line is missing in r3591 if not (IsNull(ColumnIndex)) then begin ... ... end; end; If returned field is null, then result is undefined! Same problem is in some next methods (and ma...
by Alfa000
07.01.2015, 20:35
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

Re: ZDBC connection to MSSQL LocalDB

What about blob? If i define table: CREATE TABLE "testtable" ( "Id" INT IDENTITY(1,1) PRIMARY KEY, "My_memo" NVARCHAR(MAX) NULL DEFAULT NULL ); If table has one record {"Id": 1, "My_memo": NULL} and if i execute this select: SELECT "Id" FRO...
by Alfa000
06.01.2015, 21:39
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

Re: ZDBC connection to MSSQL LocalDB

Thanks for reply. I trace TZOleDBDriver create process. This was good, i use ZDbcOleDB.pas correctly. But i was finally found reason of issue. Protocol is case sensitive :shock: . 'oledb' not work, but 'OleDB' work properly. At the end, this code work :up: var u: TZURL; con: IZConnection; stat: IZSt...
by Alfa000
06.01.2015, 19:24
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

Re: ZDBC connection to MSSQL LocalDB

Ok, if i use this code: var u: TZURL; con: IZConnection; stat: IZStatement; iTmp: Integer; begin u := TZURL.Create; u.Protocol := 'oledb'; u.Database := 'Provider=SQLNCLI11.1;UID=a;PWD=b;Server=(localdb)\test;Database=mydb;MARS_Connection=yes'; con := DriverManager.GetConnection(u.URL); //This line ...
by Alfa000
02.01.2015, 10:09
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

Re: ZDBC connection to MSSQL LocalDB

Maybe is it still :wink: I am not authorised to read this forum :(
by Alfa000
30.12.2014, 16:43
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

Re: ZDBC connection to MSSQL LocalDB

Hello EgonHugeist. How i do the same connection to MSSQL LocalDB througth new OLEDB support (initialized now in testing-7.3 branch)?

Thanks for reply.
by Alfa000
10.11.2013, 14:30
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

Re: ZDBC connection to MSSQL LocalDB

Yes, this works. var u: TZURL; con: IZConnection; stat: IZStatement; iTmp: Integer; begin u := TZURL.Create; u.Protocol := 'ado'; u.HostName := ''; u.Database := 'Provider=SQLNCLI11.1;UID=a;PWD=b;Server=(localdb)\test;Database=mydb;MARS_Connection=yes'; u.UserName := ''; u.Password := ''; u.Port := ...
by Alfa000
02.11.2013, 00:18
Forum: MS SQL Server
Topic: ZDBC connection to MSSQL LocalDB
Replies: 11
Views: 3054

ZDBC connection to MSSQL LocalDB

Hello. I need connect to SQL Server Express LocalDB with your IZConnection (i need only ZDBC api). How use connection string for this connection? For testing purpose i create this simple code with TAdoConnection. This code works perfect. con1 := TADOConnection.Create(Self); con1.ConnectionString := ...
by Alfa000
10.09.2013, 15:01
Forum: ZeosLib 7.0 Stable Forum
Topic: 7.0.5 Memory leak
Replies: 10
Views: 1739

Re: 7.0.5 Memory leak

Ok, i try FastMM4 with full debug mode on this really simple program. This program does allmost nothing. But memory leak is still reported. program LeakProj; {$APPTYPE CONSOLE} {$R *.res} uses FastMM4, //FullDebugMode enabled System.SysUtils, ZDbcIntfs, ZDbcMySql; var sConString: string; LZeos: IZCo...
by Alfa000
09.09.2013, 22:09
Forum: ZeosLib 7.0 Stable Forum
Topic: 7.0.5 Memory leak
Replies: 10
Views: 1739

7.0.5 Memory leak

Hello If i try this simple project, then memory manager generate memory leak mesage: program LeakProj; {$APPTYPE CONSOLE} {$R *.res} uses System.SysUtils, ZDbcIntfs, ZDbcMySql; var sConString: string; LZeos: IZConnection; begin ReportMemoryLeaksOnShutdown := True; sConString := Format('zdbc:%s://%s:...
by Alfa000
09.09.2013, 21:26
Forum: ZeosLib 7.0 Stable Forum
Topic: 7.0.5. DB unit in ZDbcIntfs.pas
Replies: 1
Views: 585

7.0.5. DB unit in ZDbcIntfs.pas

Hello

In interface uses part of ZDbcIntfs is declared DB unit. I use only ZDBC layer without Dataset. By my opinion DB unit has no reason in ZDbcIntfs unit.
by Alfa000
09.09.2013, 21:21
Forum: ZeosLib 7.0 Stable Forum
Topic: 7.0.5 TZMySQLPreparedResultSet.GetLong problem
Replies: 1
Views: 693

7.0.5 TZMySQLPreparedResultSet.GetLong problem

Hello. Next code pretty show bug... Normal IZStatement (MySQL) works well but IZPreparedStatement (MySQL) don't. var LStat: IZStatement; LPrepStat: IZPreparedStatement; LRS: IZResultSet; sTableQuery: string; ZVariant: TZVariant; LInfo: TStringList; sConString: string; LZeos: IZConnection; begin sCon...
by Alfa000
24.05.2013, 22:12
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] Wrong parameter type SmallInt vs. Byte
Replies: 4
Views: 656

You are welcome. Good work about ZeosLib. In this case i use MySQL 5.5.

Go to advanced search