I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename from
several fields in a jet database using SQL commands, like this:
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs"
RS.open Sql
RS.movefirst
do while not RS.EOF
temp1=trim(RS("rootname"))
temp2=trim(RS("dirname"))
path1=Server.MapPath(temp1 & "\" & temp2) & "\pics.ini"
When I try to open the file I get this file not found error (0x800A0035).
However, if explicitly specify the path and filename (as in path2 below)
then it works. If I use path1 then it does not work. path2 was taken by
printing path1 to the browser window and then cutandpaste into my code.
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs"
RS.open Sql
RS.movefirst
do while not RS.EOF
temp1=trim(RS("rootname"))
temp2=trim(RS("dirname"))
path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini")
path2="C:\Inetpub\wwwroot\Tim & Janies Family Web Page\2003\pics.ini
' at this point path1=path2, this can be tested and proven
set fs=Server.CreateObject("Scripting.FileSystemObject ")
set f=fs.OpenTextFile(path2,1)
Why does the path/filename string built using the database not work but an
apparently IDENTICAL string which is explicitly typed in DOES work? I am
certain that this data is correct and it is not just a problem of me doing
something stupid.
Help?
TimS 5 4565
Surely it should be.........
path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini")
--
Regards
Steven Burn
Ur I.T. Mate Group www.it-mate.co.uk
Keeping it FREE!
Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
TimS <ti********@comcast.net> wrote in message
news:ek**************@TK2MSFTNGP09.phx.gbl... I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename
from several fields in a jet database using SQL commands, like this:
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2) & "\pics.ini"
When I try to open the file I get this file not found error (0x800A0035). However, if explicitly specify the path and filename (as in path2 below) then it works. If I use path1 then it does not work. path2 was taken by printing path1 to the browser window and then cutandpaste into my code.
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini") path2="C:\Inetpub\wwwroot\Tim & Janies Family Web Page\2003\pics.ini ' at this point path1=path2, this can be tested and proven set fs=Server.CreateObject("Scripting.FileSystemObject ") set f=fs.OpenTextFile(path2,1)
Why does the path/filename string built using the database not work but an apparently IDENTICAL string which is explicitly typed in DOES work? I am certain that this data is correct and it is not just a problem of me doing something stupid.
Help?
TimS
Steven,
Re: your comment - the resulting path/filename variable is the same whether
the filename is inside or outside of the MapPath function.
This is a problem which is not going to resolve from a syntax correction.
All the relevent factors are contained in this paragraph. Basically, you
have two variables, path1 and path2. If you test them, path1=path2 is TRUE.
path1 was created using the code illustrated below. path2 was created by
printing path1 to the screen and then cut/pasting the path/filename string
into my code. path1 and path2 appear to be identical. However, path1 gives
a file not found error and path2 works, as shown in the code below.
If you don't already know the answer, I wager you will not be able to figure
it out. I am hoping someone already knows the answer :-) ....please!
TimS
"Steven Burn" <nobody@PVT_it-mate.co.uk> wrote in message
news:eW**************@TK2MSFTNGP12.phx.gbl... Surely it should be.........
path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini")
-- Regards
Steven Burn Ur I.T. Mate Group www.it-mate.co.uk
Keeping it FREE!
Disclaimer: I know I'm probably wrong, I just like taking part ;o)
TimS <ti********@comcast.net> wrote in message news:ek**************@TK2MSFTNGP09.phx.gbl... I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename from several fields in a jet database using SQL commands, like this:
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2) & "\pics.ini"
When I try to open the file I get this file not found error
(0x800A0035). However, if explicitly specify the path and filename (as in path2 below) then it works. If I use path1 then it does not work. path2 was taken
by printing path1 to the browser window and then cutandpaste into my code.
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini") path2="C:\Inetpub\wwwroot\Tim & Janies Family Web Page\2003\pics.ini ' at this point path1=path2, this can be tested and proven set fs=Server.CreateObject("Scripting.FileSystemObject ") set f=fs.OpenTextFile(path2,1)
Why does the path/filename string built using the database not work but
an apparently IDENTICAL string which is explicitly typed in DOES work? I am certain that this data is correct and it is not just a problem of me
doing something stupid.
Help?
TimS
Why don't you just do a Response.Write on the path thats not working and see
what it actually contains?
--
Regards
Steven Burn
Ur I.T. Mate Group www.it-mate.co.uk
Keeping it FREE!
Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
TimS <ti********@comcast.net> wrote in message
news:O4**************@TK2MSFTNGP10.phx.gbl... Steven,
Re: your comment - the resulting path/filename variable is the same
whether the filename is inside or outside of the MapPath function.
This is a problem which is not going to resolve from a syntax correction. All the relevent factors are contained in this paragraph. Basically, you have two variables, path1 and path2. If you test them, path1=path2 is
TRUE. path1 was created using the code illustrated below. path2 was created by printing path1 to the screen and then cut/pasting the path/filename string into my code. path1 and path2 appear to be identical. However, path1
gives a file not found error and path2 works, as shown in the code below.
If you don't already know the answer, I wager you will not be able to
figure it out. I am hoping someone already knows the answer :-) ....please!
TimS
"Steven Burn" <nobody@PVT_it-mate.co.uk> wrote in message news:eW**************@TK2MSFTNGP12.phx.gbl... Surely it should be.........
path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini")
-- Regards
Steven Burn Ur I.T. Mate Group www.it-mate.co.uk
Keeping it FREE!
Disclaimer: I know I'm probably wrong, I just like taking part ;o)
TimS <ti********@comcast.net> wrote in message news:ek**************@TK2MSFTNGP09.phx.gbl... I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename from several fields in a jet database using SQL commands, like this:
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2) & "\pics.ini"
When I try to open the file I get this file not found error (0x800A0035). However, if explicitly specify the path and filename (as in path2
below) then it works. If I use path1 then it does not work. path2 was taken by printing path1 to the browser window and then cutandpaste into my
code. Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini") path2="C:\Inetpub\wwwroot\Tim & Janies Family Web Page\2003\pics.ini ' at this point path1=path2, this can be tested and proven set fs=Server.CreateObject("Scripting.FileSystemObject ") set f=fs.OpenTextFile(path2,1)
Why does the path/filename string built using the database not work
but an apparently IDENTICAL string which is explicitly typed in DOES work? I
am certain that this data is correct and it is not just a problem of me
doing something stupid.
Help?
TimS
TimS wrote: I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename from several fields in a jet database using SQL commands, like this:
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2) & "\pics.ini"
When I try to open the file I get this file not found error (0x800A0035). However, if explicitly specify the path and filename (as in path2 below) then it works. If I use path1 then it does not work. path2 was taken by printing path1 to the browser window and then cutandpaste into my code.
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini") path2="C:\Inetpub\wwwroot\Tim & Janies Family Web Page\2003\pics.ini ' at this point path1=path2, this can be tested and proven
How?
set fs=Server.CreateObject("Scripting.FileSystemObject ") set f=fs.OpenTextFile(path2,1)
Why does the path/filename string built using the database not work but an apparently IDENTICAL string which is explicitly typed in DOES work?
Have you done a
Response.Write path1 & "<BR>" & path2
to make sure that they are identical?
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
On Thu, 25 Dec 2003 18:06:17 -0800, "TimS" <ti********@comcast.net>
wrote: I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename from several fields in a jet database using SQL commands, like this:
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2) & "\pics.ini"
When I try to open the file I get this file not found error (0x800A0035). However, if explicitly specify the path and filename (as in path2 below) then it works. If I use path1 then it does not work. path2 was taken by printing path1 to the browser window and then cutandpaste into my code.
Sql = "SELECT dirs.rootname,dirs.dirname FROM dirs" RS.open Sql RS.movefirst do while not RS.EOF temp1=trim(RS("rootname")) temp2=trim(RS("dirname")) path1=Server.MapPath(temp1 & "\" & temp2 & "\pics.ini") path2="C:\Inetpub\wwwroot\Tim & Janies Family Web Page\2003\pics.ini ' at this point path1=path2, this can be tested and proven set fs=Server.CreateObject("Scripting.FileSystemObject ") set f=fs.OpenTextFile(path2,1)
Why does the path/filename string built using the database not work but an apparently IDENTICAL string which is explicitly typed in DOES work? I am certain that this data is correct and it is not just a problem of me doing something stupid.
We're not that certain, you'll have to prove it. Post a
Response.Write of Path1...
Jeff This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Hans-Joachim Widmaier |
last post by:
Hi all.
Handling files is an extremely frequent task in programming, so most
programming languages have an abstraction of the basic files offered by
the underlying operating system. This is...
|
by: Pedro Carvalho |
last post by:
I am using a WebClient.Upload File method (using the HTTP POST) on the
Client side and, to accept posted files on the Server side, I am using an
ASP.NET page with the following code:
void...
|
by: Omid |
last post by:
Hi.
I have problems when I try to redirect everything that is sent to cout
to a file.
I have one piece of code that works and one that does not work.
The only difference is which headers I use....
|
by: Mike |
last post by:
I have posted this before, but no one responds, so here
it goes again. I think my question is intimidating people
and I have no idea why?!? This is not a new concept. You
can do this with other...
|
by: Mike Collins |
last post by:
I am trying to export data from multiple tables in SQL Server to an XML file
so I can then import it to another database. It seems to be working fine for
exporting, but I am having trouble...
|
by: JimmyKoolPantz |
last post by:
IDE: Visual Studio 2005
Language: VB.NET
Fox Pro Driver Version: 9.0.0.3504
Problem: I currently have a problem altering a DBF file. I do not get
any syntax errors when running the program. ...
|
by: Holly |
last post by:
We have a new server that runs 2003 and framework 2.0.50727. I put a simple
asp.net application(one button on the default.aspx page) under wwwroot. from
IIS manager, I can see the application...
|
by: shapper |
last post by:
Hello,
Could someone tell me how to convert a XML file into another XML file
using a XSL file with a parameter? I created the code to do it, and it
seems ok, but it is not working.
Could...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |