Linking Lists and SQL server

Hi,

I would like to know if there is a way to link a list to a SQL server and by
updatign the list info the table in SQL server get updated as well. Is this
possible?

Thanks,

Engelbert
Mon Feb 20 10:44:51 CST 2006

> updatign the list info the table in SQL server get updated as well

That's what happens in standard WSS ...

so I presume I'm misunderstanding the question. Can you clarify ?

Engelbert

"Bob" <Bob@discussions.microsoft.com> wrote in message
news:751DB85F-F3A5-4B91-A0FA-17B720D66E3F@microsoft.com...
> Hi,
>
> I would like to know if there is a way to link a list to a SQL server and
> by
> updatign the list info the table in SQL server get updated as well. Is
> this
> possible?
>
> Thanks,

Bob
Mon Feb 20 12:40:29 CST 2006

You know you can link an access database to a list and any data you entered
in your list would get updated in your access table as well. I would like to
do the same thing. I would like to have a table in SQL separated from the
default SQL which is running my WSS site and perhaps on another SQL server
all together for a list and the columns in my table would be the same as in
my list and any data users enteres in the list would get transfer and
populate my table as well.


"Engelbert" wrote:

> > updatign the list info the table in SQL server get updated as well
>
> That's what happens in standard WSS ...
>
> so I presume I'm misunderstanding the question. Can you clarify ?
>
> Engelbert
>
> "Bob" <Bob@discussions.microsoft.com> wrote in message
> news:751DB85F-F3A5-4B91-A0FA-17B720D66E3F@microsoft.com...
> > Hi,
> >
> > I would like to know if there is a way to link a list to a SQL server and
> > by
> > updatign the list info the table in SQL server get updated as well. Is
> > this
> > possible?
> >
> > Thanks,
>
>
>

adam
Mon Feb 20 19:33:22 CST 2006

This would be near improbably to accomplish using any OOB webparts,
since data views only allow a read forward method to the data. You are
better off just writing some quick stored procs or something
dependening on the exact requirement, I can put together a quick
example if you like.

Adam Buenz
http://www.cyberlaundering.com

Bob
Tue Feb 21 09:06:48 CST 2006

Adam,

I would appreciate if you can show me an example.

Regards,

"adam@sharepointsecurity.com" wrote:

> This would be near improbably to accomplish using any OOB webparts,
> since data views only allow a read forward method to the data. You are
> better off just writing some quick stored procs or something
> dependening on the exact requirement, I can put together a quick
> example if you like.
>
> Adam Buenz
> http://www.cyberlaundering.com
>
>