|
|
Post by Andreas Kviby on Jun 24, 2008 14:14:47 GMT -6
Is there any risk by writing directly to the database where the Sharepoint-lists are stored?
I am doing a sms reporting system and I need to store the incoming sms messages inside sharepoint in a custom made list and I can not find any good webpart to do this so I tried to write directly to the tables but need someones approval that this can be done without risking the database integrity or something else.
|
|
|
|
Post by Jay Mueller on Jun 24, 2008 16:34:44 GMT -6
Is there any risk by writing directly to the database where the Sharepoint-lists are stored? I am doing a sms reporting system and I need to store the incoming sms messages inside sharepoint in a custom made list and I can not find any good webpart to do this so I tried to write directly to the tables but need someones approval that this can be done without risking the database integrity or something else. Yes, it's against Microsoft best practices and will also void your warranty for support. The best thing here is to pull the data out of the SharePoint databases into another table or write your data to another table and use web parts to collect it. |
|
|
|
Post by Andreas Kviby on Jun 29, 2008 1:53:08 GMT -6
Okey so I had to learn to program and store directly through the webservices instead which actualy worked great so now I can store information in lists from any .net based app I am developing.
|
|
|
|
Post by Jay Mueller on Jul 1, 2008 8:21:53 GMT -6
Okey so I had to learn to program and store directly through the webservices instead which actualy worked great so now I can store information in lists from any .net based app I am developing. This is very cool and I often get alot of questions about how MOSS can consume web services of other .Net based apps and vis versa. You should write a Wiki article on how to do so. |
|
|
|
Post by Andreas Kviby on Jul 2, 2008 2:39:22 GMT -6
Two new wikis are now online on reading and writing to and from sharepoint.
|
|
|
|
Post by Jay Mueller on Jul 2, 2008 6:35:51 GMT -6
Two new wikis are now online on reading and writing to and from sharepoint. Nice work ;D! |
|
