Accessing data on the local machine

[PetitPal]

Just a quick question,

I want to write a component (in VB?) that can be run within a web browser but retrieves data from an access database held on the local machine; i.e.: the machine that is running the browser session, not the server that is providing the page.

I assume that this is possible but I just wondered if there is anything I need to take into account that is different from writing a normal component. Basically; any advice welcomed!

Thanks.

=)

PetitPal

 

[v0520]

You can retrieve data directly from an asp page, try looking into ado.

But if you want to build it as a component, then your best bet would be to write an ACTIVEX dll. This dll would have methods within it to retrieve the access database data and return the data either as an ado recordset/ html or some other structure you desire.

Compile the activex dll, register it on your web server (see regsvr32 documentation) and then invoke the objects from an asp page.
(server.createobject("com class string&quot.

If your component returns HTML, you can simply write it out as

response.write objname.MethodisreturningHTML
If your component returns an ado recordset for example, your asp page would extract the data from the recordset and build its own html for display purposes.

Also, you could look into using xml and xslt for displaying the data.

Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov