Hello, i'm need some help, i want to run a website on a server with an sql
database ( that in itself is no problem, i've done this before) but with a
possibility to update the sql database with data stored on a local harddrive
in an acess database, can ianyone give me some hints or websites with
related info ?
thanks in advance
3  2185 
Sure, if your website has a MySQL database, you will be able to access this
database from your PC when you are on-line.
All you need is the free MyODBC odbc drivers, install & configure them
(you'll need the IP address, name, username, password of your on-line
database). Then you can link up the MySQL database to anything on your PC -
MSAccess or even something a bit more stable...
The MyODBC drivers are available here: http://www.mysql.com/
"eddy princen" <ep******@isep. myftp.biz> wrote in message
news:bp******** **@reader11.wxs .nl... Hello, i'm need some help, i want to run a website on a server with an sql
database ( that in itself is no problem, i've done this before) but with a
possibility to update the sql database with data stored on a local
harddrive in an acess database, can ianyone give me some hints or websites with
related info ?
thanks in advance
thanks rory, i will surely look into it, but do you have info concerning
Sql 2000 on the server and msaccess on the desktop or client side ?
"Rory" <rory> schreef in bericht news:3f******@2 12.67.96.135... Sure, if your website has a MySQL database, you will be able to access
this database from your PC when you are on-line.
All you need is the free MyODBC odbc drivers, install & configure them
(you'll need the IP address, name, username, password of your on-line
database). Then you can link up the MySQL database to anything on your
PC - MSAccess or even something a bit more stable...
The MyODBC drivers are available here: http://www.mysql.com/
"eddy princen" <ep******@isep. myftp.biz> wrote in message
news:bp******** **@reader11.wxs .nl... Hello, i'm need some help, i want to run a website on a server with an
sql database ( that in itself is no problem, i've done this before) but with
a possibility to update the sql database with data stored on a local
harddrive in an acess database, can ianyone give me some hints or websites with
related info ?
thanks in advance
If you have Personal Web Server then you can run asp pages on your
local machine which will be known as http://127.0.0.1 or http://localhost.
You then write an asp page to read from the Access database in your
machine and then output the required data for insertion into the sql
database at the remote machine.
Ken
On Sun, 23 Nov 2003 23:52:27 +0100, "eddy princen"
<ep******@isep. myftp.biz> wrote: Hello, i'm need some help, i want to run a website on a server with an sql
database ( that in itself is no problem, i've done this before) but with a
possibility to update the sql database with data stored on a local harddrive
in an acess database, can ianyone give me some hints or websites with
related info ?
thanks in advance This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.
I'd like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button (or
similar) in the Access application.
|
by: kackson |
last post by:
Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!
|
by: Red Golpe |
last post by:
I've managed to read from a local database using only javascript and the DAO
ActiveX object, but I can't make it work with a remote database. When I
change the connection string from "C:\..." to "http://..." it doesn't work
any more. Any suggestion?
Red Golpe
______________________________________________
"What does not kill you... makes you stronger"
|
by: Rupe |
last post by:
I have a web site on a remote, shared host with a bunch of individual
Access databases. I want to switch my databases from Access to MS SQL
and have some questions.
I update some of my Access databases through web-based content
management systems. Other databases I update locally (through a bunch
of Access forms) and FTP them periodically to my web site.
I want to be able to switch my databases over to SQL, store them on a
remote...
|
by: news |
last post by:
I have a new situation I'm facing and could use a suggestion or two, as
I don't seem to be able to think in the abstract very well.
We have a local server which holds all of our image files.
We have a remote server that runs our public Web server and mySQL
database.
I need to be able to run a script that will:
Read the contents of a dir on the local server and
a. make thumbnails of the files in it
b. querey the database and pull...
| | |
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...
|
by: peshekeedweller |
last post by:
Using asp.net 1.1. vb.net 2003.
I am trying to connect to a remote sql server 2000 on a virtual machine
running windows 2000 server. I can connect through the server explorer in
visual studio, but cannot connect through code. I have done it before and
can not do it now; I don't know what changed. (I also cannot connect to
local Access database through code though I can from server explorer.)
The code is:
conn = New SqlConnection("data...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: Nymus |
last post by:
I would like to use an access database as a shared database on a remote website. I don't know if it is possible, but this is what i would like to do with this database:
- Use it to run a database driven website
- Maintain it via a client application and via the website.
As i would like to maintain it both locally and remote via website forms written in ASP, I don't want to sync the information between the server and a client database.
I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
