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.
Code: Select all
con1 := TADOConnection.Create(Self);
con1.ConnectionString := 'Provider=SQLNCLI11.1;UID=a;PWD=b;Server=(localdb)\test;Database=mydb;MARS_Connection=yes';
con1.Connected := True;
iTmp := 0;
con1.Execute('INSERT INTO tab1 (ID, value) VALUES (1, 2);', iTmp);
Assert(iTmp = 1);
How i do this same stuff with IZConnection and IZStatement objects?
Sorry for my poor english.