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 connectionStrin g = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\\Cuto mers.mdb";
to:
Provider=MS Remote;Remote Server=noa-second;Remote
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=c:\\Cuto mers.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 connectionstrin g 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... 4 4207
On Wed, 29 Aug 2007 05:54:35 -0700, Noy B <no*****@gmail. comwrote:
That "Remote server" path is wrong. Check out connectionstrin gs.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 connectionStrin g = "Provider=Micro soft.Jet.OLEDB. 4.0; Data Source=c:\\Cut omers.mdb"; to: Provider=MS Remote;Remote Server=noa-second;Remote Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=c:\\Cuto mers.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 connectionstrin g 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...
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 connectionstrin gs.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 connectionStrin g = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\\Cuto mers.mdb";
to:
Provider=MS Remote;Remote Server=noa-second;Remote
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=c:\\Cuto mers.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 connectionstrin g 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 connectionstrin g.com I couldn't find anything wrong
with my Remote Server. is there any thing you can point out?
Thanks!
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.goog legroups.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 connectionstrin gs.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 connectionStrin g = "Provider=Micro soft.Jet.OLEDB. 4.0; Data Source=c:\\Cut omers.mdb"; to: Provider=MS Remote;Remote Server=noa-second;Remote Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=c:\\Cuto mers.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 connectionstrin g 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 connectionstrin g.com I couldn't find anything wrong
with my Remote Server. is there any thing you can point out?
Thanks!
On Aug 30, 6:21 am, "Larry Linson" <boun...@localh ost.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.goog legroups.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 connectionstrin gs.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 connectionStrin g = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\\Cuto mers.mdb";
to:
Provider=MS Remote;Remote Server=noa-second;Remote
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=c:\\Cuto mers.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 connectionstrin g 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 connectionstrin g.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 connectionStrin g
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 2 : COM objects
Tier 3 : SQL Server 2000 DB
Flow is : ASP talks with COM objects and COM objects talks with DB
Scenario 1
|
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 geographical locations. I have been
completely unsucessful in acheiving this goal so far however.
Things I have tried:
Create a shortcut to ftp...
|
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 DirectoryNotFoundException. How do I solve the problem or the is another way to write the code
Thank yo
|
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 worker process runs as the local
ASP.NET account. When the application is about to access the remote folder I
switch the security context to the remote...
|
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 root folders etc.
Immediately after restarting the application computer, and when my
application attempts to write to the mapped network computer...
| |
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 between the XML Web Service and
the host for the remote object. Within the host a port is defined and the
channel registered. It starts listening...
|
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 every second.
I remote desktop to the computer hosting this application and run the
application. It starts up and displays the counter...
|
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 settings(as mentioned in msdn library articles) many times but it still gives the same error. The account that I have used to log on to my computer is an...
|
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 values,
transfer those numeric values over ASP.NET. I had no problem doing
this on my local computer, by getting the field with "cast(field as
BINARY)"...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |