By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,042 Members | 1,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,042 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Feb 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

"Roger Hembury" <ro***********@btinternet.com> wrote in message
news:ds**********@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
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

Feb 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.