Adding DataBase to Project
-
Hi, I have installed VS 2008 and SQL Server 2008 Enterprise edition. I basically want to add my database to my website. in the App_Data folder right click and find my database(.mdf). the problem is after hitting enter I got this error.(Access Denied) does any one has any solution,pleas.
-
Hi, I have installed VS 2008 and SQL Server 2008 Enterprise edition. I basically want to add my database to my website. in the App_Data folder right click and find my database(.mdf). the problem is after hitting enter I got this error.(Access Denied) does any one has any solution,pleas.
SQL Server Enterprise? You're running a server OS on your development machine? All you need is SQLExpress. If you look at the machine.config you will see the default connection string is to a SQLExpress instance.
I know the language. I've read a book. - _Madmatt
-
Hi, I have installed VS 2008 and SQL Server 2008 Enterprise edition. I basically want to add my database to my website. in the App_Data folder right click and find my database(.mdf). the problem is after hitting enter I got this error.(Access Denied) does any one has any solution,pleas.
Assuming that you have to attach the mdf as a static file in your project due to licensing on the SQL Server or for some other reason can't deploy the MSSQL server to your deployment environment, you should perhaps look into using SQLLite and not MSSQL. Clickey
I wasn't, now I am, then I won't be anymore.
-
Assuming that you have to attach the mdf as a static file in your project due to licensing on the SQL Server or for some other reason can't deploy the MSSQL server to your deployment environment, you should perhaps look into using SQLLite and not MSSQL. Clickey
I wasn't, now I am, then I won't be anymore.
thanks for your reply, guys. i have done the following steps: I installed VS2008 and MSSQL2008; I design database and its table in SQLServer2008. I don't installed SQLExpress. now, I am developing an MVC Web Application; the problem is when right click in App_Data folder and choose existing item to add the created database in SQLServer2008, get this error: Access Denied. Could you please tell me what is the problem? is there any solution to remove fix this error without installing SQLExpress?
-
thanks for your reply, guys. i have done the following steps: I installed VS2008 and MSSQL2008; I design database and its table in SQLServer2008. I don't installed SQLExpress. now, I am developing an MVC Web Application; the problem is when right click in App_Data folder and choose existing item to add the created database in SQLServer2008, get this error: Access Denied. Could you please tell me what is the problem? is there any solution to remove fix this error without installing SQLExpress?
SQl Express is not an answer. Your problem is that you cannot connect a db the way your are trying to. You have to create objects that connect with the SQL Server. You are getting Access Denied because SQL Server owns and controls the file.
I wasn't, now I am, then I won't be anymore.
-
SQl Express is not an answer. Your problem is that you cannot connect a db the way your are trying to. You have to create objects that connect with the SQL Server. You are getting Access Denied because SQL Server owns and controls the file.
I wasn't, now I am, then I won't be anymore.
Hi, I create an ODBC Driver and find my databse; in VS2008, in Server Explorer I add my database(ODBC.Dell.Test) I just get confuse; in MVC I have to add my database in App_data(is it true?)if yes, how? because, again when I add that object get the same problem(Access Denied)