Re: code for DAP not working
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Thu, 3 Nov 2021 02:02:51 -0500
This code looks like ASP code running on the server side; it won't work
inside a DAP page as such.
Even if you try removing the Server. object and make a direct call to the
CreateObject() function; there is a possibility that the DAP page won't be
able to open the database E:\myDBfile.mdb if the client machine running the
DAP page is not located on the same LAN.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"GM" <GM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:62E2B35E-3E3F-48C3-9E6B-6274855EFCA5@xxxxxxxxxxxxxxxx
> The recordset does not open. Any ideas? At one time there was an error
> that
> server needed an object. Now there is no error. The code runs but the
> recordset isn't showing in my DAP form. I can't seem to find any clear
> examples of programmatically opening another recordset from the same db
> using
> vbscript.
>
> if cbo.value = "iteminList" then
> set conn=Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.Open "E:\myDBfile.mdb"
> set rs = Server.CreateObject("ADODB.recordset")
> rs.Open ["recordsetfromTable"], conn
> end if
>
> Thanks
.
- Follow-Ups:
- Re: code for DAP not working
- From: aghosh
- Re: code for DAP not working
- Prev by Date: Re: dropdown popup filter?
- Next by Date: Re: slow client/server application
- Previous by thread: slow client/server application
- Next by thread: Re: code for DAP not working
- Index(es):
Relevant Pages
|
