🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1160

Midas Newbie: General Questions

#1160
From: Rich Bair
Date: Fri, 03 Mar 2000 00:00
25 lines
2051 bytes
Hi and thanks for reading...

I am using MS SQL Server 7.0 and MIDAS to create a database app.  I have
successfully created an app server test program and a client test program.
These two programs and MS SQL server reside on the same NT 4.0 server.  The
application server is nothing more than a TTable and TDataSetProvider.  The
client app uses a TClientDataSet, TDataSource, TDataGrid???, and a
TDCOMConnection to view the table.  The client application works on the
server but not remotely on a seperate client PC.

The server app is an executable so I registered using regsvr32 (BTW, I can't
find the export on the context menu of TTables, TQueries, and TProviders
like the documentation suggest would be there).  I recevie an exception when
running the client app on a remote PC saying "error in string class".  I
have NOT registered the server app on the client PC and I don't really know
how to.  I mean I guess I could copy the server app executable over to the
client PC and use regsvr32 but it seems that there should be an easier
way....is there?

Also, how can you connect a TTable or TQuery to a MS SQL view or stored
procedure?  In MS SQL server are stored procedures just fancy views that are
more than just queries....they incorporate logic too?

Thanks,
Rich
Technical Details
Message-ID: <1FB5CC4B47C335DB.295207AF87C2EC73.EAC96F7B7BCB4EA5@lp.airnews.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,1cc22c3e47e8b1ec,start
X-Google-Attributes: gidfcd2b,public
From: "Rich Bair" <rhb3@nclink.net>
Subject: Midas Newbie:  General Questions
Date: 2000/03/03
Message-ID: <1FB5CC4B47C335DB.295207AF87C2EC73.EAC96F7B7BCB4EA5@lp.airnews.net>
X-Deja-AN: 592903815
X-Orig-Message-ID: <89pnbh$ckd@library2.airnews.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Time: Fri Mar  3 19:02:41 2000
Organization: Worldwide Worldlink (using Airnews.net!)
X-MSMail-Priority: Normal
NNTP-Proxy-Relay: library2.airnews.net
Abuse-Reports-To: abuse at wnclink.com to report improper postings
Newsgroups: borland.public.cppbuilder.database.multi-tier