Problem with client side active X accessing acces database on web server

[Roger Hembury]

Hi All,

Hope you can help / point me in the right direction with a little problem.

I have a VB6 created active X dll which is downloaded to the client using
<object> </object> so that I can control / use MS Word to create letters
using data extracted from an Access database which resides on a webserver.

The problem I am having is that I cannot connect to the access database on
the web server.

In the active x I have added a reference to a DLL (also written in VB6 which
my ASP pages use to get data with no problems) but the Active X fails as it
cannot find the database as it is looking for an "E
drive\folder\folder\database." which is hardcoded as part of the connection
string in the DLL and isn't a valid path on the client PC but is on the web
server.

So my question is this - how can I get a client side active x to look at an
access database sat on a web server or am I going about this in completely
the wrong way?

I am using classic ASP and VB6.

Any pointers / code examples would be appreciated.

Thanks

Roger

 

[Steven Burn]

As the DB is on the webserver, the "local" path needs to be changed to a
remote (http://) path.

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!