Data Abstract / Linux /SDAC

Hello,
I am trying to connect to an MSSQL server from Linux using DataAbstract (TDASchema) … with SDAC it works … I just have problems getting the schema to run with SDAC … Is there a trick ?
In the Driver Manager I have already set AutoLoad to False and am now trying to register the driver by adding the unit (uDASDACDriver) but now I have the problem that in this unit (OLEDBAccess,) interferes …

Greetings
Markus

Hi,

so you have Linux DA server and it works via SDAC

What exactly problem do you have?

You can safely comment OLEDBAccess in uses section of uDASDACDriver.pas. it isn’t required anymore

OK, thanks… it works now… but the strange thing is… when I compile the server under Windows, everything works perfectly… under Linux, I can connect… but TROBinMessage doesn’t respond… I check whether it is assigned and everything is correct…

Under Windows, ‘MessageBinBeforeProcessIncomingEnvelopes’ is also executed, but under Linux I get no response… Is there anything else to consider here?

Best regards

Mark

Hi,

this event works in simple testcase: testcase.zip (172.9 KB)

something can be wrong in your project.

OK, I replaced TROHTTPServer with TROIndyHTTPServer and now it works… Then I switched back to TROHTTPServer and everything works…
I’m a little frustrated because I can’t figure out why… But never mind, the main thing is that it works now… Thanks a lot for your help.
Best regards, Mark

One more quick question… In your test project and also in my source, the utilization on the Linux system goes to 100% after starting the server component… Is that normal or can something be done about it… I think there’s a thread stuck in an endless loop…

Hi,

update uROAsyncSocket.pas as

procedure TROListenThread.IntExecute;
..
      TROClientThread.Create(fOwner, l_realSock);
    end
    {$IFDEF POSIX} else if l_res = 0 then Sleep(5); {$ENDIF}// <<<<<<<<<<<<< line is added
  end;
end;

you can change Sleep(5) with Sleep(10) if it still takes a lot of CPU.

Logged as bugs://D19541.

bugs://D19541 was closed as fixed.