K i got this prob :

Im building an app that will read from a foxpro dbf , find out if the table
is empty and if it is it will be overwritten with a blank one (using
filesystemobject)

My prob is this,

On my local pc all goes well , when i upload it to the server i get a file
does not exist error , both the server and my pc have exactly the same
folder tree and the same files ( ive checked it over 100 times now ) but the
error still persists.

I have a folder called DirEscrita in wich i have put the dbf file to scan
for data , and i get this error when trying to do a simple select on it:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Visual FoxPro Driver]File 'trf.dbf' does not exist.

/exporta.asp, line 12

I know that it cant be a prob with the code , cause it works fine locally
( im on a XP PRO IIS 5.1) , could it be the server? ( IIS 5.0 )

This is most likely a permissions issue. Does your IUSR account have NTFS
read/write permissions to this file?

--

Ray at home
Microsoft ASP MVP


"Nuno Caldas" <nunocaldas@iol.pt> wrote in message
news:4021a09e$0$16840$a729d347@news.telepac.pt...[color=blue]
> K i got this prob :
>
> Im building an app that will read from a foxpro dbf , find out if the[/color]
table[color=blue]
> is empty and if it is it will be overwritten with a blank one (using
> filesystemobject)
>
> My prob is this,
>
> On my local pc all goes well , when i upload it to the server i get a[/color]
file[color=blue]
> does not exist error , both the server and my pc have exactly the same
> folder tree and the same files ( ive checked it over 100 times now ) but[/color]
the[color=blue]
> error still persists.
>
> I have a folder called DirEscrita in wich i have put the dbf file to scan
> for data , and i get this error when trying to do a simple select on it:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
>
> [Microsoft][ODBC Visual FoxPro Driver]File 'trf.dbf' does not exist.
>
> /exporta.asp, line 12
>
> I know that it cant be a prob with the code , cause it works fine locally
> ( im on a XP PRO IIS 5.1) , could it be the server? ( IIS 5.0 )
>
>
>
>[/color]