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

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 trying to open localy instead of off server.
    ... > The shown address is an absolute address on the web server ... > with a connection to the DSN name of the database but access ... >>> 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: 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: 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)
Loading