ADODB & Active Form

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Darl Wed, 09 Aug 2006 11:20

#338

Author: Darl
Date: Wed, 09 Aug 2006 11:20

26 lines
1815 bytes

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.

Re: ADODB & Active Form

#340

Author: 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.
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads