Data Access Pages on NT Server 4.0

[Mongooses]

Ok - I am not a NT person but I am trying to place Data Access Pages on NT Server 4.0 w/Svc Pak 6. I have installed IIS as well, and placed the DAP and the .mdb on the server in the appropriate directory. Now to the problem, as long as I am connected to the LAN I can access the data through the DAP using IE 5.5 on any machine connected to the LAN. However, I cannot access the data over the internet. The error is "'MyPath\MyDb.mdb' is not a valid path. Make sure the path name is spelled correctly etc.." I have used the UNC for the data source but is that valid outside of the LAN? If not how do I set the ConnectionString in the source code to point to the correct database.

Thanks,
JC [sig][/sig]

 

[DougP]

your question: I have used the UNC for the data source but is that valid outside of the LAN?
answer NO

But an IP address might work.
What are you trying to accomplsih with this?
Are you creating a WEB server and you want outside users to access it as well as internal (Intranet)?

How is the server connected to the internet?
You have to see if you can see it from the outside using Ping or something
at a Command Prompt type
PING 000.000.000.000
(which is the IP of the Server)

PS do you have a firewall in place?
NT Proxy Server 2.0 is a cheap resonable one.

[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[Mongooses]

DougP,

Thanks, I was afraid that was the case with the UNC. I am trying to make the database available over the web for updates using Access 2000 Data Access Pages. I get the error msg above. I can access the the page over the web via the IP address. It brings up the DAP with the fields etc. However, when the page tries to make a connection to the database it cannot locate the directory where the mdb is stored. I tried specifying the path name using the IP (i.e Source=

http://000.000.000.000/Folder/Dd.mdb.

But it appended a a directory path to the source (i.e. C:\WebPages\http:\...). And I of course had to set the security on the client browser to allow access to data across another domain. I guess my problem is how to get the html Data Access Page to look for the database on the server rather than the client using the ConnectionString tag.

Thanks [sig][/sig]

 

[DougP]

Not sure.
Does the client have to have Access 2000 to view the pages?

If you would like an independent solution then look at using .ASP (Active Server Pages). This of course is going to sound like a &quot;way out in left field approach&quot; and I thought the same thing when someone told me about it.
I am using Front Page 2000 to create the ASP pages which came with Office 2000 Premium.
But all you need is a browser to see the results. And if you decide in the future that Palm Pilots or Cell phones want to connect to the Intranet/Internet they can. That's what I'm working on now.

So whats really neat about it is that Our distributors can create and Order on-Line and we can create orders in house and they are all created in the same database.

[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[Mongooses]

I appreciate the responses. Unfortunately for DAP the client must have Access 2000 or at least a licenses to have the appropriate components and must also use IE 5.0 or greater. I will look again at using ASPs. I wanted to find something relatively easy that the people responsible for the DB could create and that was still dynamic so updates could be made via the net. I am a VC++ programmer and have written a rather substantial VC++ program with interfaces to populate the DB. There are 20+ forms and I don't feel like writing massive amounts of script so that a couple of people can view the data and submit there evaluation of the data over the Internet. Plus I don't want the extra burden of maintaining it since they make changes based on the day's temperature!

Thanks again,
JC [sig][/sig]

 

[brownws]

Was this problem ever resolved?

I'm having the EXACT same problem and would be very gratefull to anyone that could provide the correct snipet of code that points the off network user to the data base on the webserver.

Ideas on how to solve the problem by useing ODBC also welcome.

Thanks!

-Bill

 

[djali]

Mongooses,
Since you have VC++ in your machine, I am suspecting you have Visual InterDev as well. Building a form connected to the database is a breeze. It is not quite as easy as Data Access Pages but you should have no problem building it.
It is just like building an Access form in Design View rather than with the Wizard. It is even easier if you do not care as much as to how the form looks like as long as it does the job. Also, maintaining it is a breeze and entering data in the database will take only three lines of code. I hope this works.