DCOM and SQL

[Bias]

Hi.

I am currently working on a rather waste project utilizing an sql database. At the moment the client talks directly to the SQL server and everything works like a charm. But the project is growing and need for more clients are neccesary as well as different network setups. This will complicate things due to firewalls and such. As well as i need to create a licensing procedure. I thought that Dcom would be the solution, creating a server app that would run all the sql queries, as well as beeing the license server. I am extremley new to Dcom programming in Delphi7 and need some pointers in the matter. At this point i have successfully created a service application with an automation object, with wich i can retrieve some data. But i need to be able to retrieve large chunks of data from the query recordset and send it to the client for viewing. How do i do that? I have tried to search for information about variant arrays and to be able to use that, but my programming skills is not that good. I need some examples on how to do it. What is the best solution for me? Is there anyone out there who can help me?

Kind regards,
Tobias Petersson, Canon, Sweden.

 

[whosrdaddy]

Hi, I think you might want to checkout this site:

http://www.components4programmers.com/products/kbmmw/index.htm

no need for DCOM and you can send your queries over standard ports (like port 80)

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!