.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

VS 2010 MSSql 2008, ASP.net and Win 7

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :ASP.Net
What is all the confusion about this combination of software?  Thsi appears to be the latest versions and one would think that it would also be the most up to date versions to use with the latest OS.  But I cannot find out where to learn how to use the tools because there does not appear to be any lessons oor tutorials free or paid that provide the latest releases of these tools.  I cannot get a demonstration of installation or a how to use that matches what I have on my system.  This just does not make any sense for this to be this obtuse.  I started out trying to learn ASP.NET and I have found myself in a quaqmire of installation issues operation issues,  warinings etc and yet no definitive tool for learining how to use the latest versions.  Can some one tell me where to go I do not mind paying for a tutorial or course that will get me aquainted with the technology.  AS it is I become more confused at each corner.  I can see  why many people just go with PHP and MYSQL with WAMP SERVER or XAMP.  This is border line ridiculous is this the future of this " powerful technology"?Hoping for the best, MIKE E

View Complete Post

More Related Resource Links

No dim as database for Access 2010 project with MSSQL 2008 r2 developer


I am trying to populate some tables in a MSSQL 2008 database using a VBA module an Access project. I can create Access forms that update the MSSQL tables, and access the MSSQL tables directly.

I used similar code with earlier Access and MSSQL. When I try to dimension an object as database,  no such method is in the list, and an error occurs when I try to run. I can't create a recordset until I have a data object.

The MSSQL is 64 bit, and the Access 2010 is 32 bit.


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project


my current project references




i have a very annoying iis problem

iis server stops working until app pool is recycled


i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem


How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


WPF Designer (in VS 2008 and VS 2010) crashes with Visual Studio

Good day all. I have the following question: WPF designer in both VS 2008 and VS 2010 crashes with Visual Studio when I try to edit UI form. Moreover, it crashes even when I try to save .xaml.cs file. Meanwhile, Winforms and Dataset UI editors work as usual. Are there other people met this issue? And how could I fix up this problem? Deleting the .suo file, uninstalling silverlight, repairing visual studio, and further googling did not help me. Thanks in advance.

MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

SQL 2008 Express with advanced services and Visual studios 2010

Hi could someone please help me. Im running the following software: SQL 2008 Express R2 with advanced services Visual Studios 2010 Ultimate   I am trying to using Sql in Visual studios to use full text indexing but I am attaching a database that already exists. My problem is that I can use the full text indexing? I had it working once but then when i tried to FREETEXT search through my table it said that I didn't have an index on that table when I know I do cause I went to make sure. I think that perhaps its referencing the wrong database because I cant seem to add the database into my project? I am so confused as to how SQL express instances work so not sure what I am doing wrong? PLEASE HELP? 

Visual Studio 2010 - SQL 2008 or SQL 2008 R2

I have just rebuilt my development platform i.e. I ran the Windows 7 Ultimate setup app on an X86 platform followed by a fresh install of Visual Studio 2010 Prof. Using VS I opened up a solution created before the rebuild which includes a connection to an .mdf file. On attempting to connect to this file I Got an error message of the  follwing type. The database '.../XXX.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Referring to this link http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/0a4082a2-793e-42c3-9f68-95041002b4de, leads me to believe that VS2010 uses SQL Express 2008 for database access and that I had been using(unknowingly) SQL Express 2008 R2 during my previous development activities. If that is the case two questions arise :- Why does VS2010 install package install the four 2008 R2 components when I presume that these would also be incompatible with SQL Server Express 2008? Is there a version of SQL Server 2008 R2 - since I assume that R2 is the latest and greatest version - that I can install on my machine and if so how do I tell VS to use 2008 R2 rather than plain old 2008? I hope these questions do not seem like the meanderings of a raddled brain, but any light you can throw on them, would help me gain a better understanding of the relationship bet

Importing Access 2010 tables to SQL Server 2008 R2

I'm trying to import a series of Access 2010 tables to Sql Server 2008 R2.  The Access import drivers are for *.mdb (which if I recall was the file extension for Access when I was a kid, and don't recognize the .accdb file extention).  Similarly, the Excel driver is for Excel 2003.  Isn't there a driver and method to import directly to SQL 2008 from Access 2010? SQL is installed on my server, but Access is not installed on the server.  When I copy the file onto the server and try and open it directly into SQL, I get a 'no editor installed' error. I can't get the 'upsize' wizard to work becuase it won't open the connection to SQL, even though I enter the userid and password of the SQL DB owner.  I get the following error: ===================================================== Connection failed: ============================================================= I have to say I'm stumped.  The rest of the Office 2010 suite works really well together - perhaps I'm missing something very simple? Thanks!     I guess I could export my tables as Excel 2003 and then import them using Integration Services, or install SQL Express on my laptop and 'upsize' to that instance, but SQL State: ‘0100’ SQL Server Error: 11004 [Microsoft][ODBC SQL Server Dirver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection failed: SQL

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

Extended stored procs on 64 bit MSSQL 2008

We need to develop some extended stored procedures for 64-bit SQL Server 2008. We have written the DLL in Visual C++ but when we try to register it with the database, we see the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xp_test.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15105).(42000,17750) Procedure(xp_test) Can anyone please tell me if you have come across such an issue and how it was successfully resolved? 

SP 2010 and Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition

Hello,Will it be possible to install SharePoint 2010 on Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition?Thanks

SQL 2008 Standard Licence for Sharepoint 2010 foundation

Hello! We want setup sharepoint 2010 foundation with an SQL 2008 Standard. The expected amount of data are about 40 GB or more. This the reason why we can't use SQL Express 2008 R2. What Licencemodel is necessary ? - Do we need an Processorlicence, is concurrent ok or need only the Sharpoint Server a Licence for access the database. thank's in advance Christian  

Procedure to move all SP 2010 databases from SQL 2005 to SQL 2008 R2

I have a single SharePoint 2010 WFE with a single SQL 2005 64-bit backend.  I need to decomission the SQL 2005 server.  What is the best procedure to move all the SharePoint associated databases to SQL 2008 R2? I have already read this MS doc on moving all databases: http://technet.microsoft.com/en-us/library/cc512725.aspx So the actual move procedure is standard SQL fodder. What I'm not clear about is what to do about the "other" SharePoint databases and how to reassociate them once the DBs are on the new SQL server.  For example, the Usage and Health DB is going to "Wss_Logging" and it specifies my old SQL server.  It is greyed so I cannot chagne it in Central Admin.  How do I let SharePoint know that these databases have been moved too?

How to export data from SQL 2008 R2 to excel 2010

Hi, I am using microsoft sql 2008 R2 express server and I have window 7 64 bit and office 2010.  I would like to export data form sql to excel using a query in sql.  I tried a few examples I found on the web, but they don't work.  Please help. Thanks

Upgrading to SharePoint 2010 Foundation on SBS Server 2008

Hi all, I've just tried to install SharePoint Foundation on 2010 on Windows Small Business Server 2008 and whilst the literature I've found suggests that this is supported, I receive the following error: SharePoint 2010 Products cannot be installed in Stand-alone mode on a Domain Controller.  For more information on upgrading, see http://support.microsoft.com/?kbid=975805. What's funny about the KB ID, is that it doesn't exist.  The pre-requisites for SharePoint 2010 Foundation installed OK and the SharePoint installer has detected that it will perform an in-place upgrade.  the STSADM -o preupgradecheck output is below. Any idea's?  It would be really great if we could start using the shared workspace and ribbon features that are inherent with SPF2010. Jason.  

HTTP 500 After Sharepoint 2010 Install on Win 2008 R2

Environment specifics: Windows 2008 R2 SQL 2008 (Version: 10.0.2746.0) No internet connection so I installed all the prerequisite software. I have two domain accounts: SPAdmin and SPFarm SPAdmin is what I use to install Sharepoint. SPFarm runs the app pool, timer service etc. Domain: Development domain. Scenario: After the SP Setup Wizard, Central admin is inaccessible and gives a HTTP 500 error. I checked the recommended permissions for both accounts and they both appear to be in the correct groups. The only way I can get it to work is to add the SPFarm account as a local admin. So it appears to be a permissions issue. But I can't figure out what the issue is or even where to start. Any advice would be greatly appreciated.

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend