Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to SQL Server Express in asp.net 2

Status
Not open for further replies.

stevet26

Programmer
Feb 9, 2005
53
Hi

I have set up a solution in visual web developer 2005 express which is made up of three projects.

Website
Admin (sub directory of website)
Memebers (Sub directory of Website)

Now all three of these project need to share the same database, however is this possible using SQL server 2005 express?

The reason I ask is that the book I have says that you have to create the MDB file in the app_data folder and use that. However if i do this for each projets app_data folder I will not be able to share the same databse.

So I was wondering whether I have to follow this process or whether I can just set up a database in SQL server Express and link to the intance of the server.

I am stuggling to find any example of where multiple projects in the same solution can share the same database. So, any pointers will be much appreciated.

Thansk in advance
Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top