|
Home > Archive > MS SQL Server > March 2006 > Creating a database with link
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Creating a database with link
|
|
| Michael R. Mastro II 2006-03-29, 3:23 am |
| Hello,
I am trying to figure out the best way to design a database that links to
external information like freedb.org and amazon, ect. I have created the
tables of the information I am looking for, but am wondering if I have to
create a table to link to those places to import the information in the
database I am trying to design. I think it is possible I have two seperate
questions in here. So I will try and breakdown to what I am looking for. I
have a database with specific information, I am looking for. I have media
that contains some, but not all of the information readily available to me.
Now what I want to do is take that bits and pieces of that information and
enter it into my current database and have it search other external
databases, to find the rest of the information and input that information
into my current database. Any help I would appreciate.
| |
| Jack Vamvas 2006-03-30, 3:23 am |
| 1)How are you connecting to the other databases ?
--
Jack Vamvas
____________________
_______________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Michael R. Mastro II" < MichaelRMastroII@dis
cussions.microsoft.com> wrote in
message news:3D1BEE16-A914-44D6-864A- 7B6289758826@microso
ft.com...
> Hello,
>
> I am trying to figure out the best way to design a database that links
to
> external information like freedb.org and amazon, ect. I have created the
> tables of the information I am looking for, but am wondering if I have to
> create a table to link to those places to import the information in the
> database I am trying to design. I think it is possible I have two
seperate
> questions in here. So I will try and breakdown to what I am looking for.
I
> have a database with specific information, I am looking for. I have media
> that contains some, but not all of the information readily available to
me.
> Now what I want to do is take that bits and pieces of that information and
> enter it into my current database and have it search other external
> databases, to find the rest of the information and input that information
> into my current database. Any help I would appreciate.
| |
| Michael R. Mastro II 2006-03-30, 11:23 am |
| Well I haven't connected to any other databases as of yet. But my
connections are set up for TCP/IP and Named pipes.
"Jack Vamvas" wrote:
> 1)How are you connecting to the other databases ?
>
> --
> Jack Vamvas
> ____________________
_______________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> "Michael R. Mastro II" < MichaelRMastroII@dis
cussions.microsoft.com> wrote in
> message news:3D1BEE16-A914-44D6-864A- 7B6289758826@microso
ft.com...
> to
> seperate
> I
> me.
>
>
>
|
|
|
|
|