Re: One SQL, two conns

From: Stuart Palmer (stuartglenpalmer_at_ntlworld.com)
Date: 08/29/04 

Date: Sun, 29 Aug 2004 15:42:47 GMT

Thx,
I think I understadn what you mean, but I am not quite understanding.
I have MDB db's. Are you saying I should be able to somehow add something to
the products MDB to state that I want it to connect to the other in some
manner?

Do you have a link to anything on the web that might be able to explain this
better? I have looked up connection pooling on the www but it offers me no
example (code/process for me to do this except enabling and disabling
it....which is done on the server (my Host won't let me do this I don't
think :o( )

Thx again
Stu

"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message
news:OEzbnKdjEHA.3608@TK2MSFTNGP09.phx.gbl...
> Stuart,
>
> A good practice is to connect to only one database, and take advantage of
> connection pooling. You can create views in your product table, to the
> tables within cart database. This way, you can just connect to one
database.
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com
>
>
> "Stuart Palmer" <stuartglenpalmer@ntlworld.com> wrote in message
> news:_leYc.9$fU3.6@newsfe6-win.ntli.net...
> > Hi There,
> > I'm writing an ASP cart and hit a problem.
> >
> > I have 2 db's, one is products, one is cart contents.
> >
> > Cart contents holds the unique ID from products when you do your
'basket'.
> >
> > When I display the basket, I want to display the products name from the
> > products DB based on the ID stated in the cart DB
> >
> > I have been informed I can do this with SQL some how, but that means I'd
> > have to create two conn objects? or can it be done another way?
> >
> > Thx for the advise.
> >
> > Stu
> >
> >
>
>

Relevant Pages

  • Re: Dsiplay tables
    ... The easiest way is to create a DataSet from the database. ... Therefore, God exists. ... How can I display a list of all the tables created in a database (.mdb ...
    (microsoft.public.dotnet.general)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: Access to Access Automatic Updates
    ... MS Office Master 2000 ed. ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
Loading