Creating Database

I have a question that I am hoping someone can answer. Is it possible to
link external sources to a database? What I am wondering is, that if I am
creating a music database for CDs, can I program it so that the database
will collect data from something like Windows Media Player or an external
website? Now I would be doing this with SQL 2005. Any help or thoughts
about this would be appreciated.
Michael R. Mastro II
Are you talking about , consuming feeds or saving web pages?
If so , it's definately possible to consume feeds . Where it gets a bit more
interesting , i sif you are doing loads of string manipulations on the fly
to isolate the information you need. You may be better off , doing all the
getURL in Java or .Net , and then storing all relevant information in the db
Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITjobfeed.com
"Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
news:%23MYHZiCaHHA.5044@.TK2MSFTNGP05.phx.gbl...
>I have a question that I am hoping someone can answer. Is it possible to
>link external sources to a database? What I am wondering is, that if I am
>creating a music database for CDs, can I program it so that the database
>will collect data from something like Windows Media Player or an external
>website? Now I would be doing this with SQL 2005. Any help or thoughts
>about this would be appreciated.
> Michael R. Mastro II
>
|||I would say probably consuming feeds. What I am actually trying to do is,
say I stick a CD in the computer. It brings up Media Player or whatever
program, maybe Musicmatch, but the point is, the program brings up all
relevant information about that said CD. What I want to do is take that
information from the program and store it in SQL 2005.
Michael R. Mastro II
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:NL-dnUT3PrImMmbYnZ2dnUVZ8qminZ2d@.bt.com...
> Are you talking about , consuming feeds or saving web pages?
> If so , it's definately possible to consume feeds . Where it gets a bit
> more interesting , i sif you are doing loads of string manipulations on
> the fly to isolate the information you need. You may be better off , doing
> all the getURL in Java or .Net , and then storing all relevant information
> in the db
> --
> Jack Vamvas
> ___________________________________
> Advertise your IT vacancies for free at - http://www.ITjobfeed.com
>
> "Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
> news:%23MYHZiCaHHA.5044@.TK2MSFTNGP05.phx.gbl...
>
|||"Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
news:%23MYHZiCaHHA.5044@.TK2MSFTNGP05.phx.gbl...
>I have a question that I am hoping someone can answer. Is it possible to
>link external sources to a database? What I am wondering is, that if I am
>creating a music database for CDs, can I program it so that the database
>will collect data from something like Windows Media Player or an external
>website? Now I would be doing this with SQL 2005. Any help or thoughts
>about this would be appreciated.
>
Well a database is just that, a database. It really doesn't "collect data".
For that you need a separate app between the database itself and the one you
want to collect data from.
Having said that, what you want to do shouldn't be all that hard with some
programming.

> Michael R. Mastro II
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com
|||So what parameters would you need to set within the database to program it
in such a way?
Michael R. Mastro II
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:uFgBlMNaHHA.596@.TK2MSFTNGP06.phx.gbl...
> "Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
> news:%23MYHZiCaHHA.5044@.TK2MSFTNGP05.phx.gbl...
> Well a database is just that, a database. It really doesn't "collect
> data". For that you need a separate app between the database itself and
> the one you want to collect data from.
> Having said that, what you want to do shouldn't be all that hard with some
> programming.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>
|||Hi,
One way is to write a program that runs as a services and monitor for
windows media player. What I do not know is, weather it is possible to read
the data that is loaded into windows media player. If that is possible then
your program can take that data and update the SQL server.
Regards,
Kueh
"Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
news:%23pm$8DWaHHA.4888@.TK2MSFTNGP06.phx.gbl...
> So what parameters would you need to set within the database to program it
> in such a way?
> Michael R. Mastro II
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:uFgBlMNaHHA.596@.TK2MSFTNGP06.phx.gbl...
>
|||"Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
news:%23pm$8DWaHHA.4888@.TK2MSFTNGP06.phx.gbl...
> So what parameters would you need to set within the database to program it
> in such a way?
>
I don't think anyone else replied either.
It's not a matter of setting parameters within the database.
Select your language and write the program in that. Could be perl, VB, C#,
etc.
The database is simply a repository for the data in this case.

> Michael R. Mastro II
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:uFgBlMNaHHA.596@.TK2MSFTNGP06.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html