You searched for the word(s): userid:853609

More Search Options

RSS Available

• Re: Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  Hi Jian, First I would like to thank you for your help. In regards to the first issue that I mentioned in this post where I was getting a "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: ..." I have found that all of the items you mentioned were as they should be but the problem remained. It was suggested that this is a known bug by Microsoft for which they have a hotfix

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/24/2009

• Re: Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  Okay it looks like I've found my solution. The issue with "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." error message for when my ASP.NET web site tries to add a record to my database was solved by setting the SQL Server instance to Log On as Local System in two places. First I opened the SQL Server Configuration Manager and right-clicked on SQL Server (SQLEXPRESS) service under the SQL

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/24/2009

• Re: Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  The only workaround that I've found thus far is to solve the " Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: ..." issue. The workaround is to uninstall the 64-bit version of SQL Server 2008 and then install the WoW (64-bit) version which apparently acts like a 32-bit version. I did this, and the issue has gone away. Now when I go to Visual Studio and right click

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/22/2009

• Re: Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  Thanks Naom, I had heard about this hotfix, but it seems that Microsoft wants to be paid for it, or at least they want to be paid for the priviledge of asking them for it! This is ridiculous. Does anyone have a copy of this "hotfix" that I can use, or perhaps a link that I can use to get it without the Technical Service fee to Microsoft? Thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/21/2009

• Re: Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  Hello Naom, Thank you for the thread. I did in fact try the solutions in it, but nothing seems to work for me. It seems that Vista x64, Visual Studio 2008, and SQL Server 2008 are ensnarled in some sort of unusable state. If there are any Microsoft experts that may lend a hand here I would really appreciate it very much.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/21/2009

• Re: Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  I have posted this issue on MSDN Forums in the SQL Server area. Hopefully I can make some progress there. I will report any solution I find either here or there. Thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/21/2009

• Cannot create a new SQL Server 2008 database in Visual Studio 2008.

  I tried asking this in another forum but have not yet gotten any response. I am working on Windows VISTA (x64) Ultimate SP2, with Visual Studio 2008 SP1 and I also have SQL Server (Express) 2008 installed. I recently upgraded from SQL Server Express 2005 to SQL Server 2008. This also required that I upgrade to IIS7, and so I did. When I try to work with my database files in the SQL Server 2008 Management Studio I have no problem at all. I can see and alter all tables, stored procedures etc., and

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 10/20/2009

• Re: SQL Server 2008 - |DataDirectory|

  Yes!! I am having this exact same problem! I cannot get Visual Studio 2008 to work with SQL Server 2008 (Express) regardless of what I do. I am working on VIsta x64 Ultimate sp2 and I have Visual Studio 2008 with sp1 installed. In Visual Studio 2008, when I right click my app's App_Data folder and choose "Add New Item>SQL Database" it gives me this error. Has anyone found a solution, I've been reading about this for 2 days and I cannot find a answer. Please help!! - George

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by opcode901 on 9/27/2009

• Re: Failed to generate a user instance of SQL Server

  I am having this same problem, and it seems that this forum is close to helping everyone find an answer. I am working on VISTA .x64 Ultimate SP2, with Visual Studio 2008 SP1 and I also have SQL Server (Express) 2008 installed. I upgraded from SQL Server Express 2005. In the SS Management Studio I can access all of the databases as required, including the problematic one called BOI_DB (BOI_DB.mdf), without any issues. I can also see all tables, sp etc., and edit any of them as desired, again without

  Posted to Visual Web Developer 2005 Express (Forum) by opcode901 on 9/27/2009

• Re: Am I making memory leaks?

  The reason you're getting that error in the finally statement is because the compiler must make sure that the objStreamReader is instantiated. In your code, it is instantiated, but only under certain conditions. A solution is to instantiate it, and assign it to null. Then go into your switch statement. StreamReader objStreamReader = null ; try { ... } catch (...) { } finally { if (objStreamReader != null ) { objStreamReader.Close(); objStreamReader.Dispose(); } } Although a better solution is

  Posted to Getting Started (Forum) by opcode901 on 2/5/2009