Re: database trying to open localy instead of off server.

Change the reference to:
\\yourservername\webs\dbtest\fpdb\database.mdb

"Lash" <newsreader@xxxxxxxxxxx> wrote in message
news:Zo09e.16311$5F3.2241@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thank you Pat for your help,
>
> The shown address is an absolute address on the web server
>
> However the page looks for a local D: drive instead of using
>
> The D: drive on the server.
>
> I can see that Front Page will insert database components
>
> with a connection to the DSN name of the database but access
>
> builds the connection string shown.
>
> Can I tell the page to use the DSN connection?
>
>
>
> "Pat Hartman" <patsky@xxxxxxxxxxxxx> wrote in message
> news:%23pPU3NFRFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
>
> > "d:\webs\dbtest\fpdb\database.mdb" needs to be the address of the db on
> > the
> > web server. I think you probably have to use UNC notation rather than a
> > drive letter.
> >
> > "Lash" <newsreader@xxxxxxxxxxx> wrote in message
> > news:%US8e.15868$5F3.3809@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> >> I have placed my database onto my webserver and opened the data access
> > pages
> >> in my browser
> >> but all the pages are trying to open the database on my local computer.
> >> How can I tell this connection string to look on my webserver for the
> >> database.
> >>
> >> <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;
> >> Data source=d:\webs\dbtest\fpdb\database.mdb
> >>
> >> thankyou
> >>
> >> Lash
> >> news@xxxxxxxxxxx
> >>
> >>
> >
> >
>
>


.

Relevant Pages

  • Re: Query regarding virtual path and physical path
    ... anything Web Server specific. ... I have httpd webserver and once i give it goes to remote ... The database file cannot be found. ... I set virtual path in my webserver. ...
    (microsoft.public.windowsce.embedded)
  • Re: Database Location On the Web
    ... you must modify the connection string so that it will point at ... the correct location or your database on the web server but I cannot tell ... > was download a temp copy of the database to my local HD C, ... >> your local web server than on the real server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: database trying to open localy instead of off server.
    ... The shown address is an absolute address on the web server ... I can see that Front Page will insert database components ... >> I have placed my database onto my webserver and opened the data access ... >> How can I tell this connection string to look on my webserver for the ...
    (microsoft.public.access.gettingstarted)
  • Re: Accessing Foxpro tables from ADO
    ... somehow the index file is set to read only access for the web server account ... If the database resides on a network share FROM the webserver, ... Set coni = Server.CreateObject ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Is it a mistake to put passwords in an .asmx.cs file on the web server?
    ... >I'm building a web service which connects to a database. ... >hardcoded the connection string in the web service source code (an ... is it a bad idea to leave .asmx.cs files on the web server? ...
    (microsoft.public.dotnet.framework.aspnet)