473,748 Members | 4,804 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 2073
"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
3972
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
7236
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
5174
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
3696
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
4342
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
1835
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
2787
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
3331
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
4222
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
9544
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...
1
9324
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
9247
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...
1
6796
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4606
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
4874
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3313
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
2783
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2215
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.