ASP access to Data on Remote devices
in [ASP]
|
From: p byers on 25 Aug 2008 03:54 Good Morning Folks I have a LAN Among the several connections to it are the following four devices: A MAXSTOR network Storage Device A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4) A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) All of the PCs are running IIS The 'Public Internet' is connected via a Broadband connection from the LAN On the MAXSTOR is a folder called 'CENTRALDATA' In that folder are a number of Access dotMDB files. The Access files can be opened on all of the PCs by double clicking on them in Windows Explorer. ================================================================ QUESTION ONE Can the access files on the MAXTOR be accessed from dotASP pages on the three PCs ?? If so, how ?? If so, are there any simple tutorial pages that explain in simple language how to do it ?? ================================================================ I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that I own QUESTION TWO Can the access files on the "Public Internet Server" be accessed from dotASP pages on the three PCs ?? If so, how ?? If so, are there any simple tutorial pages that explain in simple language how to do it ?? ================================================================ I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that I own QUESTION THREE Can the access files on the "Public Internet Server" be accessed from dotASP pages on other "Public Internet Server" servers ?? If so, how ?? If so, are there any simple tutorial pages that explain in simple language how to do it ?? ================================================================ By the way, I tried to create Virtual Folders using IIS Admin on the three PCs on the LAN, but it will not allow it for 'Remote' folders. I await your replies with interest Thank You in Advance Pete (Northolt UK)
From: Anthony Jones on 25 Aug 2008 09:10 "p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B26545.3B05D32C(a)sst-ltd.co.uk... > Good Morning Folks Whether it is morning depends on a) when the reader reads the message and b) what timezone they are in. I read this this morning and I'm UK based to so good morning back. But its afternoon now, or is it? > > I have a LAN > Among the several connections to it are the following four devices: > A MAXSTOR network Storage Device > A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4) > A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) > A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) > > All of the PCs are running IIS > > The 'Public Internet' is connected via a Broadband connection from the > LAN > > On the MAXSTOR is a folder called 'CENTRALDATA' > In that folder are a number of Access dotMDB files. > > The Access files can be opened on all of the PCs by double clicking on > them in Windows Explorer. > > ================================================================ > QUESTION ONE > > Can the access files on the MAXTOR be accessed from dotASP pages on the > three PCs ?? > > If so, how ?? > > If so, are there any simple tutorial pages that explain in simple > language how to do it ?? > You haven't stated whether you are expecting users to access the site anonymously or not. If all access is to be from users who have domain accounts on your network then turn off anonymous access on the IIS site and turn on windows intergrated security. Now grant access for those users to the file share and folders containing the MDBs as would if the were accessing them via the file system. If you need anonymous access you will need more work. By default IIS creates an IUSR_<machinename> machine guest account which it used to access files. This account has not access to the network. Therefore you need to create a new account in the domain and change the anonymous access on the IIS to use this new domain account. Grant this account file access as above. > > > > ================================================================ > I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that > I own > > QUESTION TWO > > Can the access files on the "Public Internet Server" be accessed from > dotASP pages on the three PCs ?? > > If so, how ?? > > If so, are there any simple tutorial pages that explain in simple > language how to do it ?? > I guess that depends on what you mean by 'access'. If you mean can you use JET queries against a copy of an MDB held on a public server I would say thats probably not a good idea. What is it you want to do? Download it? Do you need to upload it as well. > > > > ================================================================ > I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that > I own > > QUESTION THREE > Seems identical to second. > > ================================================================ > By the way, I tried to create Virtual Folders using IIS Admin on the > three PCs on the LAN, but it will not allow it for 'Remote' folders. > Creating virtual folders for a UNC path is possible, you must specific a user name and password that IIS will use to access the folder. That however would not help with DB queries against MDBs on remote server. -- Anthony Jones - MVP ASP/ASP.NET
From: p byers on 25 Aug 2008 11:15 Anthony Thank you for your reply. I tried so hard not to 'screw-up' my request and to give all of the relevant information !! Such irony to slip-up on the 'Salutation' - lol The access to the ASPages (both on the PCs on the Local LAN and on the 'Public Internet') will be anonymous. The access to the Databases is Jet Queries only - not uploading or downloading. In simple language, I would like several servers running IIS (LAN and 'Public Internet') to serve ASPages to be able to use the a Common (the same) Database - not individual copies. -AND- to do it simply by quoting the appropriate Shared Folder in the DataSource of the 'Open' statements. -BUT- I am too dim to be able to do it, I have Searched, Read and Struggled for ages - and FAILed so far. -HENCE- My simple plea for simple help from clever folks Thank you Pete (Northolt UK) Anthony Jones wrote: > "p byers" <pb(a)sst-ltd.co.uk> wrote in message > news:48B26545.3B05D32C(a)sst-ltd.co.uk... > > Good Morning Folks > > Whether it is morning depends on a) when the reader reads the message and b) > what timezone they are in. > I read this this morning and I'm UK based to so good morning back. But its > afternoon now, or is it? > > > > > I have a LAN > > Among the several connections to it are the following four devices: > > A MAXSTOR network Storage Device > > A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4) > > A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) > > A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) > > > > All of the PCs are running IIS > > > > The 'Public Internet' is connected via a Broadband connection from the > > LAN > > > > On the MAXSTOR is a folder called 'CENTRALDATA' > > In that folder are a number of Access dotMDB files. > > > > The Access files can be opened on all of the PCs by double clicking on > > them in Windows Explorer. > > > > ================================================================ > > QUESTION ONE > > > > Can the access files on the MAXTOR be accessed from dotASP pages on the > > three PCs ?? > > > > If so, how ?? > > > > If so, are there any simple tutorial pages that explain in simple > > language how to do it ?? > > > > You haven't stated whether you are expecting users to access the site > anonymously or not. > > If all access is to be from users who have domain accounts on your network > then turn off anonymous access on the IIS site and turn on windows > intergrated security. Now grant access for those users to the file share > and folders containing the MDBs as would if the were accessing them via the > file system. > > If you need anonymous access you will need more work. By default IIS > creates an IUSR_<machinename> machine guest account which it used to access > files. This account has not access to the network. Therefore you need to > create a new account in the domain and change the anonymous access on the > IIS to use this new domain account. Grant this account file access as > above. > > > > > > > > > ================================================================ > > I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that > > I own > > > > QUESTION TWO > > > > Can the access files on the "Public Internet Server" be accessed from > > dotASP pages on the three PCs ?? > > > > If so, how ?? > > > > If so, are there any simple tutorial pages that explain in simple > > language how to do it ?? > > > > I guess that depends on what you mean by 'access'. If you mean can you use > JET queries against a copy of an MDB held on a public server I would say > thats probably not a good idea. > > What is it you want to do? Download it? Do you need to upload it as well. > > > > > > > > > ================================================================ > > I have a similar 'CENTRALDATA' folder on a "Public Internet Server" that > > I own > > > > QUESTION THREE > > > > Seems identical to second. > > > > > ================================================================ > > By the way, I tried to create Virtual Folders using IIS Admin on the > > three PCs on the LAN, but it will not allow it for 'Remote' folders. > > > > Creating virtual folders for a UNC path is possible, you must specific a > user name and password that IIS will use to access the folder. That however > would not help with DB queries against MDBs on remote server. > > -- > Anthony Jones - MVP ASP/ASP.NET
From: Bob Milutinovic on 26 Aug 2008 00:24 "p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B2CCAE.92E14D6(a)sst-ltd.co.uk... > > In simple language, I would like several servers running IIS (LAN and > 'Public > Internet') to serve ASPages to be able to use the a Common (the same) > Database - > not individual copies. <snip> There's an oft-abused acronym of "UNC" which'd help you greatly here. Have a read of the URL below; hopefully that'll be enough to set you in the right direction. http://en.wikipedia.org/wiki/Path_(computing)#Uniform_Naming_Convention - Bob.
From: p byers on 26 Aug 2008 02:22 Bob Thank you for your advice. The "Computer Name" of my MAXTOR storage device is: MSS-0135F8 On the PC on which I am testing, it is Mapped as the 'S:' drive I created a tiny test ASPage which is shown below. There are three "dataBaseRoot" values ================================================================ The first is to prove the Script by using a Local Database table - it works OK ================================================================ The second uses the Mapped drive name - it fails as below Error Type: Microsoft JET Database Engine (0x80004005) 's:\atest\ReConstituted_wwwroot\Data\common\data\org_data.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. /test/testshare.asp, line 14 ================================================================ The third is my attempt to use a UNC string - it fails as below Error Type: Microsoft JET Database Engine (0x80004005) '\\MSS-0135F8\atest\ReConstituted_wwwroot\Data\common\data\org_data.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. /test/testshare.asp, line 14 ================================================================ Where do I go next ?? Pete (Northolt UK) <% dataBaseRoot = "c:\inetpub\wwwroot\Data\common\" ''dataBaseRoot = "s:\atest\ReConstituted_wwwroot\Data\common\" ''dataBaseRoot = "\\MSS-0135F8\atest\ReConstituted_wwwroot\Data\common\" DBCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & dataBaseRoot & "data\org_data.mdb" ''Response.Write("<P>" & DBCon) ''Response.end set my_conn = Server.CreateObject("ADODB.Connection") my_Conn.Open DBCon %> Bob Milutinovic wrote: > > There's an oft-abused acronym of "UNC" which'd help you greatly here. > > Have a read of the URL below; hopefully that'll be enough to set you in the > right direction. > > http://en.wikipedia.org/wiki/Path_(computing)#Uniform_Naming_Convention > > - Bob.
|
Next
|
Last
Pages: 1 2 3 4 5 6 Prev: XML document must have a top level element Next: include virtual in virtual directory? |