We help IT Professionals succeed at work.

How do I send SQL to a remote server .......

belcher
belcher asked
on
I have created a simple remote application server, and also a client which connects using sockets. I am using Interbase Server. The client does not use the BDE (the Server does though). The client connects and I can see the data in a grid, I can also make changes and apply the updates. On the server I have created a simple stored procedure . I can access this procedure only when I place a StoredProc component on the client. This then uses the BDE which I don't want.

The problem is , I would like to run the stored procedure remotly from the client and see its result. And I would also like to send SQL requests and see thier result in a grid or text box. How can I achieve this in a client server situation without using the BDE on the client ?

Thanks
From
Richard
Comment
Watch Question

Listening.......

Commented:
Hi

 u can direct ib components....

Commented:
HI,
Maybe you just forgot to place a Provider on the client
and link it to ClientDataSet?
(I assume that your StoredProc returns some select_ions).
Sincerely,
Nestorua.

Author

Commented:
hi Nestorua , I did place a provider on the remote application server. I have managed to send simple SQL statements to the server and receive data back. But I still cannot access the remote procedure. You mentioned puting a provider on the client and linking this to a client dataset. How do I link the provider to the client dataset on the client. I have tried, but the properties dont show the clientdataset. When I use a storedproc on the client which uses the BDE , then the procedures are returned to the component.

Hi SBSen, I dont have any IB components, can they bypasss the BDE, and will they make calling procedures / send SQL simpler/ more efficient. Where would I download these components ?


Commented:
Hi,

Which version of delphi do u use?

In delphi 5 u have Interbase palette where u have direct Interbase component which will bypass the BDE or u can use the ADO component also, provided u have to install the OLEDB of Interbase in u r system.

regards
sbsen.

Author

Commented:
Hi, I have Delphi 4 Client server......
Commented:
Hi, Belcher,
I am sorry, I mean to place TStoredProc Component
and TDataSetProvider Component on Server side and link it to the StoredProc, then place TClientDataSet Component on Client side and link it to the DataSetProvider (on the Server).
Sincerely,
Nestorua.
belcher:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
BRONZE EXPERT

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

accept nestorua's comment as answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

geobul
EE Cleanup Volunteer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.