Borland Delphi and MS SQL 2000 Server

Discussion in 'Meet and Greet' started by _treenode_, Dec 15, 2008.

  1. _treenode_

    _treenode_ New Member

    Dec 10, 2008
    Likes Received:
    Trophy Points:
    Hi All,
    This is the very first time i've joined and posted in this forum... I'm looking forward lot of gurus here whom they can share their intellectual property with respect of course honoring what they can contribute..
    For the gurus kindly check my problem below 'bout Delphi and MS SQL 2000 Server...

    I'm trying to develop a three-tier system using borland studio 2006. I've designed my database application server & have establish a connection to MSSQL 2000 database example "NORTHWIND" using dbExpress objects (in remote data module). I'm using TSQLDataSet to access tables and Stored Procedures.

    Now in my client application, i'm using DCOM Connection and a Local Connection (in datamodule). It works fine to access the tables i've defined in my application database server as well as executing queries using commandtext properties of a clientdataset obtaining the expected results returned. What my problem is that, i know how to access STORED PROC with input parameters i've defined in my application database server but i don't know what object/s to use in my client side application executing the said SP. Accessing Tables & Queries work fine to me both in my app server and client app... Please help me by providing an example codes utilizing stored proc in ms sql passing input parameters in client side app.. please....

    Thank and best regards,

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice