Re: Query regarding virtual path and physical path

Hmm... I think the issue is with accessing the database somehow and not in
anything Web Server specific. Basically on WinCE we have no idea of
relative paths, so when you open up "Data Source=\Northwind.sdf" it's not
like our file system or Web Server or ASP are doing something clever and
saying "oh, he's running in virtual path \windows\www\DataBase" so I will
append that string to the start of the \Northwind.sdf file.

It should not matter what directory your ASP page is running in.

If you need to do conversions based on virtual root <-> physical path, there
is an ASP function CE implements called Server.MapPath that you may want to
research.

--
John Spaith
Senior Software Design Engineer
Windows CE Networking
Microsoft Corporation

http://blogs.msdn.com/cenet/.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2007 Microsoft Corporation. All rights
reserved.

"kracks" <kirthikaiitm@xxxxxxxxx> wrote in message
news:1189607351.835885.270890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have httpd webserver and once i give <ipaddr> it goes to remote
admin.


I was able to receive the messages once i run dbconnect. asp code in
my webserver. The code just opens connection with sqlserver.

Its showing the message:

Microsoft SQL Server 2000 Windows CE Edition: '80004005'
Description: The database file cannot be found. Check the path to the
database. [,,,File name,,]

I have a doubt whether that error message is because of webserver
running in virtualpath.
I set virtual path in my webserver.

I read in queries that webserver has to run from physical path to
access database.
How to make physical path in webserver.

conn.Open "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;" & _
"Data Source=\Northwind.sdf

This is the code i gave.

Northwind.sdf i just copied from PC to target.

Pls .help.I am just fighting to talk to database from webserver.
Pls. suggest.


Regards,
Kiruthika



.

Relevant Pages

  • 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 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)
  • Move SPS2003 to new web sever
    ... We currently have SPS2003 on two servers, one database, one web. ... move the web server to a new box. ... webserver from the component assignments and stop IIS on the that box. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Re: Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP
    ... read, update, add and delete records located in tables in a MySQL database ... on a Web server on the Internet directly from my desktop Access application, ... the workstation needs a secure shell client running in order to enable the ... the MySQL database on your workstation ...
    (comp.databases.ms-access)