ASP access to Data on Remote devices
in [ASP]
|
From: p byers on 28 Aug 2008 03:27 Hi Chris Hohmann and Bob Milutinovic gave me two replies that I read carefully and tried to take on board. They had both suggestions and questions. I did my level best to try their suggestions and answer their questions. I put it all in one reply to try and establish one path of trials. ================================================================ Anthony Jones and Bob Barrows both kindly contributed with comments and suggestions. My replies and comments to both are here. Anthony said ********* "Dunno what that is. A better test would be to knock up some VBScript in VBS file that simulates the sort of ADO querying you would be doing from ASP." I will do that - the reason there are two reasons that I did not do it already 1. I expected that I would be told that this is the wrong group - AND - it is ASP that I want the things to wok in. 2. I have experience in the past that the content in VBS does not always work when transfered to ASP ********* "When you created the S: mapping did you enter any user credentials that are needed gain access to the share?" No - found the Folder (cannot remember if it was in 'Search' or 'Network Places') - then RightClick - DropDown - Clicked on MapPath ********* "What does this mean? Your assigning a string into a variable but what do you do with it?" In the Original Post, there was a copy of the ASPage, I inserted the line in to that file. ********* "What is 'the "Z:" share"? What is the UNC equivalent?" In the Original Post I listed four devices on the Network - the "Z:" share is the Windows 2000 Server. The test was done in response to the thought that it could all work OK if I used a PC rather than the MAXTOR device. ********* "That isn't surprising since so far you haven't got the UNC path working even in an interactive session and S: will not be available in IIS." I understand that - that is the whole basis of my problem - lol ********* "Sounds like there is a problem resolving the name mss-0145F8? What protocols are you running (OTW are you running NBT over TCP/IP or just straight TCP/IP). Try pinging mss-0145F8 I bet that doesn't work. Is mss-0145F8 actually the Computer name the domain knows the device as. Your other post appear to refer to it as MAXTOR." Please look at http://www.byershostingpeter.co.uk/test/images-1.htm there are three images tha I think may be relevant. I do not know what protocols I am running, BUT, I will find out !! Thank you Anthony Bob said ********* "Is this MAXTOR thing a removable drive? In my experience, mapped drives do not work with IIS. you need to use the unc path." The MAXTOR thing is a Network Attached Storage device - 192.168.1.110 I have never got Mapped Drives to work with IIS This is my first aquaintance with UNC paths - BUT - I am doing my best to learn - lol ********* "This is not really relevant. just because this drive is visible to your user account does not mean that it is visible to the account under which ASP is running." I understand that - it was done in response to a comment from 'Chris and the other Bob' - I am trying to cover all bases and give all the info to the kind, clever folks that are trying to help me !! ********* "Permissions. The account IIS is running under needs permissions to both the pbyers share and the folder the share is referring to." I understand that - sadly, I am not very knowledgeable about the subject of Permissions (so far, I have got away with plugging devices into a network and praying - lol) As mentioned in a previous post, I am furiously trying to learn and get up to speed on the subject of Active Directory and Domains. In years I am ancient - technologically, I am a Babe-in-Arms, but I am working hard to learn - once I know, I wont forget !! ********* "Again ... irrelevant" I did this simple to prove to myself that I was not being caught out by any typos !! ********* "Then you have the wrong path. This needs to be correct before you attempt to use it." That is something I know - I wish I could get the correct ones - with help from the clever folks in here, I hope and expect to get there !! ********* Thank you Bob
From: Anthony Jones on 28 Aug 2008 04:52 "p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B6534C.4EECC7F(a)sst-ltd.co.uk... > Hi > > Chris Hohmann and Bob Milutinovic gave me two replies that I read carefully and > tried to take on board. > > They had both suggestions and questions. > > I did my level best to try their suggestions and answer their questions. > > I put it all in one reply to try and establish one path of trials. > > ================================================================ > > Anthony Jones and Bob Barrows both kindly contributed with comments and suggestions. > > My replies and comments to both are here. > > > Anthony said > > ********* > > "Dunno what that is. A better test would be to knock up some VBScript in VBS file > that simulates the sort of ADO querying you would be doing from ASP." > > I will do that - the reason there are two reasons that I did not do it already > > 1. I expected that I would be told that this is the wrong group Yes it can be off putting when people are more interested in netiquette then simpy being a community of people with knowledge spanning likely common areas > - AND - > it is ASP that I want the things to wok in. > > 2. I have experience in the past that the content in VBS does not always work when > transfered to ASP > True, but its a useful diagnositic tool to know whether the same code runs in VBS or not. If it does then its likely a user rights permission problem, if doesn't then there is something else wrong. > ********* > > "When you created the S: mapping did you enter any user credentials that are needed > gain access to the share?" > > No - found the Folder (cannot remember if it was in 'Search' or 'Network Places') - > then RightClick - DropDown - Clicked on MapPath > K that means either the current user has permissions or the share has no restrictions. > ********* > > "What does this mean? Your assigning a string into a variable but what do you do > with it?" > > In the Original Post, there was a copy of the ASPage, I inserted the line in to that > file. > > ********* > > "What is 'the "Z:" share"? What is the UNC equivalent?" > > In the Original Post I listed four devices on the Network - the "Z:" share is the > Windows 2000 Server. > > The test was done in response to the thought that it could all work OK if I used a > PC rather than the MAXTOR device. > > ********* > > "That isn't surprising since so far you haven't got the UNC path working even in an > interactive session and S: will not be available in IIS." > > I understand that - that is the whole basis of my problem - lol > > ********* > > "Sounds like there is a problem resolving the name mss-0145F8? What protocols are > you running (OTW are you running NBT over TCP/IP or just straight TCP/IP). > > Try pinging mss-0145F8 I bet that doesn't work. Is mss-0145F8 actually the > Computer name the domain knows the device as. Your other post appear to refer to it > as MAXTOR." > > Please look at http://www.byershostingpeter.co.uk/test/images-1.htm there are three > images tha I think may be relevant. > > I do not know what protocols I am running, BUT, I will find out !! > The ping results shows your fundemental problem. The name mss-0145F8 can not be resolved to an IP address. Ordinarily in a TCP/IP Windows network running the old NetBT protocol the 2000 server would be nominated as a name server. I suspect that this isn't working on your network because either it isn't running NetBT or the NAS doesn't support it. My advice for such a small network would be to edit the hosts file (you will need to do this on each machine) In notepad open C:\Windows\System32\drivers\etc\hosts file (note the hosts file has no file extension). Add an entry:- 192.168.1.110 MSS-01345F8 to the file and save. Try the ping If that works try using the UNC path in Windows Explorer If that works try a sample of your code in a VBS file If that works try your ASP again if that fails re-read my comments on configuring the anonymous user on a web app. -- Anthony Jones - MVP ASP/ASP.NET
From: p byers on 28 Aug 2008 05:01 Anthony Thank you, I will try the things that you suggest. Pete (Northolt UK) Anthony Jones wrote: > "p byers" <pb(a)sst-ltd.co.uk> wrote in message > news:48B6534C.4EECC7F(a)sst-ltd.co.uk... > > Hi > > > > Chris Hohmann and Bob Milutinovic gave me two replies that I read > carefully and > > tried to take on board. > > > > They had both suggestions and questions. > > > > I did my level best to try their suggestions and answer their questions. > > > > I put it all in one reply to try and establish one path of trials. > > > > ================================================================ > > > > Anthony Jones and Bob Barrows both kindly contributed with comments and > suggestions. > > > > My replies and comments to both are here. > > > > > > Anthony said > > > > ********* > > > > "Dunno what that is. A better test would be to knock up some VBScript in > VBS file > > that simulates the sort of ADO querying you would be doing from ASP." > > > > I will do that - the reason there are two reasons that I did not do it > already > > > > 1. I expected that I would be told that this is the wrong group > > Yes it can be off putting when people are more interested in netiquette then > simpy being a community of people with knowledge spanning likely common > areas > > > - AND - > > it is ASP that I want the things to wok in. > > > > 2. I have experience in the past that the content in VBS does not always > work when > > transfered to ASP > > > > True, but its a useful diagnositic tool to know whether the same code runs > in VBS or not. If it does then its likely a user rights permission problem, > if doesn't then there is something else wrong. > > > ********* > > > > "When you created the S: mapping did you enter any user credentials that > are needed > > gain access to the share?" > > > > No - found the Folder (cannot remember if it was in 'Search' or 'Network > Places') - > > then RightClick - DropDown - Clicked on MapPath > > > > K that means either the current user has permissions or the share has no > restrictions. > > > ********* > > > > "What does this mean? Your assigning a string into a variable but what > do you do > > with it?" > > > > In the Original Post, there was a copy of the ASPage, I inserted the line > in to that > > file. > > > > ********* > > > > "What is 'the "Z:" share"? What is the UNC equivalent?" > > > > In the Original Post I listed four devices on the Network - the "Z:" share > is the > > Windows 2000 Server. > > > > The test was done in response to the thought that it could all work OK if > I used a > > PC rather than the MAXTOR device. > > > > ********* > > > > "That isn't surprising since so far you haven't got the UNC path working > even in an > > interactive session and S: will not be available in IIS." > > > > I understand that - that is the whole basis of my problem - lol > > > > ********* > > > > "Sounds like there is a problem resolving the name mss-0145F8? What > protocols are > > you running (OTW are you running NBT over TCP/IP or just straight TCP/IP). > > > > Try pinging mss-0145F8 I bet that doesn't work. Is mss-0145F8 actually > the > > Computer name the domain knows the device as. Your other post appear to > refer to it > > as MAXTOR." > > > > Please look at http://www.byershostingpeter.co.uk/test/images-1.htm there > are three > > images tha I think may be relevant. > > > > I do not know what protocols I am running, BUT, I will find out !! > > > > The ping results shows your fundemental problem. The name mss-0145F8 can > not be resolved to an IP address. > > Ordinarily in a TCP/IP Windows network running the old NetBT protocol the > 2000 server would be nominated as a name server. I suspect that this isn't > working on your network because either it isn't running NetBT or the NAS > doesn't support it. > > My advice for such a small network would be to edit the hosts file (you will > need to do this on each machine) > > In notepad open C:\Windows\System32\drivers\etc\hosts file (note the hosts > file has no file extension). > > Add an entry:- > > 192.168.1.110 MSS-01345F8 > > to the file and save. > > Try the ping > > If that works > > try using the UNC path in Windows Explorer > > If that works > > try a sample of your code in a VBS file > > If that works > > try your ASP again > > if that fails re-read my comments on configuring the anonymous user on a web > app. > > -- > Anthony Jones - MVP ASP/ASP.NET
From: p byers on 28 Aug 2008 05:27 Anthony Added the line to the 'hosts' file The 'ping' did work OK as you expected. Created VBS file shown below. Tried it with the database on the 'C:' drive just to prove the script It Worhed OK Tried it with the UNC file source. It failed - Error message shown below Pete (Northolt UK) ************* The VBS file ********************************* ''dataBaseRoot = "c:\inetpub\wwwroot\Data\common\" ''dataBaseRoot = "s:\atest\ReConstituted_wwwroot\Data\common\" ''dataBaseRoot = "z:\wwwroot\Data\mailing\" dataBaseRoot = "\\MSS-0135F8\pbyers\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 = CreateObject("ADODB.Connection") my_Conn.Open DBCon WScript.Echo "Worked OK" *********** The Error Message **************************** --------------------------- Windows Script Host --------------------------- Script: C:\Inetpub\wwwroot\test\testshare.vbs Line: 16 Char: 1 Error: '\\MSS-0135F8\pbyers\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. Code: 80004005 Source: Microsoft JET Database Engine --------------------------- OK --------------------------- Anthony Jones wrote: > "p byers" <pb(a)sst-ltd.co.uk> wrote in message > news:48B6534C.4EECC7F(a)sst-ltd.co.uk... > > Hi > > > > Chris Hohmann and Bob Milutinovic gave me two replies that I read > carefully and > > tried to take on board. > > > > They had both suggestions and questions. > > > > I did my level best to try their suggestions and answer their questions. > > > > I put it all in one reply to try and establish one path of trials. > > > > ================================================================ > > > > Anthony Jones and Bob Barrows both kindly contributed with comments and > suggestions. > > > > My replies and comments to both are here. > > > > > > Anthony said > > > > ********* > > > > "Dunno what that is. A better test would be to knock up some VBScript in > VBS file > > that simulates the sort of ADO querying you would be doing from ASP." > > > > I will do that - the reason there are two reasons that I did not do it > already > > > > 1. I expected that I would be told that this is the wrong group > > Yes it can be off putting when people are more interested in netiquette then > simpy being a community of people with knowledge spanning likely common > areas > > > - AND - > > it is ASP that I want the things to wok in. > > > > 2. I have experience in the past that the content in VBS does not always > work when > > transfered to ASP > > > > True, but its a useful diagnositic tool to know whether the same code runs > in VBS or not. If it does then its likely a user rights permission problem, > if doesn't then there is something else wrong. > > > ********* > > > > "When you created the S: mapping did you enter any user credentials that > are needed > > gain access to the share?" > > > > No - found the Folder (cannot remember if it was in 'Search' or 'Network > Places') - > > then RightClick - DropDown - Clicked on MapPath > > > > K that means either the current user has permissions or the share has no > restrictions. > > > ********* > > > > "What does this mean? Your assigning a string into a variable but what > do you do > > with it?" > > > > In the Original Post, there was a copy of the ASPage, I inserted the line > in to that > > file. > > > > ********* > > > > "What is 'the "Z:" share"? What is the UNC equivalent?" > > > > In the Original Post I listed four devices on the Network - the "Z:" share > is the > > Windows 2000 Server. > > > > The test was done in response to the thought that it could all work OK if > I used a > > PC rather than the MAXTOR device. > > > > ********* > > > > "That isn't surprising since so far you haven't got the UNC path working > even in an > > interactive session and S: will not be available in IIS." > > > > I understand that - that is the whole basis of my problem - lol > > > > ********* > > > > "Sounds like there is a problem resolving the name mss-0145F8? What > protocols are > > you running (OTW are you running NBT over TCP/IP or just straight TCP/IP). > > > > Try pinging mss-0145F8 I bet that doesn't work. Is mss-0145F8 actually > the > > Computer name the domain knows the device as. Your other post appear to > refer to it > > as MAXTOR." > > > > Please look at http://www.byershostingpeter.co.uk/test/images-1.htm there > are three > > images tha I think may be relevant. > > > > I do not know what protocols I am running, BUT, I will find out !! > > > > The ping results shows your fundemental problem. The name mss-0145F8 can > not be resolved to an IP address. > > Ordinarily in a TCP/IP Windows network running the old NetBT protocol the > 2000 server would be nominated as a name server. I suspect that this isn't > working on your network because either it isn't running NetBT or the NAS > doesn't support it. > > My advice for such a small network would be to edit the hosts file (you will > need to do this on each machine) > > In notepad open C:\Windows\System32\drivers\etc\hosts file (note the hosts > file has no file extension). > > Add an entry:- > > 192.168.1.110 MSS-01345F8 > > to the file and save. > > Try the ping > > If that works > > try using the UNC path in Windows Explorer > > If that works > > try a sample of your code in a VBS file > > If that works > > try your ASP again > > if that fails re-read my comments on configuring the anonymous user on a web > app. > > -- > Anthony Jones - MVP ASP/ASP.NET
From: Anthony Jones on 28 Aug 2008 06:18
"p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B66F84.898EE3E1(a)sst-ltd.co.uk... > Anthony > > Added the line to the 'hosts' file > > The 'ping' did work OK as you expected. > > Created VBS file shown below. > > Tried it with the database on the 'C:' drive just to prove the script > It Worhed OK > > Tried it with the UNC file source. > It failed - Error message shown below > > Pete (Northolt UK) > > > > ************* The VBS file ********************************* > > ''dataBaseRoot = "c:\inetpub\wwwroot\Data\common\" > > ''dataBaseRoot = "s:\atest\ReConstituted_wwwroot\Data\common\" > > ''dataBaseRoot = "z:\wwwroot\Data\mailing\" > > dataBaseRoot = "\\MSS-0135F8\pbyers\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 = CreateObject("ADODB.Connection") > my_Conn.Open DBCon > > WScript.Echo "Worked OK" > > > *********** The Error Message **************************** > > --------------------------- > Windows Script Host > --------------------------- > Script: C:\Inetpub\wwwroot\test\testshare.vbs > Line: 16 > Char: 1 > Error: > '\\MSS-0135F8\pbyers\atest\ReConstituted_wwwroot\Data\common\data\org_data.m db' > 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. > Code: 80004005 > Source: Microsoft JET Database Engine > > --------------------------- > OK > --------------------------- > Did you do the windows explorer test? -- Anthony Jones - MVP ASP/ASP.NET |