I've been called out of retirement to make a small database application for
my local crinklies group and am a bit rusty. This is not strictly anything
to do with Access per se but that is what I am using and I'm sure it is no
great challenge to the excellent people who meet here.
I have made my application in Delphi which uses MS Access tables and which
are very small, 100 or so records, which runs across a network from a UNIX
server but I can't get the path to work. It all works fine on my own
machine. For simplicity and testing purposes I have hard coded the path
something like:
http:\\ www.myserver\myapplication\MyApp.Exe. The Delphi execute and the
Access DB are all in the directory: 'myapplication' .
When I run it it throws an error saying the path is
http:\\ www.myserver\myapplication\/TableOne. If I put it inside a
UnixPathToDosPa th function it shows http://www.myserver/myapplication/TableOne. which is fine except it doesn't
run. I can't figure out how to stop the programme adding a slash / before
the table name. I think it is a Microsoft Windows thing but I'm not sure.
Incidently, a couple of Delphi apps which don't use a DB run fine and so
does my DB app if the Access db is on my machine but the Delph EXE file is
on the Server.
Any ideas would be most welcome.
Ian Millward
Edinburgh
(\__/)
(='.'=)
(")_(") 6  2676 
Are you trying to connect to a table in an Access database using http? You
can't: Access doesn't recognize the http: protocol (nor ftp:, for that
matter)
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no private e-mails, please)
"Larthusza" <Th************ ****@Yahoo.comw rote in message
news:12******** *****@corp.supe rnews.com...
I've been called out of retirement to make a small database application
for
my local crinklies group and am a bit rusty. This is not strictly anything
to do with Access per se but that is what I am using and I'm sure it is no
great challenge to the excellent people who meet here.
I have made my application in Delphi which uses MS Access tables and which
are very small, 100 or so records, which runs across a network from a
UNIX
server but I can't get the path to work. It all works fine on my own
machine. For simplicity and testing purposes I have hard coded the path
something like:
http:\\www.myserver\myapplication\MyApp.Exe. The Delphi execute and the
Access DB are all in the directory: 'myapplication' .
When I run it it throws an error saying the path is
http:\\www.myserver\myapplication\/TableOne. If I put it inside a
UnixPathToDosPa th function it shows
http://www.myserver/myapplication/TableOne. which is fine except it
doesn't
run. I can't figure out how to stop the programme adding a slash / before
the table name. I think it is a Microsoft Windows thing but I'm not sure.
Incidently, a couple of Delphi apps which don't use a DB run fine and so
does my DB app if the Access db is on my machine but the Delph EXE file is
on the Server.
Any ideas would be most welcome.
Ian Millward
Edinburgh
(\__/)
(='.'=)
(")_(")
Thanks Doug,
It is either an Access or a DBISAM db. I have had a reply from Elevate
Software, the DBISAM Developers, and they recon I can get it to run with a
generic URL rather than an HTTP URL. I think I might have cracked it now.
I'm just getting the path from my host.
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .comwrote in message
news:uD******** *****@TK2MSFTNG P06.phx.gbl...
Are you trying to connect to a table in an Access database using http? You
can't: Access doesn't recognize the http: protocol (nor ftp:, for that
matter)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Larthusza" <Th************ ****@Yahoo.comw rote in message
news:12******** *****@corp.supe rnews.com...
>I've been called out of retirement to make a small database application
for
my local crinklies group and am a bit rusty. This is not strictly
anything
to do with Access per se but that is what I am using and I'm sure it is
no
great challenge to the excellent people who meet here.
I have made my application in Delphi which uses MS Access tables and
which
are very small, 100 or so records, which runs across a network from a
UNIX
server but I can't get the path to work. It all works fine on my own
machine. For simplicity and testing purposes I have hard coded the path
something like:
http:\\www.myserver\myapplication\MyApp.Exe. The Delphi execute and the
Access DB are all in the directory: 'myapplication' .
When I run it it throws an error saying the path is
http:\\www.myserver\myapplication\/TableOne. If I put it inside a
UnixPathToDosP ath function it shows
http://www.myserver/myapplication/TableOne. which is fine except it
doesn't
run. I can't figure out how to stop the programme adding a slash / before
the table name. I think it is a Microsoft Windows thing but I'm not sure.
Incidently, a couple of Delphi apps which don't use a DB run fine and so
does my DB app if the Access db is on my machine but the Delph EXE file
is on the Server.
Any ideas would be most welcome.
Ian Millward
Edinburgh
(\__/)
(='.'=)
(")_(")
As pointed out, you can't use windows file protocol over the internet.
So, your .exe file is actually being download to your *local* machine, and
executed there.
In the case of a mdb file, the open command DOES NOT TRANSFER the whole
file.
you in effect needs windows network protocols here to open the file. That
means you need a samba share, and ALSO to setup a VPN to be able to open and
read those files using the windows network system (ftp, or http is NOT
windows networking).
So, you need samba + a vpn. However, if your connection is actually *over*
the internet, then I am afraid your connation is about 100 times slower then
normal, and worse, your data will be subject to corruption.
I explain how, and why this is so here in layman's terms here: http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com
As pointed out, you can't use windows file protocol over the internet.
So, your .exe file is actually being download to your *local* machine, and
executed there.
In the case of a mdb file, the open command DOES NOT TRANSFER the whole
file.
you in effect needs windows network protocols here to open the file. That
means you need a samba share, and ALSO to setup a VPN to be able to open and
read those files using the windows network system (ftp, or http is NOT
windows networking).
So, you need samba + a vpn. However, if your connection is actually *over*
the internet, then I am afraid your connation is about 100 times slower then
normal, and worse, your data will be subject to corruption.
I explain how, and why this is so here in layman's terms here: http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com
Thanks Albert,
I reckon that answers my question fairly succinctly. I was trying for an
easy answer but it seems there isn't one.
The server I am hosted on has MySQL and php so I will try that route.
"Albert D. Kallal" <Pl************ *******@msn.com wrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..
As pointed out, you can't use windows file protocol over the internet.
So, your .exe file is actually being download to your *local* machine, and
executed there.
In the case of a mdb file, the open command DOES NOT TRANSFER the whole
file.
you in effect needs windows network protocols here to open the file. That
means you need a samba share, and ALSO to setup a VPN to be able to open
and read those files using the windows network system (ftp, or http is NOT
windows networking).
So, you need samba + a vpn. However, if your connection is actually *over*
the internet, then I am afraid your connation is about 100 times slower
then normal, and worse, your data will be subject to corruption.
I explain how, and why this is so here in layman's terms here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
can't: Access doesn't recognize the http: protocol (nor ftp:, for that
Using the text IISAM:
tdf.SourceTable Name = "Q1SalesDat a"
tdf.Connect = "HTML Import;DATABASE =http://" & _
"www.server1.co m/samples/page1.html"
HTTPS and FTP too.
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .comwrote in message
news:uD******** *****@TK2MSFTNG P06.phx.gbl...
Are you trying to connect to a table in an Access database using http? You
can't: Access doesn't recognize the http: protocol (nor ftp:, for that
matter)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Larthusza" <Th************ ****@Yahoo.comw rote in message
news:12******** *****@corp.supe rnews.com...
I've been called out of retirement to make a small database application
for
my local crinklies group and am a bit rusty. This is not strictly
anything
to do with Access per se but that is what I am using and I'm sure it is
no
great challenge to the excellent people who meet here.
I have made my application in Delphi which uses MS Access tables and
which
are very small, 100 or so records, which runs across a network from a
UNIX
server but I can't get the path to work. It all works fine on my own
machine. For simplicity and testing purposes I have hard coded the path
something like:
http:\\www.myserver\myapplication\MyApp.Exe. The Delphi execute and the
Access DB are all in the directory: 'myapplication' .
When I run it it throws an error saying the path is
http:\\www.myserver\myapplication\/TableOne. If I put it inside a
UnixPathToDosPa th function it shows
http://www.myserver/myapplication/TableOne. which is fine except it
doesn't
run. I can't figure out how to stop the programme adding a slash /
before
the table name. I think it is a Microsoft Windows thing but I'm not
sure.
Incidently, a couple of Delphi apps which don't use a DB run fine and so
does my DB app if the Access db is on my machine but the Delph EXE file
is
on the Server.
Any ideas would be most welcome.
Ian Millward
Edinburgh
(\__/)
(='.'=)
(")_(")
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Dave |
last post by:
Hi everyone,
I wonder is there a way in php for it to find out if the system is a windows
or unix based system. I read $_ENV is set on windows but not unix
but it does not seem to work.
Thanks for your help.
--
AKA Marketing.com - Internet Marketing (mainly)
http://www.akamarketing.com/hosting
|
by: Travis James Kleeburg |
last post by:
I am trying to copy files from one directory into another using
shutil.copy. I am having a problem getting a usable path using
os.path.abspath because it doesnt return a string with the extra
backslashes and i was wondering if there was a better system call to use?
I am also looking for a system call so there wont be a problem between windows and
unix.
|
by: Rob Cowie |
last post by:
Hi,
Given a string representing the path to a file, what is the best way to
get at the filename? Does the OS module provide a function to parse the
path? or is it acceptable to split the string using '/' as delimiters
and get the last 'word'. The reason I'm not entirely happy with that
method is that it is platform specific. I would prefer to use a built
in method if possible.
Cheers,
|
by: Xah Lee |
last post by:
Python Doc Problem Example
Quote from:
http://docs.python.org/lib/module-os.path.html
----------
split( path)
Split the pathname path into a pair, (head, tail) where tail is the
last pathname component and head is everything leading up to that. The
tail part will never contain a slash; if path ends in a slash, tail
will be empty. If there is no slash in path, head will be empty. If
|
by: Randy |
last post by:
Hello All,
I'm getting a strange error when trying to perform a file upload. Here's the
lines that uploads the file...
sSaveLocation = Server.MapPath("PFPDocs") + "\\" + fileName;
fileInput.PostedFile.SaveAs(sSaveLocation);
When it runs, I'm getting a "Access to the path xxx is denied" error. On the
server (Server 2003) I've given the ASP.NET and Everyone Full Control but
still I get the error. I've also given IUSR_machinename Full...
| | |
by: Blake McNeill |
last post by:
How do you retrieve a file path which was stored in the Registry as a string
without ending up with a string which has all the slashes escaped which make
it useless for file IO? I can see the file path in the registry using
RegEdit and it is exactly what I want, but when I use:
string filePath = Registry.GetValue(keyPath, keyName, null).ToString();
filePath is something like C:\\Data\\MyFile.txt when I need it to be...
|
by: kj |
last post by:
How can a script know its absolute path? (__file__ only gives the
path it was used to invoke the script.)
Basically, I'm looking for the Python equivalent of Perl's FindBin.
The point of all this is to make the scripts location the reference
point for the location of other files, as part of a self-contained
distribution.
TIA!
|
by: Kyle Hayes |
last post by:
Is there a way to use the 'r' in front of a variable instead of
directly in front of a string? Or do I need to use a function to get
all of the slashes automatically fixed?
/thanks
-Kyle
|
by: Marcin201 |
last post by:
Is there an built-in functionality in python to convert Windows paths
to Unix paths? I am running into problems when creating data files on
Windows and the running them on a Unix platform. I create paths using
os.path.join.
os.path.join('Pictures', '01.jpg') returns 'Pictures\\01..jpg' on
Win. When I read files created on Win under Unix this is a problem,
python cannot open 'Pictures\\01.jpg'
Thanks,
|
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: 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,...
|
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...
| |
