Re: Accessing .mdb data from a remote computer on a non asp application

On Wed, 29 Aug 2007 05:54:35 -0700, Noy B <noybar1@xxxxxxxxx> wrote:

That "Remote server" path is wrong. Check out connectionstrings.com

Note: you cannot connect to an Access db using the HTTP protocol. But
\\server\share\backend.mdb is just fine.

-Tom.


Hi,

I have developed a small application that is using a MSAccess DB.
the problem is that it was developed on a machine where the
application and the DB are both located.
now it needs to be change that the application will be able to run on
any other machine (using \\ syntax on the run command- not a problem)
using the DB located on a static-different machine.

for this purpose I need to create a Remote Connection from my
application to the machine that holdes the DB.

I have searched for code example over the net and the only solution I
have fount which fits to my application is changing the connection
string from:
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\\Cutomers.mdb";
to:
Provider=MS Remote;Remote Server=noa-second;Remote
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Cutomers.mdb;"
("noa-second" is the machine where the MDB file is located)

when I use the second one (with the remote) I get the error: "business
object cannot be created"

adding http:// to the Remote Server sends error "count not connect to
server" what make sense because it is not an asp application (it is a
windows form one).

trying to leave the original connectionstring and change the Source to
\\noa-second\c$...(or c:) doesn't hellp also and shows the error "not
a valid file name" and after looking in the error details I saw that c:
\ have been added to the start of the link I wrote.

Please Help me...

.

Relevant Pages

  • Re: Word looks for another server on the network
    ... and opens an empty document. ... Since the target machine is powered down, the connection cannot be made. ... MacOS eventually gives up and puts up an alert box that says: ... down the remote server numerous times, ...
    (microsoft.public.mac.office.word)
  • Accessing .mdb data from a remote computer on a non asp application
    ... have fount which fits to my application is changing the connection ... ("noa-second" is the machine where the MDB file is located) ... when I use the second one (with the remote) I get the error: ... adding http:// to the Remote Server sends error "count not connect to ...
    (comp.databases.ms-access)
  • Re: 550 5.7.1 Error
    ... The allow computers that successfully authenticate box is already checked. ... >> cause the connection to fail. ... >> I have also tried telnetting to the remote server, and when I do I get ... >> ie not in any of the scanned blocklists, ...
    (microsoft.public.exchange.admin)
  • Re: How does authentication work?
    ... The problem is that when the remote server times out the connection and ... The problem is in the connection ever timing out in the first place. ... re-map one of the drives it would tell us it was not able to as the drive ... drives were mapped with the domain account and the credentials not cached ...
    (microsoft.public.windows.server.general)
  • Re: Using an IP from remote server on home computer
    ... > connection. ... > ports (does not require root access on remote server). ... > tried ssh port forwarding with a Windows ssh client like Putty. ...
    (comp.os.linux.networking)