Data Access Page

[Joel Allen]

I have a page that runs a query. When you open the page, a window pops up
and ask you what the job number is. You enter the job number, hit enter,
and the data pulls up and works perfect.

When going to this page outside of my network (from home), the parameter box
does even pop up and page opens and all the fields are blank.

How can I fix this?

Thank you very much for your help,
Joel

 

[Sylvain Lafontaine]

You must use a VPN to connect to your network (at work).

If you are using a MDB file as the backend, the OLEDB provider won't work
easily over the Internet (in fact, it's very hard to set up) and if you are
using SQL-Server as the backend, quite probably that the connection is
blocked by an intervening firewall.

 

[Joel Allen]

My customers need to connect to this, so VPN will not work.

Do you have a suggestion as to how to get to the data? e.g. split database,
use other type of .htm file vs.Data Access Page, etc......

Thanks much, Joel

 

[Sylvain Lafontaine]

If you have customers that need to connect to this, then my best suggestion
would be that you forgot about DAP and use something else like ASP.NET.

If you try to keep going on with DAP and even if you try to install a
SQL-Server outside of any firewall, many of your customers will still be
blocked by their own firewall; so you will still be out of luck for many of
them. Of course, there is no need here to mention all the potential
security problems of trying to run a SQL-Server installation on a DMZ zone.
As for using MDB as the backend, the situation is probably even worse.

In my opinion, trying to use DAP over the WAN is simply a dead end. Forget
about them and go with ASP.NET. More work but at least it will work for
everyone and will be pretty secure. DAP are easy to start with, especially
on a LAN; however, it doesn't take too long before you start to realize that
you have just begun an endless journey of bugs and frustration.

 

[Joel Allen]

Sylvain,

You've been very helpful. I'm going to start researching ASP.net even
though I don't know much about it. I think I'll figure it out eventually
though. Thanks so much for you time!

Joel