My question: it is possible with WSS to create list items that can
query an external database on our SQL server?

Re: WSS SharePoint lists to pull from SQL table? by Callahan

Callahan
Wed Aug 20 22:08:11 CDT 2008

Not that I know of. WSS lists are isolated to their content databases.
There is hardly any connection between other lists on the same site, never
mind being able to query external databases on the SQL server.

However, maybe someone with l33t developer skills might've come up with a
web part that makes it possible...

-callahan
"Mike" <mikeclifton82@gmail.com> wrote in message
news:98bc0b33-9c27-4974-8e9c-bae12b8fa15f@d1g2000hsg.googlegroups.com...
> My question: it is possible with WSS to create list items that can
> query an external database on our SQL server?



Re: WSS SharePoint lists to pull from SQL table? by galvin

galvin
Fri Aug 22 09:37:46 CDT 2008

On Aug 20, 11:26=A0am, Mike <mikeclifto...@gmail.com> wrote:
> My question: it is possible with WSS to create list items that can
> query an external database on our SQL server?

Do some searches for "data view web part" "data form web part" "DVWP"
and "DFWP".

That's as close as you get without diving into C#/VB and the object
model.

--Paul Galvin, EMC (formerly Conchango)
Microsoft MVP - SharePoint
RSS @ http://feeds.feedburner.com/PaulGalvinsSharepointSpace
Web site @ http://paulgalvin.spaces.live.com
Twitter @ http://twitter.com/pagalvin (I follow anyone who follows
me)

Re: WSS SharePoint lists to pull from SQL table? by chamildz

chamildz
Mon Aug 25 12:09:57 CDT 2008

Hi Mike,

Of course you can use event handlers for this.

"Mike" <mikeclifton82@gmail.com> wrote in message
news:98bc0b33-9c27-4974-8e9c-bae12b8fa15f@d1g2000hsg.googlegroups.com...
> My question: it is possible with WSS to create list items that can
> query an external database on our SQL server?