Connect to internal SharePoint database from web site.

Hello,
There's information on my Internal SharePoint DataBase that I want to access. How can I do this? Could you help me or at least point me in the right direction.

The information I am requesting is just text.

Thank you,
Mark

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was accessing the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0), and install it. The help file in the SDK has alot of sample code that we can use.

Happy coding :)

|||

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was access the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0) are available. There are alot of sample code that we can use.

Happy coding :)

|||

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was accessing the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0), and install it. The help file in the SDK has alot of sample code that we can use.

Happy coding :)

|||

I am starting to see this now. Thank you for your response.

Configure SQL XML support in IIS

I have configured SQL XML Support in IIS but still i am not able to Use

http://localhost/ss?Sql=select+*+from+users+for+xml+auto

I am getting Internal Server Error

Hi, if you're sure that the SQL XML Support in IIS has been configured correctly, you can try to add a root element for your output:

http://localhost/ss?sql=select+*+from+users+for+xml+auto&root=users

You can refer to this article for configuring virtual directory for SQLXML:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_2xvd.asp