Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 I can´t acces my database from ASP.NET aplication

Author  Topic 

Ra2ven
Starting Member

1 Post

Posted - 2009-07-11 : 13:37:51
Hello,

i tried to made a ASP.NET aplication (whit Web Developer 2008 express) that uses a database, but i only can use it if I attach a copy to App_data directory (im using IIS in my computer as server).
The problem is that if a make any change to the database it only affects the local attached database, and the original not.

I created the database whit SQL Management Studio but if I use this database directly (whitout a copy in App_Data) I obtain an error when I load the webpage. Its like I haven´t permissions enough to access the database in SQL server directly (or i don´t know)... but I made a similar aplication in Visual Basic 2008 Express and I dont have problems to load, update, etc. the database in SQL server directly whitout made a copy in the project local route.

Another problem I have is that I can´t access the same database whit both applications (VB 2008 Express and Web Developer 2008 Express) running at the same time (it tells me that database is using by the another). I need it to update the database from the local PC or internet respectly.

I enabled all the protocols (tcp/ip, Via, etc. and shutdown the firewall.

Thank you

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-07-14 : 04:43:52
lets see your connection string ?

you can see examples here www.connectionstrings.com
Go to Top of Page
   

- Advertisement -