Very Computer

Which is the right file? & best way to connect to it?
does anyone know a good source for linking into the SQL database to
use it outside of sharepoint?
Thanks
Jeanne

--
Dustin Miller, President
FuseWerx LTD
http://www.fusewerx.com/
ColdFusion, ASP, .NET and SharePoint Consulting

Was this post helpful?  Click below and let me know!
http://www.fusewerx.com/helpful.cfm

Quote:> I am trying to link to my sharepoint sql database to use the Frontpage
> database results wizard.
> Is there any info on what file to connect to? I look at my SQL
> directory & see the following files:
> "servername_LM_W3SVC_1_Collab.mdf" up thru
> "servername_LM_W3SVC_9_Collab.mdf"

> Which is the right file? & best way to connect to it?
> does anyone know a good source for linking into the SQL database to
> use it outside of sharepoint?
> Thanks
> Jeanne

I imagine that I am answering this question. One of the SPTS newsgroup FAQ
items shows how to create a .asp page to access the SPTS SQL database and
produce a list of the results of the access.

In my case I've added these .asp pages as hidden pages on the SPTS site so
that only I can access this info, but there's nothing stopping you using
this kind of code outside the SPTS site.

The code is in the FAQ2 under III.13 How do I write code to extract data
from the SPTS database ?

Mike Walsh
Helsinki
Finland

Quote:> I am trying to link to my sharepoint sql database to use the Frontpage
> database results wizard.
> Is there any info on what file to connect to? I look at my SQL
> directory & see the following files:
> "servername_LM_W3SVC_1_Collab.mdf" up thru
> "servername_LM_W3SVC_9_Collab.mdf"

> Which is the right file? & best way to connect to it?
> does anyone know a good source for linking into the SQL database to
> use it outside of sharepoint?
> Thanks
> Jeanne