HELP WITH ERROR PLEASE??

[Aaron]

Hello,

I am having a problem accessing foxpro tables located on
another drive.

Application("ConnectFoxPROD") ="Driver={Microsoft Visual
FoxPro
Driver};SourceType=DBF;SourceDB=E:\Tables\;Exclusi ve=No;Bac
kgroundFetch=No"

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

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

-----------------------------------
NOTE*** If I change the E: to C: and copy the table files
over to my hard drive it works fine, but I need to read
the files on E:

NOTE"" I also had this problem on IIS 5, but with the help
of this link [url]http://support.microsoft.com/?id=175801[/url] I
fixed it. I am currenly tring to use IIS 6 and the same
options for trouble shooting are not there. I have tried
everything I can think of to fix this. PLEASE GIVE ME ANY
IDEAS OR LINKS TO HELP FIX THIS!

Thanks,

[aron]

yes the drive is hitting another server. Again keep in
mind that this same setup works fine on IIS 5.

>-----Original Message-----
>Please use meaningful, non-shouting subject lines for

your own benefit.

>[url]http://www.aspfaq.com/2081[/url]
>
>Is this other drive a network drive?
>
>Ray at work
>
>"Aaron" <abroadway@ameritrust.com> wrote in message
>news:06a001c36d72$38585c00$a001280a@phx.gbl...

>> Hello,
>>
>> I am having a problem accessing foxpro tables located on
>> another drive.
>>
>> Application("ConnectFoxPROD") ="Driver={Microsoft Visual
>> FoxPro
>>

Driver};SourceType=DBF;SourceDB=E:\Tables\;Exclusi ve=No;Bac

>> kgroundFetch=No"
>>
>> ERROR: Microsoft OLE DB Provider for ODBC Drivers
>> error '80040e37'
>>
>> [Microsoft][ODBC Visual FoxPro Driver]File 'und.dbf'

does

>> not exist.
>>
>> -----------------------------------
>> NOTE*** If I change the E: to C: and copy the table

files

>> over to my hard drive it works fine, but I need to read
>> the files on E:
>>
>> NOTE"" I also had this problem on IIS 5, but with the

help

>> of this link [url]http://support.microsoft.com/?id=175801[/url] I
>> fixed it. I am currenly tring to use IIS 6 and the same
>> options for trouble shooting are not there. I have

tried

>> everything I can think of to fix this. PLEASE GIVE ME

ANY

>> IDEAS OR LINKS TO HELP FIX THIS!
>>
>> Thanks,

>
>
>.
>

[Ray at]

IIS will not have a mapping of E to a network drive. You have to use a UNC
path, \\server\share\file.dbf. And you'll have to synch user accounts on
the two machines for permissions or use a domain account as the IUSR.

Ray at work


"aron" <abroadway@ameritrust.com> wrote in message
news:071701c36d75$e0101f20$a001280a@phx.gbl...

> yes the drive is hitting another server. Again keep in
> mind that this same setup works fine on IIS 5.
>
>

> >-----Original Message-----
> >Please use meaningful, non-shouting subject lines for

> your own benefit.

> >[url]http://www.aspfaq.com/2081[/url]
> >
> >Is this other drive a network drive?
> >
> >Ray at work
> >
> >"Aaron" <abroadway@ameritrust.com> wrote in message
> >news:06a001c36d72$38585c00$a001280a@phx.gbl...

> >> Hello,
> >>
> >> I am having a problem accessing foxpro tables located on
> >> another drive.
> >>
> >> Application("ConnectFoxPROD") ="Driver={Microsoft Visual
> >> FoxPro
> >>

> Driver};SourceType=DBF;SourceDB=E:\Tables\;Exclusi ve=No;Bac

> >> kgroundFetch=No"
> >>
> >> ERROR: Microsoft OLE DB Provider for ODBC Drivers
> >> error '80040e37'
> >>
> >> [Microsoft][ODBC Visual FoxPro Driver]File 'und.dbf'

> does

> >> not exist.
> >>
> >> -----------------------------------
> >> NOTE*** If I change the E: to C: and copy the table

> files

> >> over to my hard drive it works fine, but I need to read
> >> the files on E:
> >>
> >> NOTE"" I also had this problem on IIS 5, but with the

> help

> >> of this link [url]http://support.microsoft.com/?id=175801[/url] I
> >> fixed it. I am currenly tring to use IIS 6 and the same
> >> options for trouble shooting are not there. I have

> tried

> >> everything I can think of to fix this. PLEASE GIVE ME

> ANY

> >> IDEAS OR LINKS TO HELP FIX THIS!
> >>
> >> Thanks,

> >
> >
> >.
> >