Software

Ask something
Question Locked

SharePoint 2007 and SQL Database

0 helpful
11 replies

by steffi28

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

Im looking for a way to have an SQL Database in SharePoint 2007, preferably without programming. I dont know if this is possible.

Basically what I want to do is to have a web page connected to the database so that if any information is changed in the database it will automatically change in SharePoint and vice versa.

Ive had a look through SharePoint and cant seem to find a way to do this and scrawling through the MS website hasnt helped either so if anyone can give me any tips or point me to somewhere where I can find the information I need Id be extremely greatful.

Thanks

Edited to add, I think its something to do with the Business data web parts if im on the right line then let me know :)

11 replies

by dan powers

I was looking from something similar but never had much luck. What I ended up with was adding a page viewer web part that looked at an excel file. When individuals updated the excel spreadsheet that data was viewable on our portal. Not SQL but it works well and is effective.

by steffi28

but unfortunatly I cant persuade the company Im working for to transfer about 25gb of SQL databases to Excel, so that ideas out the window lol.

But thanks anyway. I think im on the right track with the business data web parts though. I just cant seem to find what to do with them lol.

by yadnesh.cts

I am having the problem that is similar to what you are facing...

But in my case i want to understand how the Sharepoint Site and SQL server 2005 works simultanously.....need to know he workflow .
Please share the knowledge if you have.

Your help will be gratefull

Thanks and Regards,
Yadnesh
yadnesh.cts@hotmail.com

by steffi28

If you follow the link I've posted there are a few links from there that I've found helpful. I hope you find what you need.

by agus.bagus

Hello Steffi and all experts, I followed the link but i could not find the solution there.
My problem looks simple. I am running wamp server, to run PHP script and mysql. For now all my data is stored in my local harddisk. I would to save the data to SharePoint, so that everytime i save data, it will be saved on Sharepoint, also the same if i want to view the data, its generated from Sharepoint. So no data in my local harddisk.
Is it possible?
Pls give me an advice.
I am not a proggamer, really appreciate step by step guide.
Thanks in advance...

Agus

by mkatten

I too am interested in hearing a solution to this problem. Could you please be sure to post what you find out, even if it is not through this site?

by haunsone

You can easily create a ASP.Net website that connects to your SQL database that can be programmed to Retrieve Records, Update Records, Insert Records or even Delete Records.

One you have created your site, you can add it to SharePoint (MOSS 2007) by adding a Web Part to what ever site you want, the Web Part to do this is the (Page Viewer Web Part). All the functionality that is designed into your ASP.Net pages will work perfectly.

One other item to remember is IIS, you must configure your web site in IIS which is easy to do.

Good luck.

REH

by jaber26

i used the link that mention above but it doesn't work.

could you please give me onther link.

i have the same problem i can't solve.

thanks, best rgardes

This discussion is closed to new replies.