Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Connecting sql 2000 with SPSversion1

  Asked By: Guy    Date: Aug 26    Category: Sharepoint    Views: 906

my thesismates and i have a hard time connecting sql 2000 with
SPSversion1, i already asked it before and as far as i can remember most of the
replies pointed me to using digitaldash but then our work is only a proposal to
the company so we are thinking of ways on how to reduce the intended costs of
our project. Now, is there any way that we can access or manipulate data from
the database of SPS without us needing to use sql, my group is not really
familiar with xml codes we are more into ASP and VBscript... since we dont know
how to access the DB of SPS, what we did with other data that should be stored
is we added a link in sharepoint that directs the admin to another page that
uses ASP to connect with sql.... i think this scenario might pose future
problems in the company... any suggestions?

in short, how do we access the storage system of SPS in order for us to
manipulate its content? if accessing it is not possible, what are other ways
(except using digitaldash) to connect sql2000 with spsversion1 in such a way
that when users search for particular files in sharepoint, results can be
extracted either from the DBase of SPS or from SQL?

we are a greenhorn to sharepoint thats y we are begging for your professional
advices...

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Jerod Carrillo     Answered On: Aug 26

It seems to me you may need to be more specific in your question to get more
specific answers.

In response to your "in short" paragraph:

You may get reference vbs codes from sites like www.sharepointcode.com to
see how you can use ASPand VBScript to "access the storage system of SPS in
order to manipulate its content".

But I don't understand why "when users search for particular files in
sharepoint, results can be extracted either from the DBase of SPS or from
SQL". If you are searching files in sharepoint why results be extracted from
SQL?

You mentioned "what we did with other data that should be stored is we added
a link in sharepoint that directs the admin to another page that uses ASP to
connect with sql". Have you check out the capability of webparts in SPS? You
may develop webparts in VBScripts or even display output of ASP webpages in
SPS.

I am worry that you have an incorrect modeling concept of what you want to
do. How about you specify in more details about what you want to do say in a
process perspective rather than just saying connecting  SQL2000 with SPS
Version 1?

 
Answer #2    Answered By: Hema Pasupuleti     Answered On: Aug 26

Maybe I should let you know that SQL 2000 and SPS v1 do not work
together in the way you might think. SPS v1 uses WSS (Web Storage
System), which is an exchange-based database. SPS v2 (officially known
as Office Sharepoint Server 2003) uses SQL 2000 as a storage mechanism.
SPS sits on top of a different WSS (Windows Sharepoint Services, which
is the successor to Sharepoint Team Services, or STS) to provide portal
functionality.

If you want to access the data stored in Sharepoint v1, then you should
read Chapter 6 of Microsoft Sharepoint Portal Server - Building
Knowledge-Sharing Applications by Laahs, McKenna and Vickers. It has
lots of good info and they use a bit of humor in their writing. The
chapter is entitled "SPS and the Exchange Store"

In short, you can use XMLHTTP to access store data via client-side apps,
and CDO/ADO for server-side (for use in .asp) You'll also want to read
up on PKMCDO, MSDAIPP, and WEBDAV.

 
Didn't find what you were looking for? Find more on Connecting sql 2000 with SPSversion1 Or get search suggestion and latest updates.




Tagged: