From a PHP script, is there any way to retrieve data from an MS Access
database that's located on another computer (on a LAN) other than by
using ODBC?
I posted a question here a couple of weeks ago about the problems I
was having trying to do this via ODBC. I stated then that I was giving
up trying to get it to work but I didn't. I foolishly have spent quite
a few more hours in a futile attempt to get this to work. Now I'm to a
point where I don't know anything further to try.
No, I don't have the option of switching to a different database
format. The data I need to read is in MS Access MDB files and that's
not going to change.
I don't have a problem reading an MDB file when it's on the same
computer that my PHP script is running on but the whole idea of what
I'm trying to do is to read from a file that's located on a different
computer.
Are there any alternatives?
Thanks.
2  4818 
"Martin" <ir************ @gmail.comwrote in message
news:gn******** *************** *********@4ax.c om...
From a PHP script, is there any way to retrieve data from an MS
Access
database that's located on another computer (on a LAN) other than by
using ODBC?
I posted a question here a couple of weeks ago about the problems I
was having trying to do this via ODBC. I stated then that I was
giving
up trying to get it to work but I didn't. I foolishly have spent
quite
a few more hours in a futile attempt to get this to work. Now I'm to
a
point where I don't know anything further to try.
No, I don't have the option of switching to a different database
format. The data I need to read is in MS Access MDB files and that's
not going to change.
I don't have a problem reading an MDB file when it's on the same
computer that my PHP script is running on but the whole idea of what
I'm trying to do is to read from a file that's located on a
different
computer.
Are there any alternatives?
Thanks.
Hello again,
I just got back to checking how my setup was.... and after some
fiddling I got it to work again.
My mdb file is on a remote share, and I use an UNC path.
The trick is this:
Your webserver / PHP combo need access to the file.
That means it needs a valid local user account on the remote computer.
Check what the user account of your webserver is, and create that
account on the remote computer.
Or: change the user the webserver is running under.
Whatever is easiest.
I found a nice doc about it here, it wasnt hard to find though....
surprised me you missed it. http://support.microsoft.com/kb/253580/EN-US/
Richard.
"Richard" <root@localhost wrote in message
news:47******** **************@ news.euronet.nl ...
>
"Martin" <ir************ @gmail.comwrote in message
news:gn******** *************** *********@4ax.c om...
>From a PHP script, is there any way to retrieve data from an MS
Access
database that's located on another computer (on a LAN) other than
by
using ODBC?
I posted a question here a couple of weeks ago about the problems I
was having trying to do this via ODBC. I stated then that I was
giving
up trying to get it to work but I didn't. I foolishly have spent
quite
a few more hours in a futile attempt to get this to work. Now I'm
to a
point where I don't know anything further to try.
No, I don't have the option of switching to a different database
format. The data I need to read is in MS Access MDB files and
that's
not going to change.
I don't have a problem reading an MDB file when it's on the same
computer that my PHP script is running on but the whole idea of
what
I'm trying to do is to read from a file that's located on a
different
computer.
Are there any alternatives?
Thanks.
Hello again,
I just got back to checking how my setup was.... and after some
fiddling I got it to work again.
My mdb file is on a remote share, and I use an UNC path.
The trick is this:
Your webserver / PHP combo need access to the file.
That means it needs a valid local user account on the remote
computer.
Check what the user account of your webserver is, and create that
account on the remote computer.
Or: change the user the webserver is running under.
Whatever is easiest.
I found a nice doc about it here, it wasnt hard to find though....
surprised me you missed it.
http://support.microsoft.com/kb/253580/EN-US/
Richard.
Oops....
the link should have been: http://support.microsoft.com/kb/166029/
R. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: tvn007 |
last post by:
I wrote the code below to read data from file into structure using C.
However, I would like to convert it to C++.
Could someone please give me some hints. I am not that famaliar with
C++
Thanks in advance
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
struct test {
char enabled,
|
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no site that has this
prohibition, and I have uploaded DAPs to various sites and used them
from those sites.
I do not understand why any site manager would prohibit DAPs. To the
best of my knowledge DAPs, as HTM files, are merely hosted on the...
|
by: tvn007 |
last post by:
I am using the following code to read data from input file into
structure.
Not sure it is the best way. Please comment or you have better way.
please let me kmow.
//////////////////////////////////////////////////////////////////////////
#include <iostream>
#include <string>
#include <fstream>
#include <sstream>
using namespace std;
|
by: kathy |
last post by:
to read float type data, we can use:
....
float f;
fscanf(outfile, "%f", &f);
....
but for double type, how to do that?
....
double d;
|
by: Paul M |
last post by:
Hello,
I want to to be able to read line by line the contents (ie the html)
inside some Data Access Pages I have in a Microsoft Access database.
There doesnt seem to be a call I can use in the Access library within VB
..net to allow me to read lines (there is for modules).
On option I thought was to get the file path from the Access DB then
open up and read the using normal file handling calls, however once
again I cant find a property...
| | |
by: klynn |
last post by:
Hi:
I'm having problems reading a Microsoft Access file from my ASP.Net app on a
Windows Server 2003 machine. The error message:
The Microsoft database engine cannot open the file, <my_file>. It is
already opened exclusively by another user, or you need permission to view
its data.
I've read some info about this (microsoft support article q316675) but I'm
still confused on what to do?
|
by: jim.omalley |
last post by:
I'm trying to write an interface to send scoreboard data from an XML
file generated by a football stats program to a Chyron CODi character
generator connected to my COM1 serial port (all operations on same
machine). I'm already able to send static commands written into HTTP
forms to control the CG via serial COM1.
What I'm needing is a way to read and parse variables from the XML,
then generate a CODi command string which can be written...
|
by: greg |
last post by:
Hi,
I have a read only access file with a linked table that connects to a
sybase database. So I can still add data to the table even though its
read only since the table is really in sybase. However, I want to
import data from an excel file (either via a macro in excel or access)
but I always get an "Error 3051" because the access file is read
only. Does anyone know a good workaround to this? I've been using the
TransferSpreadsheet...
|
by: chikhalepankaj |
last post by:
hi guys, I hv problem in reading data from text file. I want to read data in column wise from the table shown as below
Module Ad Di Do
4011 1 2 -
4012 2 3 2
4013 2 3 3
4014 4 7 8
i m looking for a program which is going to read MODULE column and store it in a Char *Buf for eg.
|
by: runsun |
last post by:
Thanks in advance. This program is written in C.
It needs to read all characters from a file; then write them into a 3D array (yes, 3D!).
The file is a .prn file (one of the Excel types), which separates columns with space.
To simplify the question, the file contains 3 rows and 2 columns:
abc 2,3
defg 4
h 5,6
array is array, where the 3rd D contains the # of rows; 2nd D has #conlumns; 1st D contains the character elements. i.e....
|
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: 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...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
