Forum > Databases
[Solved]CREATE FULLTEXT CATALOG statement cannot be used inside user transaction
ALAU2007:
Thanks for all.
I follow Zvoni's instruction. I copy the mssqlconn.pp to project folder as mssqlconn_v2.pp
and Move the Private Procedure "procedure Execute(const cmd: string); overload;"
Update the testing program as:
uses ...., mssqlconn_v2, ...
procedure TForm1.Button2Click(Sender: TObject);
var
Connection: TMSSQLConnection;
begin
Connection := TMSSQLConnection.Create(nil);
try
Connection.HostName := 'hostname';
Connection.DatabaseName := 'test1';
Connection.UserName := 'sa';
Connection.Password := 'password';
Connection.Open;
Connection.Execute('CREATE FULLTEXT CATALOG MyFullTextCatalog;');
finally
Connection.Free;
end;
ShowMessage( 'OK');
end;
It WORKS. The catalog is created. Thanks again.
TRon:
@ALAU2007
Thank you for testing and reporting back the results.
@Zvoni
That is a bit of an oversight :)
Good investigatory process, thank you very much for that (it did not even crossed my mind that this would be the culprit).
Zvoni:
--- Quote from: TRon on August 14, 2024, 05:34:32 am ---@ALAU2007
Thank you for testing and reporting back the results.
@Zvoni
That is a bit of an oversight :)
Good investigatory process, thank you very much for that (it did not even crossed my mind that this would be the culprit).
--- End quote ---
Tron, that’s the thing: i think it was the same with SQLite and a PRAGMA-call. I had to expose a way to access the low level API
Navigation
[0] Message Index
[*] Previous page