🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Connecting to ms-accesdatabase on webserver

#1575
From: Princen Eddy
Date: Fri, 21 May 2004 10:38
37 lines
1946 bytes
Hello,

I already make programs in delphi and use databases as dbase, paradox,
ms-access. No problems there.
I also write asp-code for some people to let them make use of ms-acces
database for small e-shop's. Also no problem there

Now i want to make some activex-forms to connect to the ms-access database
on the webserver. When i make a connection in de TadoConnection component to
the local path of the database no problem the form works fine in the IE 6.0
explorer. But now i want to connect to the webservers database ( also
MS-access ) but i can't find out how to tell the ado-connection component to
connect to the webserver database ?????

In asp it's like this

        Set Conn = Server.CreateObject("ADODB.Connection")

        Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath ("db\cierob.mdb")



But it seems that in de TAdoConnection component i always have to give up
physical path to the database ????



Can anyone give me a hand with this ?



Thanks in advance.



Princen Eddy
Technical Details
Message-ID: <40addb20$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4a875d96c1cb2a6c,start
X-Google-Attributes: gid10698b,public
Reply-To: "Princen Eddy" <eddy@cierob.be>
From: "Princen Eddy" <eddy@cierob.be>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Connecting to ms-accesdatabase on webserver
Date: Fri, 21 May 2004 12:38:54 +0200
Lines: 43
Organization: CIEROB N.V.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 81.11.185.120
Message-ID: <40addb20$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1085135648 81.11.185.120 (21 May 2004 03:34:08 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail