How to link SQL table and SharePoint list?

Please advise on how to link SQL table and SharePoint list?

Thanks,
Speedy

Gary
Tue Aug 30 06:06:42 CDT 2005

What are you trying to do? BTW, it is considered bad to access the SQL
tables directly and since there is a full object model and web services most
of the time you should not need to.

--
Gary A. Bushey
SPS MVP
bushey@mindspring.com
"speedy" <speedy@discussions.microsoft.com> wrote in message
news:EB365A83-F168-434B-9A09-137E094FB47C@microsoft.com...
> Please advise on how to link SQL table and SharePoint list?
>
> Thanks,
> Speedy

speedy
Tue Aug 30 07:30:29 CDT 2005

I can link table in Access databases with SharePoint list. I would like to do
the same thing from SQL database, so I can have data available in SQL server
for further filtering and creating relationships with other tables.

Please help!

If this approach is wrong, please advise what approach should I use and
please provide links to resources and references.

Thanks,
Speedy


"Gary A. Bushey [SPS MVP]" wrote:

> What are you trying to do? BTW, it is considered bad to access the SQL
> tables directly and since there is a full object model and web services most
> of the time you should not need to.
>
> --
> Gary A. Bushey
> SPS MVP
> bushey@mindspring.com
> "speedy" <speedy@discussions.microsoft.com> wrote in message
> news:EB365A83-F168-434B-9A09-137E094FB47C@microsoft.com...
> > Please advise on how to link SQL table and SharePoint list?
> >
> > Thanks,
> > Speedy
>
>
>

Gary
Tue Aug 30 08:23:44 CDT 2005

OK, I see what you want to do now. I do not think this is possible.

--
Gary A. Bushey
SPS MVP
bushey@mindspring.com
"speedy" <speedy@discussions.microsoft.com> wrote in message
news:89D52BEF-A371-4F21-845E-A5CAB5E31549@microsoft.com...
>I can link table in Access databases with SharePoint list. I would like to
>do
> the same thing from SQL database, so I can have data available in SQL
> server
> for further filtering and creating relationships with other tables.
>
> Please help!
>
> If this approach is wrong, please advise what approach should I use and
> please provide links to resources and references.
>
> Thanks,
> Speedy
>
>
> "Gary A. Bushey [SPS MVP]" wrote:
>
>> What are you trying to do? BTW, it is considered bad to access the SQL
>> tables directly and since there is a full object model and web services
>> most
>> of the time you should not need to.
>>
>> --
>> Gary A. Bushey
>> SPS MVP
>> bushey@mindspring.com
>> "speedy" <speedy@discussions.microsoft.com> wrote in message
>> news:EB365A83-F168-434B-9A09-137E094FB47C@microsoft.com...
>> > Please advise on how to link SQL table and SharePoint list?
>> >
>> > Thanks,
>> > Speedy
>>
>>
>>