473,699 Members | 2,827 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Accessing a MS Access database across two servers

Hi

The technical support guys at my company have set up my system so that
the server containing the MS Access database is on one server, while
the pages that should access the database are on another server.

When the pages and database are on the same server, I usually just
connect through ODBC.

The problem is that I don't know how to set up an ODBC connection to
link from one server to a database in another.

Anyone know what I am getting at and know of a possible solution, or a
link to a site which may help.

thanks in advance

Brendan

Nov 13 '05 #1
4 2067
"Singularit y" <Br************ *@Singularity.c o.uk> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. .
Hi

The technical support guys at my company have set up my system so that
the server containing the MS Access database is on one server, while
the pages that should access the database are on another server.

When the pages and database are on the same server, I usually just
connect through ODBC.

The problem is that I don't know how to set up an ODBC connection to
link from one server to a database in another.

Anyone know what I am getting at and know of a possible solution, or a
link to a site which may help.

I think this may be more of a network issue than an Access one. Can you see
both servers from your PC? Is there any particular reason why they've been
put on different servers? Seems a little odd to me.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #2
Yeah, I can see both of the servers from my pc. I think the reason for
the configuration is to do with the firewall. They want to keep the
database behind the firewall and for the pages to access the database
to be kept outside the firewall.

Nov 13 '05 #3
This is the way things are set up for most applications I've done. The
database server is separated from the application server or servers for
a variety of reasons.

See the connection string references

http://www.connectionstrings.com
http://www.codemaker.co.uk/it/tips/ado_conn.htm

If your MS Access database is on a different server from the
application then you can reference the database file using the full UNC
path to the file which includes server name
(\\server\share \database.mdb)

Bill E.
Hollywood, FL

Nov 13 '05 #4
"Singularit y" <Br************ *@Singularity.c o.uk> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...
Yeah, I can see both of the servers from my pc. I think the reason for
the configuration is to do with the firewall. They want to keep the
database behind the firewall and for the pages to access the database
to be kept outside the firewall.

By 'pages' do you mean built-in MS Access pages or HTML or ... ?
Nov 13 '05 #5

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

Similar topics

8
3969
by: ndsoumah | last post by:
hello guys I'm trying to get access to variables I put in a session variable from another page and it fails... here's the exact situation main file page1.php
1
7232
by: Mark McKay | last post by:
I've been reading 'Java RMI' from O'Reilly, and it provides a nice example of scaling a server application by creating multiple instances of server objects on several distinct machines (each running their own JVM), and directing clients to the appropriate server through the naming registry. However, it doesn't really get into how those servers might talk to each other, except through similar calls through the registry. For example,...
68
5152
by: rkusenet | last post by:
http://www.eweek.com/article2/0,1759,1820667,00.asp The database market grew by 10.3 percent in 2004, fueled largely by hunger for business intelligence and analytics, according to numbers released by the Gartner Group on Monday. With 34.1 percent of the overall market, IBM holds a slim margin over its closest competitor, Oracle Corp., which maintains 33.7 percent of the overall market. Microsoft Corp. follows up with 20 percent of...
5
3692
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur: 1. Access is way too slow in WAN environment. Server is located in New Jersey and users are in California and Puerto Rico. 2. Database often becomes corrupt 3. When one user updates some data in the database, other users...
6
4339
by: Jeff | last post by:
Has anyone had any luck accessing an Oracle database from a web service? I have a C# DLL with various code to query an Oracle database. If I call the methods in this DLL from a Windows Forms application everything works just fine. However, if I call the methods in this DLL from a web service, I receive the following error when the database connection is opened: Error: ORA-12154: TNS:could not resolve service name Does anyone know...
0
1829
by: John Fleming | last post by:
Hello, I am building a web application with the following components: 2 Web Servers - Windows Server 2003 - IIS 6 - .Net Framework version 2.0 - Reside in Domain A 2 Clustered Database Servers
3
2783
by: RayPower | last post by:
I'm having a system using Access 2000 as both front-end (queries, forms, reports & temp tables for reports) & back-end (data) with back-end running on the server. The application runs on the network with around 15 users. The back-end database is suffering from performance issues. There were several corruptions since few months & one major corruption & corrupted the MSysObjects table. Also, the system will run batch process that generate...
2
3327
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would a standard type 4 driver, jar file copy into the WEB-INF/lib folder not work? I am trying to access db2 8 on z/os though a java app server. thanks.
4
4221
by: Noy B | last post by:
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
0
9174
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9035
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8914
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8884
tracyyun
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5875
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4376
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4629
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3057
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
2
2347
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.