Hi,

I'm trying to create a simple client application to connect to a standard DBISAM server (the dbsrvr.exe file provided with the source code). The client application can connect without any problems to the server, but when I try to call a function like GetRemoteSessionCount for example, I keep getting this error:

"DBISAM Engine Error # 11308 An invalid or unknown request was made to the database server at '127.0.0.1'"

I'm connecting via localhost and the machine does not have any antivirus or any application that modifies the network traffic in any way.
I don't know if this is related but I'm also getting an error when I try to compile the DBISAM server source code, on unit main.pas line 1102:

"[DCC Error] main.pas(1102): E2033 Types of actual and formal var parameters must be identical"

Can anyone help?

Using:
DBISAM 4.31 build 3 VCL-CS-SRC
Delphi XE2 (32 bits)  Architect
Windows 7 (32 bits)

Ricardo Oliveira

Ricardo (or Pedro ?),

Are you compiling DBISAM server with Delphi XE2?
I'm not sure it can be compiled with such a recent version...
I think that it has to be compiled with D7, but we will have to wait for a confirmation from Tim.
I have been compiling it with D2006 and apart some some minor issues that I can overcome easily, it works great but never tried a newer version.

--
Fernando Dias
[Team Elevate]

Em 17-01-2012 15:16, Pedro Silva escreveu:
> Hi,
>
> I'm trying to create a simple client application to connect to a standard DBISAM server (the dbsrvr.exe file provided with the source code). The client application can connect without any problems to the server, but when I try to call a function like GetRemoteSessionCount for example, I keep getting this error:
>
> "DBISAM Engine Error # 11308 An invalid or unknown request was made to the database server at '127.0.0.1'"
>
> I'm connecting via localhost and the machine does not have any antivirus or any application that modifies the network traffic in any way.
> I don't know if this is related but I'm also getting an error when I try to compile the DBISAM server source code, on unit main.pas line 1102:
>
> "[DCC Error] main.pas(1102): E2033 Types of actual and formal var parameters must be identical"
>
> Can anyone help?
>
> Using:
> DBISAM 4.31 build 3 VCL-CS-SRC
> Delphi XE2 (32 bits)  Architect
> Windows 7 (32 bits)
>
> Ricardo Oliveira
>

I forgot to ask...
Do you really need to recompile the server?
why is that?

--
Fernando Dias
[Team Elevate]


Em 17-01-2012 15:16, Pedro Silva escreveu:
> Hi,
>
> I'm trying to create a simple client application to connect to a standard DBISAM server (the dbsrvr.exe file provided with the source code). The client application can connect without any problems to the server, but when I try to call a function like GetRemoteSessionCount for example, I keep getting this error:
>
> "DBISAM Engine Error # 11308 An invalid or unknown request was made to the database server at '127.0.0.1'"
>
> I'm connecting via localhost and the machine does not have any antivirus or any application that modifies the network traffic in any way.
> I don't know if this is related but I'm also getting an error when I try to compile the DBISAM server source code, on unit main.pas line 1102:
>
> "[DCC Error] main.pas(1102): E2033 Types of actual and formal var parameters must be identical"
>
> Can anyone help?
>
> Using:
> DBISAM 4.31 build 3 VCL-CS-SRC
> Delphi XE2 (32 bits)  Architect
> Windows 7 (32 bits)
>
> Ricardo Oliveira
>

Hi Pedro
<< "Pedro Silva" wrote in message
news:D8C1741A-077E-4D73-AFAF-7C0E64181FCC@news.elevatesoft.com...
when I try to call a function like GetRemoteSessionCount for example>>

Are you calling this function on the Data port or the Admin port. Note that
you can only call this function on an Admin session. Meaning Session
RemotePort := 12006 and RemoteEncryption := true;

Regards
Greg

Hi Fernando thank you for your answer.

I was trying to compile the server because I was getting out of options and it seemed reasonable to make sure that the server was compiled correctly and with the same DBISAM version I am using.
Now that you mention it I remember reading something about some restrictions when compiling DBISAM, not sure if its the same thing but I will try to find it.

Thanks,

Ricardo Oliveira

PS: Yes it Ricardo Pedro is the one who registered the account.


Fernando Dias wrote:


I forgot to ask...
Do you really need to recompile the server?
why is that?

--
Fernando Dias
[Team Elevate]


Em 17-01-2012 15:16, Pedro Silva escreveu:
> Hi,
>
> I'm trying to create a simple client application to connect to a standard DBISAM server (the dbsrvr.exe file provided with the source code). The client application can connect without any problems to the server, but when I try to call a function like GetRemoteSessionCount for example, I keep getting this error:
>
> "DBISAM Engine Error # 11308 An invalid or unknown request was made to the database server at '127.0.0.1'"
>
> I'm connecting via localhost and the machine does not have any antivirus or any application that modifies the network traffic in any way.
> I don't know if this is related but I'm also getting an error when I try to compile the DBISAM server source code, on unit main.pas line 1102:
>
> "[DCC Error] main.pas(1102): E2033 Types of actual and formal var parameters must be identical"
>
> Can anyone help?
>
> Using:
> DBISAM 4.31 build 3 VCL-CS-SRC
> Delphi XE2 (32 bits)  Architect
> Windows 7 (32 bits)
>
> Ricardo Oliveira
>

Hi Greg thank you for you answer.

I wasn't sure if the data port could be used to call that function.
Yet this problem also happens if I try to call a remote procedure (created by me) from the client application using the Data port with or without encryption.

Ricardo


"Gregory Sebastian" wrote:

Hi Pedro
<< "Pedro Silva" wrote in message
news:D8C1741A-077E-4D73-AFAF-7C0E64181FCC@news.elevatesoft.com...
when I try to call a function like GetRemoteSessionCount for example>>

Are you calling this function on the Data port or the Admin port. Note that
you can only call this function on an Admin session. Meaning Session
RemotePort := 12006 and RemoteEncryption := true;

Regards
Greg

Hi Pedro,
What I meant was that you can only call GetRemoteSessionCount on a Admin
session (port 12006). It will not work on port 12005. If you call it on
12005 you will get the exception "DBISAM Engine Error # 11308 ....."

Regards
Greg

Hi Gregory,

Thank you again for clarifying that.
The problem is that if I call a remote procedure (a procedure created by me for example) I also get the "DBISAM Engine Error # 11308".
The GetRemoteSessionCount was just an example (probably not a very good one ).

Here is what I am doing:
- Client App is connected to server at 127.0.0.1: Client data port; no encryption;
- Client App requests the remote procedure "ABC";
- Server returns with a "DBISAM Engine Error # 11308...";

Any idea of what could I do to correct this?
Once again thank you for your help Gregory.

Ricardo.

"Gregory Sebastian" wrote:

Hi Pedro,
What I meant was that you can only call GetRemoteSessionCount on a Admin
session (port 12006). It will not work on port 12005. If you call it on
12005 you will get the exception "DBISAM Engine Error # 11308 ....."

Regards
Greg

Hi Ricardo,
<<The problem is that if I call a remote procedure (a procedure created by
me for example) >>
Sorry, I have no idea what could be wrong in this case. I'm using the
standard server myself with no custom remote procedures.

I only know that all administrative calls ( like GetRemoteSessionCount)
would throw a "DBISAM Engine Error # 11308" if you call it on the server
Main port. I usually have 2 sessions for my apps, one for the data session
for all my queries and tables. Another for Admin (RemotePort := 12006,
Remote Encryption := true) for all my administrative calls. The Admin
session is not linked to any queries, its purely for Admin calls only.

Regards
Greg

Ricardo,

<< The problem is that if I call a remote procedure (a procedure created by
me for example) I also get the "DBISAM Engine Error # 11308". >>

If you're still getting such an error, then you're still not using the
correct port.  Server procedures must use the data port, and admin calls
must use the admin port.

--
Tim Young
Elevate Software
www.elevatesoft.com