🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4922

Re: Access to MSAccess database on a remote computer with http?

#4922
From: m.durliNOSPAM
Date: Thu, 30 Aug 2001 16:46
44 lines
2636 bytes
Thank you for the very long and esaurient answer, but it doesn't solve
my problem:

>Unfortunately, it is not directly possible. The reason this works for
>SQL server is because there is a database server program running on your
>server, and it can be invoked over TCP/IP. This is not the case for
>Access.

I know this, I'm looking for a way to go around this, and let my
software written in BCB to directly update the DB, through ASP pages.
I mean: the software establish an http connection with the server, and
through POST and GET in ASP pages adds or modify records.

>1) If your hosting company lets you run CGI programs written in
>languages other than Perl, you can write a form processor using the BCB
>web components and have it update the database.

I can run ASP pages, what you mean with form processors? 
Maybe this is the solution I'm looking for, do you know where can I
find an example?

>2) If not, but your hosting company supports ASP pages, you can use a

This is ok, but I need the software do do it, no user input

>3) You can update the database local to your machine and copy it to the

No, I need to work on the database on the site, I can't upadate
locally and then upload the whole mdb file.

>4) You could use BCB to write a generalized "Access DB Server" program,
>if you can run such a thing at your host company server. Then you could
>write a client program for it (perhaps using sockets for communication)
>and do your updates that way.

I can't run stuff on the server.
>
>I hope this helps. Personally, I recommend (2) as the easiest and
>likliest to be acceptable to a hosting company

Thank you, but as I said I need the software to do it, not the user
using a browser.
Can you explain me better the (1) solution?
Bye!
Technical Details
Message-ID: <3b8e6ba5.4896721@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews
References: <3b8a52a7.4126373@newsgroups.borland.com> <3B8CD2D9.4F849134@temporaldoorway.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,825b126563bb93bf
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-30 10:06:24 PST
From: m.durliNOSPAM@bo.nettuno.it
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Access to MSAccess database on a remote computer with http?
Date: Thu, 30 Aug 2001 16:46:54 GMT
Message-ID: <3b8e6ba5.4896721@newsgroups.borland.com>
References: <3b8a52a7.4126373@newsgroups.borland.com> <3B8CD2D9.4F849134@temporaldoorway.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 151.26.130.210
X-Trace: dnews 999189781 151.26.130.210 (30 Aug 2001 09:43:01 -0700)
Lines: 44
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews