473,380 Members | 1,279 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,380 software developers and data experts.

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

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...

Aug 29 '07 #1
4 4189
On Wed, 29 Aug 2007 05:54:35 -0700, Noy B <no*****@gmail.comwrote:

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...
Aug 29 '07 #2
On Aug 29, 4:54 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 29 Aug 2007 05:54:35 -0700, Noy B <noyb...@gmail.comwrote:

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...- Hide quoted text -

- Show quoted text -

\\server\share\backend.mdb have throws me the error not a valid file
name. for some reason it is adding "c:\\" at the begining. have you
faced this problem befaure?

about the site connectionstring.com I couldn't find anything wrong
with my Remote Server. is there any thing you can point out?

Thanks!

Aug 29 '07 #3
Is your "remote server" on your LAN? If not, where is it?

Maybe Tom was too gentle, or too restrictive, when he said can't use
http://protocol ...

Open your database in Design View, and from the Database Window, Tools |
Database Utilities | Linked Table Manager. If you can't browse and find the
shared folder and file, you can't link the Tables; if you can, Bob's your
uncle, as they say back in the British Isles. Accessing databases via the
Internet to link Tables is NOT supported.

In the vast majority of cases, accessing a split database even via a WAN is
'way too slow. A client application to tables in server DBs across a WAN
will usually work nicely, because of the difference in the way Server and
File-Server databases process data.

Larry Linson
Microsoft Access MVP
"Noy B" <no*****@gmail.comwrote in message
news:11**********************@50g2000hsm.googlegro ups.com...
On Aug 29, 4:54 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On Wed, 29 Aug 2007 05:54:35 -0700, Noy B <noyb...@gmail.comwrote:

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...- Hide quoted text -

- Show quoted text -


\\server\share\backend.mdb have throws me the error not a valid file
name. for some reason it is adding "c:\\" at the begining. have you
faced this problem befaure?

about the site connectionstring.com I couldn't find anything wrong
with my Remote Server. is there any thing you can point out?

Thanks!

Aug 30 '07 #4
On Aug 30, 6:21 am, "Larry Linson" <boun...@localhost.notwrote:
Is your "remote server" on your LAN? If not, where is it?

Maybe Tom was too gentle, or too restrictive, when he said can't usehttp://protocol...

Open your database in Design View, and from the Database Window, Tools |
Database Utilities | Linked Table Manager. If you can't browse and find the
shared folder and file, you can't link the Tables; if you can, Bob's your
uncle, as they say back in the British Isles. Accessing databases via the
Internet to link Tables is NOT supported.

In the vast majority of cases, accessing a split database even via a WAN is
'way too slow. A client application to tables in server DBs across a WAN
will usually work nicely, because of the difference in the way Server and
File-Server databases process data.

Larry Linson
Microsoft Access MVP

"Noy B" <noyb...@gmail.comwrote in message

news:11**********************@50g2000hsm.googlegro ups.com...
On Aug 29, 4:54 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 29 Aug 2007 05:54:35 -0700, Noy B <noyb...@gmail.comwrote:
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...- Hide quoted text -
- Show quoted text -
\\server\share\backend.mdb have throws me the error not a valid file
name. for some reason it is adding "c:\\" at the begining. have you
faced this problem befaure?
about the site connectionstring.com I couldn't find anything wrong
with my Remote Server. is there any thing you can point out?
Thanks!- Hide quoted text -

- Show quoted text -
Thanks for you'r answer.
all machines involved in this process are on the same network.
Now, the application is been "programmed" on the same machine the .mdb
is placed on. therefor, the first problem is to recognize the .mdb
file other then c:\.... meaning, i need to create a connectionString
that will allow me to contact the same .mdb file that currently is
located on the same machine i'm programming on with remote connection.

thanks,

noy

Aug 30 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jaydeep | last post by:
Hello, I am facing a strange problem. Problem accessing remote database from ASP using COM+ server application having VB components (ActiveX DLL) installed. Tier 1 : ASP front End (IIS 5.0) Tire...
3
by: prodirect | last post by:
Hi all, I hope someone can help me. I've recently created a database and wanted to put it up on an ftp sight so that multiple people could access the same tables at the same time from different...
1
by: Z0gS | last post by:
I got this problem for the web application I try to access files on a remote server. string dirs = Directory.GetDirectories(@"E:\vehicles") E drive is a map to a network drive. I get the...
2
by: Jon L. Lovesky | last post by:
Hello all, I am attempting to access a remote folder from an asp.net application (all within the same domain). The application is configured for windows authentication in IIS and the asp.net...
2
by: Ian Murrell | last post by:
My application writes a text data file to a folder on another computer. The other computer is mapped by drive letter to the root (C) shared folder, eg as G:. The network is simple peer2peer, shared...
3
by: Fredric Ragnar | last post by:
Hi, I am making a prototype system with Remoting in the bottom of the system. An XML Web Service is using the remote object on an IIS to present data. I am using a TcpChannel for communicating...
15
by: =?Utf-8?B?TVNU?= | last post by:
To demonstrate my problem, I have a very simple VB Windows application. It has a text box that is used to display a counter, a button to reset the counter, and a timer that increments the counter...
4
by: wickedweapon | last post by:
Hi, I'm trying to access a remote computer and view its running processes thorugh WMI by using a script on my system but i keep getting "RPC server unavailable" error.I have changed the COM...
3
by: ist | last post by:
Hi, I am trying to get (and transfer over ASP.NET) some encrypted data from some MySQL fields. Since the data contains many unicode characters, I tried to get the data as a series of ASCII...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.