|
 |
asp_web_howto thread: can we extract data from 2 diff access db located on teh same server
Message #1 by "taherm@f... on Wed, 21 Nov 2001 17:08:41
|
|
Hi Friends
can we extract data from 2 diff access db located on teh same server.. if
yes then can anyone send me an example script.. its like i want to write
join statement joining 2 tables a and b
table A is in product db
table b is in spares db..
both the dbs are located on teh same server and in the same folder but
have seprate dsns...plz let m kwo of what to do in this case...
Eagerly awaiting any sort of response..
Regards
Message #2 by "Jason Salas" <jason@k...> on Thu, 22 Nov 2001 10:31:57 +1000
|
|
I believe you might need some third-party component to do this, as Access
and ADO don't support inter-DB transactions very well.
HTH,
Jason
----- Original Message -----
From: <taherm@f...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Wednesday, November 21, 2001 5:08 PM
Subject: [asp_web_howto] can we extract data from 2 diff access db located
on teh same server
> Hi Friends
> can we extract data from 2 diff access db located on teh same server.. if
> yes then can anyone send me an example script.. its like i want to write
> join statement joining 2 tables a and b
> table A is in product db
> table b is in spares db..
>
> both the dbs are located on teh same server and in the same folder but
> have seprate dsns...plz let m kwo of what to do in this case...
>
> Eagerly awaiting any sort of response..
> Regards
>
>
$subst('Email.Unsub')
>
>
Message #3 by "taherm@f... on Thu, 22 Nov 2001 09:39:44
|
|
Hi Jason...
thanks for your suggestion...
IS there any other alternative????
i thought of using sql server and trasnsfer tables from both the db into
one sql server db...
Regards
> I believe you might need some third-party component to do this, as Access
> and ADO don't support inter-DB transactions very well.
>
> HTH,
> Jason
>
> ----- Original Message -----
> From: <taherm@f...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Wednesday, November 21, 2001 5:08 PM
> Subject: [asp_web_howto] can we extract data from 2 diff access db
located
> on teh same server
>
>
> > Hi Friends
> > can we extract data from 2 diff access db located on teh same server..
if
> > yes then can anyone send me an example script.. its like i want to
write
> > join statement joining 2 tables a and b
> > table A is in product db
> > table b is in spares db..
> >
> > both the dbs are located on teh same server and in the same folder but
> > have seprate dsns...plz let m kwo of what to do in this case...
> >
> > Eagerly awaiting any sort of response..
> > Regards
> >
> >
> $subst('Email.Unsub')
> >
> >
>
Message #4 by "Jason Salas" <jason@k...> on Thu, 22 Nov 2001 19:43:28 +1000
|
|
Hi,
Well, Access can't do cross-DB transactions like that, but SQL Server can on
its own. If you're thinking about transferring data from the tables, then
you could just do this in your current Access DB, using the Import tool.
----- Original Message -----
From: <taherm@f...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, November 22, 2001 9:39 AM
Subject: [asp_web_howto] Re: can we extract data from 2 diff access db
located on teh same server
> Hi Jason...
> thanks for your suggestion...
> IS there any other alternative????
> i thought of using sql server and trasnsfer tables from both the db into
> one sql server db...
>
> Regards
>
>
>
> > I believe you might need some third-party component to do this, as
Access
> > and ADO don't support inter-DB transactions very well.
> >
> > HTH,
> > Jason
> >
> > ----- Original Message -----
> > From: <taherm@f...>
> > To: "ASP Web HowTo" <asp_web_howto@p...>
> > Sent: Wednesday, November 21, 2001 5:08 PM
> > Subject: [asp_web_howto] can we extract data from 2 diff access db
> located
> > on teh same server
> >
> >
> > > Hi Friends
> > > can we extract data from 2 diff access db located on teh same server..
> if
> > > yes then can anyone send me an example script.. its like i want to
> write
> > > join statement joining 2 tables a and b
> > > table A is in product db
> > > table b is in spares db..
> > >
> > > both the dbs are located on teh same server and in the same folder but
> > > have seprate dsns...plz let m kwo of what to do in this case...
> > >
> > > Eagerly awaiting any sort of response..
> > > Regards
> > >
> > >
> > $subst('Email.Unsub')
> > >
> > >
> >
>
$subst('Email.Unsub')
>
>
Message #5 by Manhal Shukayr <mshukayr@r...> on Thu, 22 Nov 2001 07:07:08 -0600
|
|
At 05:08 PM 11/21/2001, you wrote:
>Hi Friends
>can we extract data from 2 diff access db located on teh same server.. if
>yes then can anyone send me an example script.. its like i want to write
>join statement joining 2 tables a and b
>table A is in product db
>table b is in spares db..
>
>both the dbs are located on teh same server and in the same folder but
>have seprate dsns...plz let m kwo of what to do in this case...
>
>Eagerly awaiting any sort of response..
>Regards
Can't you link the tables between the databases? Create a link
in product db to table b and an link in spares db to table a.
We do this all the time in vb but have not tried it in asp pages
Manhal Shukayr
mshukayr@r...
|
|
|
View Cart
