Zeoslib Portal

Hello According to this article https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server i use MSOLEDBSQL as provider in connection string (probably latest generation of OleDB driver). But in unit ZDBCOleDBUtils function ProviderNamePrefix2ServerProvider does not know the name ...

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

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

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

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

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

Maybe is it still I am not authorised to read this forum

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.

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 := ...

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 := ...

Now still remains: http://zeoslib.sourceforge.net/viewtopi ... =39&t=4088

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

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

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.

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