Uli

<<Are the folders identical?>>

Yes...
Regards,
Abdulaziz Jasser

OK,

did you create a remote session with the same settings in EDBManager?

Uli

I just created a remote session from EDBManager and works fine with the same Server configuration!!!  Now what could be the problem?

Abdulaziz,

> I just created a remote session from EDBManager and works fine with the same Server configuration!!!  Now what could be the problem?

Ok, the next to try is:

Skip your ini-file and set the properties of the session in your
application manually. Does it work?

If it works, there must be something wrong in the ini-file.

Uli

Uli

I just did that for the second time and still don't work.  This is what I did:

EDBSession1.Close;
EDBSession1.SessionType                  := stRemote;
EDBSession1.RemoteCompression   := 6;
EDBSession1.RemoteAddress            := '127.0.0.1';
EDBSession1.Open;

The session open correctly and I can see that in EDBServer, but when running the first SQL clause I get the same error.
Regards,
Abdulaziz Jasser

Abdulaziz

You need to show us your code after session - i thought session opening was OK and problem was query and you have shown nothing for it. It's hard to assist like that.

Anyways, here is quick and dirty code that works for me - i'm even created it all in code so there is no design time requirements.

Setup:
- start EDBServer on the local system and make sure it has right config path (connect with EDBManager to verify that remote session sees database and table):
- i have a database called 'DBLOADER'
- inside the database i have a table called 'DATA1'

The code below creates a remote session a query against that session and shows num od records in the table. It runs OK for me as is

var
 mySession:TEDBSession;
 myQuery :TEDBQuery;
begin
 mySession := TEDBSession.Create(nil);
 mySession.SessionName := 'MYNAME';
 mySession.SessionType := stRemote;
 mysession.LoginUser := 'Administrator';
 mysession.LoginPassword := 'EDBDefault';
 mysession.RemoteAddress := '127.0.0.1';
 mysession.Open;

 myQuery := TEDBQuery.Create(nil);
 myQuery.SessionName := mysession.SessionName;
 myQuery.DatabaseName := 'DBLOADER';
 myQuery.SQL.Clear;
 myQuery.SQL.Add('SELECT * FROM DATA1');
 myQuery.Active := true;
 showmessage('Num of record = ' + inttostr(myQuery.RecordCount));

 myQuery.Close;
 mySession.Close;
 myquery.Free;
 mySession.Free;

Raul

Bellow is my code:

EDBSession1.Close;
EDBSession1.SessionType                 := stRemote;
EDBSession1.RemoteCompression   := 6;
EDBSession1.RemoteAddress            := '127.0.0.1';
EDBSession1.Open;

EDBDatabase1.Open;

qryConfig := TEDBQuery.Create(Application);
qryConfig.SessionName    := EDBSession1.SessionName;
qryConfig.DatabaseName := EDBDatabase1.DatabaseName; //This database is linked to Session1.
qryConfig.SQL.Clear;
qryConfig.SQL.Add('SELECT * FRM TB_Setup');
qryConfig.Open; //I get an error here is use C/S mode.

Abdulaziz


What happens if you try and query the information or configuration database?

Roy Lambert [Team Elevate]

ok,

I've added the database component and again the code below works without erros here.

Can you just run the code below against your edbserver (update the database and table names to reflect your environment of course). This would eliminate any dependency on the design time setup and config:

var
 mySession:TEDBSession;
 myQuery :TEDBQuery;
 myDB:TEDBDatabase;
begin
 mySession := TEDBSession.Create(nil);
 mySession.SessionName := 'MYNAME';
 mySession.SessionType := stRemote;
 mysession.LoginUser := 'Administrator';
 mysession.LoginPassword := 'EDBDefault';
 mysession.RemoteAddress := '127.0.0.1';
 mysession.RemoteCompression := 6;
 mysession.Open;

 myDB := TEDBDatabase.Create(nil);
 myDB.DatabaseName := 'MYDB';
 mydb.SessionName := mysession.SessionName;
 mydb.Database := 'DBLOADER';
 mydb.Open;

 myQuery := TEDBQuery.Create(nil);
 myQuery.SessionName := mysession.SessionName;
 myQuery.DatabaseName := myDB.DatabaseName;
 myQuery.SQL.Clear;
 myQuery.SQL.Add('SELECT * FROM DATA1');
 myQuery.Active := true;
 showmessage('Num of record = ' + inttostr(myQuery.RecordCount));

 myQuery.Close;
 myDB.Close;
 mySession.Close;
 myquery.Free;
 myDB.Free;
 mySession.Free;
end;

Roy

I can query the configuration about the databases and some other thing.  

I just noticed that if I set "LocalConfigPath" property of the session to the same configuration file of the one used by EDB server it works fine although the session type is remote and I can see that by debugging and I can see the session is created in the EDBServer!!!  Strange isn't it?