🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #340

Re: ADODB & Active Form

#340
From: Viatcheslav V. Vassiliev
Date: Fri, 11 Aug 2006 08:04
49 lines
2688 bytes
You can not pass connection object from server to client. You can save 
recordset to stream, send stream to client and load recordset from stream at 
client. You may setup your DBMS to allow access from Internet (depends on 
DBMS).

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Darl" <D@nospam.com> �������/�������� � �������� ���������: 
news:44d9c50f@newsgroups.borland.com...
> NB: I Posted this on the activex group but no body reply so I guess i 
> posted to the wrong group, hence am posting here again
>
> Hi,
>
> I have an ActiveX Active Form Application (.ocx) which I depolyed via IIS.
>
> The Active Form Application is running fine.
>
> Now I want to place DBGrid on the Active Form and bind it to a Database on
> the server, when the Active Form loads on the clients web broswer, the
> ADOConnection object will be looking for the Database on the client 
> station.
>
> How can I direct the adoConnection to connect to the Database on the 
> server.
>
> on the loading asp page using server.createObject, I was able to connect 
> to
> the Database on the server, but then I don't know how to pass the created
> object to the Active Form for binding to the DBGrid on the Form.
>
> Please can any one please direct on how to use an TADOConnection control 
> on
> an Active Form and have it connect to the Database on the Server.
>
> ATTN: [Remy]
>
> Thanks All
> Darl.
>
>
> 
Technical Details
Message-ID: <44dc39fc$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <44d9c50f@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,370b7d6759b7a47c
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <44d9c50f@newsgroups.borland.com>
Subject: Re: ADODB & Active Form
Date: Fri, 11 Aug 2006 12:04:09 +0400
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-Antivirus: avast! (VPS 0632-2, 10.08.2006), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 85.93.138.132
Message-ID: <44dc39fc$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1155283452 85.93.138.132 (11 Aug 2006 01:04:12 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail