Re: Accessing files across a network using IIS
From: daniel (daniel_at_discussions.microsoft.com)
Date: 11/22/05
- Next message: sebnunes_at_hotmail.com: "Re: Page Cannot Be Displayed with SSL (not 443port)"
- Previous message: Eduardo T: "Re: Public IP as Relay?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 21 Nov 2005 20:43:02 -0800
Hi Debbie,
I am having a similar problem. I can access files as long as they are in
shared folders in the same computer as iis. but when I move the files to a
different share in another computer I can not 'Find' them!!!
Daniel
"Debbie" wrote:
> The value of "istrConnection" from the include file is as follows:
> istrConnection = "DRIVER=Microsoft Visual FoxPro Driver; SourceDB=" &
> istrDataPath & "Courier Connections.dbc;UID=;SourceType=DBC"
>
> After adding the "Response.Write" code before the "Open" statement, the
> results displayed were as follows:
>
> ************************************************
> DRIVER=Microsoft Visual FoxPro Driver;
> SourceDB=\\asap_nt2\connect\connect\Courier
> Connections.dbc;UID=;SourceType=DBC
> Select distinct Customer.cService, Customer.cName, Customer.cStreet,
> Customer.cSuite, Customer.cCity, Customer.cState, Customer.cZip,
> Customer.cTelephone FROM Customer WHERE Customer.CAccount = '1008'
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
> \\asap_nt2\connect\connect\customer.dbf.
>
> /order2.asp, line 122
> ************************************************
>
> Thanks for your reply - any help/suggestions greatly appreciated!
>
>
>
> "McKirahan" <News@McKirahan.com> wrote in message
> news:SeqdnaKn3ZBZsL_eRVn-rA@comcast.com...
> > "Debbie" <britbitz@hotmail.com> wrote in message
> > news:OcadnfqtJvczY7zeRVn-ow@adelphia.com...
> >> Could someone please point me in the direction of a step-by-step idiot
> > guide
> >> on how to access data files across a network.
> >>
> >> Here is what I want to do:
> >>
> >> I have IIS 5.1 running on my local machine with my web site located
> >> inside
> >> the wwwroot of my inetpub folder. I want to use ASP and ADO to access
> >> Visual FoxPro tables on another machine connected to the network. When I
> >> try to do this I get errors like the one below:
> >>
> >> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >> [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
> >> \\dataserver\mydata\customer.dbf
> >>
> >> The code in my ASP page that generated the above error was as follows:
> >>
> >> '*************************************************************
> >> '** Set up ADODB
> >> '*************************************************************
> >> set objConnect = Server.CreateObject("ADODB.Connection")
> >> objConnect.open istrConnection '** istrConnection value set using
> >> "include" file
> >> set objRec = Server.CreateObject("ADODB.Recordset")
> >>
> >> strSQL = "SELECT distinct Customer.cService, " & _
> >> "Customer.cName, " & _
> >> "Customer.cStreet, " & _
> >> "Customer.cSuite, " & _
> >> "Customer.cCity, " & _
> >> "Customer.cState, " & _
> >> "Customer.cZip, " & _
> >> "Customer.cTelephone " & _
> >> "FROM Customer " & _
> >> "WHERE Customer.CAccount = '" & chrAccount & "' "
> >>
> >> objRec.Open strSQL, objConnect
> >> '*************************************************************
> >>
> >> I have no trouble at all if I put the data folder on the same machine as
> >> IIS, but when I try to access data on another LAN machine I can't.
> >>
> >> Debbie :o(
> >>
> >>
> >
> > '** istrConnection value set using "include" file
> >
> > What is the value of "istrConnection"?
> >
> >
> > Show us the results of this statement placed before the ".Open":
> >
> > Response.Write(istrConnection & "<br>" & strSQL)
> >
> >
>
>
>
- Next message: sebnunes_at_hotmail.com: "Re: Page Cannot Be Displayed with SSL (not 443port)"
- Previous message: Eduardo T: "Re: Public IP as Relay?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
