Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: isapi nano server trouble



Permlink Replies: 6 - Last Post: Jul 31, 2016 8:06 PM Last Post By: Dmitry Arefiev
Roberto Della P...

Posts: 83
Registered: 4/8/12
isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 30, 2016 9:35 AM
hello,

I'm testing delphi isapi dll 64bit with server nano IIS 10,
works ok until I put a firedac connection, in this case I get 404 error "file not found" exception.
Pool identity localsystem, execute permission, classic pipeline, everyone full control on the files.

Any idea how to solve it?
Does firedac needs some temp files with rw permission somewhere to start?

Thanks
Roberto
btw. the isapi works fine under full gui server iis
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 30, 2016 10:50 PM   in response to: Roberto Della P... in response to: Roberto Della P...
* What is your DBMS ?
* Do you use FireDAC tracing ?

--
With best regards,
Dmitry
Roberto Della P...

Posts: 83
Registered: 4/8/12
Re: isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2016 4:52 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Hello,

the problem appears also with only one FDConnection component,
(I'm using MongoDB).
I run the isapi as LocalSystem with full permissions.

Do you have ever tested isapi+firedac with nano 2016?

thnks
R.

Dmitry Arefiev wrote:
* What is your DBMS ?
* Do you use FireDAC tracing ?

--
With best regards,
Dmitry
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2016 5:40 AM   in response to: Roberto Della P... in response to: Roberto Della P...
Do you have ever tested isapi+firedac with nano 2016?

No and no plans. But you can fill a bug report.

Anyway, could you please check and provide a call stack for an exception in FireDAC (if any) ?
And if no exceptions in FireDAC, then could you please check application code ?

--
With best regards,
Dmitry
Roberto Della P...

Posts: 83
Registered: 4/8/12
Re: isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2016 5:51 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
Do you have ever tested isapi+firedac with nano 2016?

No and no plans. But you can fill a bug report.

Anyway, could you please check and provide a call stack for an exception in FireDAC (if any) ?
And if no exceptions in FireDAC, then could you please check application code ?

--
With best regards,
Dmitry

Maybe is firedac loading windows DLLs that are not found in nano (or with some special folder/permission system32....)?
I'll investigate further then I'll fill a bug in QC.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2016 8:06 PM   in response to: Roberto Della P... in response to: Roberto Della P...
Maybe is firedac loading windows DLLs that are not found in nano (or with some special folder/permission system32....)?

FireDAC MongoDB driver loads two DLL's: libmongoc-1.0.dll and libbson-1.0.dll

--
With best regards,
Dmitry
Roberto Della P...

Posts: 83
Registered: 4/8/12
Re: isapi nano server trouble
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2016 5:25 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Nano performance is brilliant
http://web.ageofascent.com/asp-net-core-exeeds-1-15-million-requests-12-6-gbps/

I have tested a ISAPI with 10K concurrent users calling GET every second, with 0 problems

Dmitry Arefiev wrote:
* What is your DBMS ?
* Do you use FireDAC tracing ?

--
With best regards,
Dmitry
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02