Drag and Drop MS Access Database on Remote Server?

• Previous message: Alfred Sehmueller: "Re: Help lost my com/interop debugging settings!"
• Messages sorted by: [ date ] [ thread ]

Date: Tue, 6 Apr 2004 12:03:36 -0600

I have a sample ASP.NET datagrid demonstration that works fine on my
notebook. Of course, it was created with Visual Studio 2003.

The project has been copied to a commercial hosting service's remote server.
Of course it did not work because the absoute path for the connection string
for the Access database was different on my notebook than on the remote
server.

So, I inserted some code to fetch the script_name, remove the file name from
the script name and append the name of the Access Database. Then I send this
thru mappath. This technique worked fine on a second hosting service.

However, on this first hosting service, I get "The Microsoft Jet database
engin cannot open the file
C:\Inetpub\websites\evidence\stage\htdocs\demo_grid_asp.net\test_pce.mdb' It
is already opened exclusively by another user, or you need permissing to
view its data.

Wierd!

This the connection string generated by Visual Studio! Hmmm.... Who else
could have it open?

I decided to try to remedy the problem by using VS.NET 2003 to connect to
the remote project, deleting the existing connection object, and dragging
the remote Access MDB file onto the remote web page. Unfortunately, VS.NET
2003 does not enumerate the remote files! It only enumerates the files on my
local machine. How do I tell VS.NET that I want to drag a remote file?

  Thanks,
   Siegfried

• Previous message: Alfred Sehmueller: "Re: Help lost my com/interop debugging settings!"
• Messages sorted by: [ date ] [ thread ]