RE: FN-FORUM: ODBC Query two DB's

date posted 4th August 2005 16:45

Hi Andy, both DB's are on the same server what should use to pull the
record sets out?

I wanted to use excel but how would I run a select in excel? I can only
make 1 ODBC connection at a time or have I got this wrong?

Andrew


> You can do;
>
> SELECT t1.field1, t2.field2 FROM DB1.DBO.TABLENAME t1, DB2.DBO.TABLENAME
> t2 WHERE T1.id =3D t2.id
>
> So long as the databases are on the same server.
>
> You *can* do it with differnet servers (best via a stored procedure)
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
> [EMAIL REMOVED]
> Sent: Wednesday, August 03, 2005 11:11 AM
> To: Andy Macnaughton-Jones
> Subject: FN-FORUM: ODBC Query two DB's
>
>
> Hi All, I am producing a report based on information coming from 2 DB's
> both of which reside on the same MS SQL server. Having made the ODBC
> conncetion I am quite happy pulling in the respective tables from one DB
> want I now want to do is pull in the Tables/fields from the DB but this
> is where I loosing the plot.
>
> I am thinking along the lines that I need a VB command or some kind of
> dual ODBC connection. Am I making this more comlicated than it really
> is?
> I only have one common ID to match to and that is ProductId
>
> Andrew
>
>
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
> or visit www.prosperity4.com and benefit from Inland Revenue approved
> expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>