Hi,

I am trying to configure the session component to work in C/S mode but with no luck.  After reading many posts it appears that I have to:

1- Set the "Session Type" property to "stRemote".
2- Set the"RemoteAddress" property to the right IP address (In this case it was a local machine "127.0.0.1").
3- Open session.

But when I open my first query in design-mode I get an error stating that the table name is not part of the database schema!!!  This is happing in design-mode and run-time mode.  What is wrong?  BTW:  In EDB server application I did edit the server and change configuration path to the right configuration inside the database directory.  This is killing me because I've being searching and reading all posts and did not get anything new.  Any help?

I am using Windows7 + Delphi7 + EDB 2.08 build 3.
Regards,
Abdulaziz Jasser

Please show the steps after activating the session and until you tried to activate the query including the sql.

Does the sql statement work ok in EDB manager in remote session ?

EDB C/S tutorial covers the steps in as well (it uses edbtable but edbsession would be very similar except for sql statement) so i would suggest to review that also:
http://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=delphi&version=7&topic=CS_Application_Tutorial

Raul

Thanks Raul, however, I am very familiar with DBs (In fact I am a DBISAM user for more than 9 years).  I just finished migrating a huge DBISAM application (more than 300 forms and 300 reports) and everything works find in none C/S mode, but when switching the C/S mode my first SQL clause which is very simple (SELECT * FROM TB_Setup) does not work.  I followed what is written in the book but with no luck!!!  The SQL clause works fine in none C/S mode and works fine also in EDB manager.
Regards,
Abdulaziz Jasser

Abdulaziz,

have you tried to create session with SessionType = stRemote in
EDBManager with exact the same settings as in your application?
That should help you finding out what's wrong.

In addition:

You wrote:
<<
In EDB server application I did edit the server and change configuration
path to the right configuration inside the database directory.
>>

Did you double check that this is the correct path to the configuration
files?

Please compare the configuration path of your local database with the
configuration path set up in the Server's options.

The error message you get indicates that the configuration is different
from the configuration containing the information of your database.

Uli

Uli,

I think it is better to show some code.  Here is the code:

dmAccount.EDBSession1.Close;
dmAccount.EDBDatabase1.Close;
dmAccount.EDBDatabase2.Close;
dmAccount.EDBEngine1.Close;

sDirectory         := ReadIniFile(sIniFile,'Database','Directory');
sRemoteCompression := ReadIniFile(sIniFile,'Session' ,'RemoteCompression','6');
sSessionType       := ReadIniFile(sIniFile,'Session' ,'SessionType');
sRemoteAddress     := ReadIniFile(sIniFile,'Session' ,'RemoteAddress');

if sSessionType = 'stLocal' then begin
  dmAccount.EDBSession1.SessionType     := stLocal;
  dmAccount.EDBSession1.LocalConfigPath := sDirectory;

  dmAccount.EDBEngine1.ConfigPath   := sDirectory;
end else begin
  dmAccount.EDBSession1.SessionType := stRemote;
end;

dmAccount.EDBEngine1.TempTablesPath := GetWindowsTempDir;

dmAccount.EDBSession1.RemoteCompression   := StrToInt(sRemoteCompression);
dmAccount.EDBSession1.LocalTempTablesPath := GetWindowsTempDir;
dmAccount.EDBSession1.RemoteAddress       := sRemoteAddress;
dmAccount.EDBSession1.Open;

//Here I run my first SQL clause using "EDBSession1" and "EDBDatabase1" and I get the error.  Remeber, the same code works fine in none C/S mode.
Regards,
Abdulaziz Jasser

Abdulaziz


Have you set UseLocalSessionEngineSettings to false?

Roy Lambert [Team Elevate]

Roy,

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?

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?

I don't do C/S (keep telling myself I should) so can't easily answer your questions, however, its my understanding that once you've given the EDBEngine component the necessary server information (ServerAddress etc) all the other information should be configured in the server.

Rereading your posts I have to ask (sorry) have you configured the server?

As Raul / Uli suggested set up a remote session in EDBManager and troubleshoot in there.

Roy Lambert [Team Elevate]

Roy

<<Rereading your posts I have to ask (sorry) have you configured the server?>>

The only thing (I guess) to be done on the server side is to set the path of configuration file to right one, in my case it is located at the same directory of the database.

Best Regards,
Abdulaziz Jasser

Abdulaziz,

> The only thing (I guess) to be done on the server side is to set the path of configuration file to right one, in my case it is located at the same directory of the database.

You didn't answer my question: did you double check that?

1. Assuming you have a local session in EDBManager which works for your
database: Check "file folder" of the configuration path in "Edit Session"

2. Do the same in the options of your EDBSrvr

Are the folders identical?