I thought the "LocalConfigPath" property of the session will be ignored in a remote session.  Is that right or wrong?
Regards,
Abdulaziz Jasser

You are correct - LocalConfigPath is not used for remote sessions.

Even for local session it's only used if UseLocalSessionEngineSettings is true.

Raul


Abdulaziz Jasser wrote:

I thought the "LocalConfigPath" property of the session will be ignored in a remote session.  Is that right or wrong?
Regards,
Abdulaziz Jasser

Raul

I created another project and tested your code and it works like a dread.  Why my code is not working?  It is the same.

Raul

I created another project and tested your code and it works like a dream.  Why my code is not working?  It is the same.
Regards,
Abdulaziz Jasser

Main difference is that your code is using design time components so you need to make sure that nothing else modifies or changes those (maybe your app has code that runs on startup setting properties or maybe you have event handles that change something).

however if my code works you know your server and config is all setup properly so now it's just a matter of figuring out at the code level why the error.

One easy way to test that would be to just compare the key values of your session, database and query component - sessionname, database, databasename, etc.- when you get the error to see where the differences are and then you can track down the issue better.
I'd start with the query and compare the sessionname, databasename etc and see what they actually are when you get error vs when all is well.


Raul


Abdulaziz Jasser wrote:

Raul

I created another project and tested your code and it works like a dread.  Why my code is not working?  It is the same.

Raul and Roy

Thanks you guys so much.  The problem is solved.  It was the creation of the database.  You see, every time I run the program I drop the database and recreate it again inside the code.  

EDBSession1.Execute(Format('CREATE DATABASE "MyDatabase" PATH %s',[QuotedStr(sDirectory)]));


This works in a local session because the "PATH" is a local directory, but in a remote session the path is not visible.

Thank you guys again for your help.

Best Regards,
Abdulaziz Jasser

Abdulaziz,

<< It was True; I changed it to False but still no luck!!!  I want clear
something to myself, when I change the session to remote does EDB consider
the "ConfigPath" property of the TEDBEngine and "LocalConfigPath" property
of TEDBSession?  In other words, do I have to provide them in C/S mode? >>

No.

Tim Young
Elevate Software
www.elevatesoft.com