This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BF9983.1C63CC50
Content-Type: text/plain;
charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
If you are going to be using the DTS to use multiple datasources? =
isn't
that the same thing as creating a new table with a stored procedure and
copying the table over? essentially making it one datasource?
-----Original Message-----
From: Brendan Avery [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 20, 2000 4:43 PM
To: [EMAIL PROTECTED]
Subject: RE: 2 different data sources
Here's a solution:
If you need to join two or more tables from different datasources in a
query, you're going to have to do your linking inside on of the =
datasources
or in a new datasource. MS ACCESS allows a REALLY simple way to do =
this
with the command:
"FILE >> GET EXTERNAL DATA >> LINK TABLES"
That lets you set up a local reference in your .MDB file to a table in =
an
another database, either through JET or ODBC (yes, you too can connect =
to
ODBC datasources in access if they're set up on your local machine.) =
Just
note that you can only perform this function if you are working on the
ACTUAL machine which this database will reside. MS ACCESS is funny =
like
that -- so you'll have to install Access on your server and do the =
linking
from there. So, as an example, if I have one datasource called
"EMPLOYEEDATA" and one called "PAYROLLDATA" and I wanted to run a query =
that
joined "EMPLOYEEDATA.tblEmployees" and "PAYROLLDATA.tblChecks", I would
create an MS ACCESS database that contained "Link Tables" for each, =
even
though I use SQL SERVER for all my other database functions. It's =
pretty
easy to do, if a bit kludgey.
SQL SERVER also has a way to connect to external datasources through =
it's
DATA TRANSFORMATION SERVICES area. I'm not as familiar with using =
STORED
PROCEDURES to perform DTS actions or connect to other ODBC sources, so =
I use
little MS ACCESS databases as my connection points between seperate =
ODBC
datasources.
Peas.
B][A -- =DF=AE=EB=D1=D0=C5=F1 =E5V=CA=AE=A5 2.=D8
The Open-Source Human Project
http://mediahorse.com/ba
[EMAIL PROTECTED]
323.402.1222.x7839 vm/fax
> -----Original Message-----
> From: Jim Taylor [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 20, 2000 1:09 PM
> To: [EMAIL PROTECTED]
> Subject: 2 different data sources
>
>
> I hope this is not off topic!!
> Is possible to have a query to 2 different data sources?
>
> --------------------------------------------------------------
> ----------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlist
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------=
----
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_t=
alk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' =
in
the body.
------_=_NextPart_001_01BF9983.1C63CC50
Content-Type: text/html;
charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: 2 different data sources</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>If you are going to be using the DTS to use multiple =
datasources? isn't that the same thing as creating a new table =
with a stored procedure and copying the table over? essentially =
making it one datasource?</FONT></P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Brendan Avery [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, March 20, 2000 4:43 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: RE: 2 different data sources</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Here's a solution:</FONT>
</P>
<P><FONT SIZE=3D2>If you need to join two or more tables from different =
datasources in a</FONT>
<BR><FONT SIZE=3D2>query, you're going to have to do your linking =
inside on of the datasources</FONT>
<BR><FONT SIZE=3D2>or in a new datasource. MS ACCESS allows a =
REALLY simple way to do this</FONT>
<BR><FONT SIZE=3D2>with the command:</FONT>
<BR><FONT SIZE=3D2>"FILE >> GET EXTERNAL DATA >> LINK =
TABLES"</FONT>
<BR><FONT SIZE=3D2>That lets you set up a local reference in your .MDB =
file to a table in an</FONT>
<BR><FONT SIZE=3D2>another database, either through JET or ODBC (yes, =
you too can connect to</FONT>
<BR><FONT SIZE=3D2>ODBC datasources in access if they're set up on your =
local machine.) Just</FONT>
<BR><FONT SIZE=3D2>note that you can only perform this function if you =
are working on the</FONT>
<BR><FONT SIZE=3D2>ACTUAL machine which this database will =
reside. MS ACCESS is funny like</FONT>
<BR><FONT SIZE=3D2>that -- so you'll have to install Access on your =
server and do the linking</FONT>
<BR><FONT SIZE=3D2>from there. So, as an example, if I have one =
datasource called</FONT>
<BR><FONT SIZE=3D2>"EMPLOYEEDATA" and one called =
"PAYROLLDATA" and I wanted to run a query that</FONT>
<BR><FONT SIZE=3D2>joined "EMPLOYEEDATA.tblEmployees" and =
"PAYROLLDATA.tblChecks", I would</FONT>
<BR><FONT SIZE=3D2>create an MS ACCESS database that contained =
"Link Tables" for each, even</FONT>
<BR><FONT SIZE=3D2>though I use SQL SERVER for all my other database =
functions. It's pretty</FONT>
<BR><FONT SIZE=3D2>easy to do, if a bit kludgey.</FONT>
</P>
<P><FONT SIZE=3D2>SQL SERVER also has a way to connect to external =
datasources through it's</FONT>
<BR><FONT SIZE=3D2>DATA TRANSFORMATION SERVICES area. I'm not as =
familiar with using STORED</FONT>
<BR><FONT SIZE=3D2>PROCEDURES to perform DTS actions or connect to =
other ODBC sources, so I use</FONT>
<BR><FONT SIZE=3D2>little MS ACCESS databases as my connection points =
between seperate ODBC</FONT>
<BR><FONT SIZE=3D2>datasources.</FONT>
</P>
<P><FONT SIZE=3D2>Peas.</FONT>
</P>
<P><FONT SIZE=3D2>B][A -- =DF=AE=EB=D1=D0=C5=F1 =E5V=CA=AE=A5 =
2.=D8</FONT>
<BR><FONT SIZE=3D2>The Open-Source Human Project</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://mediahorse.com/ba" =
TARGET=3D"_blank">http://mediahorse.com/ba</A></FONT>
<BR><FONT SIZE=3D2>[EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>323.402.1222.x7839 vm/fax</FONT>
</P>
<P><FONT SIZE=3D2>> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>> From: Jim Taylor [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>=
<BR><FONT SIZE=3D2>> Sent: Monday, March 20, 2000 1:09 PM</FONT>
<BR><FONT SIZE=3D2>> To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>> Subject: 2 different data sources</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> I hope this is not off topic!!</FONT>
<BR><FONT SIZE=3D2>> Is possible to have a query to 2 different data =
sources?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
--------------------------------------------------------------</FONT>
<BR><FONT SIZE=3D2>> ----------------</FONT>
<BR><FONT SIZE=3D2>> Archives: <A =
HREF=3D"http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk</A></FONT>
<BR><FONT SIZE=3D2>> To Unsubscribe visit</FONT>
<BR><FONT SIZE=3D2>> <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
st" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlist</A></FONT>
<BR><FONT SIZE=3D2>s/cf_talk or send a message to =
[EMAIL PROTECTED] with</FONT>
<BR><FONT SIZE=3D2>'unsubscribe' in the body.</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BF9983.1C63CC50--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.