Article View: borland.public.cppbuilder.database.ado
Article #4922Re: Access to MSAccess database on a remote computer with http?
From: m.durliNOSPAM
Date: Thu, 30 Aug 2001 16:46
Date: Thu, 30 Aug 2001 16:46
44 lines
2636 bytes
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!dnewsReferences:
<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