.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

problem with displaying all records in SQL 2008

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hi Guys,

I used to excute the below SQL Statement with SQL 2000 and when i removed the 2000 and Installed the SQL 2008 not all the data appeared in the report, Is there anything else should I do?

The SQL Statement is :

      If conn.State = ConnectionState.Closed Then

 conn.ConnectionString = "Provider=SQLOLEDB;server=" & Srvrname & ";database=Att;user id=sa;pwd="
      End If
    Catch ex As OleDb.OleDbException
      MsgBox("Server is not Responding", MsgBoxStyle.Critical, "ATS")

    End Try


View Complete Post

More Related Resource Links

Crystal Report vs 2003 convert to vs 2008 parameter problem


Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??

Does someone can help me solve this problem??

Thank you

Problem when displaying a popup window

Hi all,
I am working on a project in which when I clicked a hyperlink a pop up window has to be displayed for 2 pages.
But at first when i did this in javascript it worked, later after i finished the whole coding suddenly an error box displayed that there is an error in webpage and want to debug

Problem in Installation of SQL Server 2008


Dear All,

I have Sqlserver2008 setup.

It is work in wndows Xp.

But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.

Plz some buddy can help the same.


Rakesh gupta

Problem opening dotnet 1.1 projet on 2008 web server


 We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server.  I can host them and they work.  My problem is that when I try to open one in VS 2003 I get the following error.  I set up the web server the same as my previous one, and I think a long time  ago I got this error when we set up current one but do not remember how to resolve it.  So I moved my project files from the old server to the new server and then I get these errors. 


The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error

Problem adding .NET 3.5.1 feature on Server 2008 R2

Having an issue with a 2008 R2 64-bit Server becoming unresponsive/locking up when trying to activate the .NET 3.5.1 feature.  Did not have any previous version of .NET installed but ran the .NET Cleanup utility and completed successfully but still have same issue.  It installed .NET 4 via the Microsoft Updates OK but still hangs part way through the 3.5.1 install via the Server Manager/Add Features.  Any ideas?  Thanks!

Deploying problem with SQL Express 2008 R2

Scientific software package works fine with SQL Express 2008 R2 on developing (mother) PC and Admin login mode, but difficulties are found elsewhere during installing and deploying on the client PCs.  We have used from year 2000 BDE (Borland Database Engine), which worked fine until now, but recently customers had been installing problems with Vista, Windows 7 and the local administration rights or permissions.   Thus I thought to test NT AUTHORITY\NETWORK SERVICE authentication, as this system is hopefully working again decades with coming new Windows versions. As not need to touch databases, ADO and authentication matters during last decade, I’m newbie with those topics.  Worked now few days with this problem, installed and unistalled SQL servers according to instructions, tested different connecting strings and now cannot found correction.  Solution is maybe and hopefully simple.   Attached is log data cut from (old and many times corrected) the main mother XP platform in Admin and Client (Guest) modes.  Same tests are done also with fresh XP installation on VirtualBox.  Used connecting strings are presented inside log files:           Main mother XP at Admin login:   2010-08-20 08:24:45.82 Server      Server local connection provider is ready to accept connection on [ \\.\pip

SQL 2008 Installation problem (Could not fix registry key)

Hello, I want to install SQL 2008 client tools on a Win 2008 machine. The machine already contains an instance of SQL 2005 Express which I don't want to unistall. The problem is that the installation wizard complains about Consistency Validation for SQL registry keys. The log shows the following: 2010-08-26 10:14:46 Slp: Could not fix registry key HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\ConnectTo. 2010-08-26 10:14:46 Slp: System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto. 2010-08-26 10:14:46 Slp:    en Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.ContainsInheritedAce(Byte[] securityDescriptor) 2010-08-26 10:14:46 Slp:    en Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKey(String keyName) 2010-08-26 10:14:46 Slp:    en Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKeyAndSubKeys(RegistryKey key) I have created the "ConnecTo" key, which didn't even exist. I have also tried to set premissions to HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer to "Everyone/Full Control" but the installation fails over and over. Is there anything else I could try to get the SQL tools installed? Thanks in advance.

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Problem updating records with LINQ, Concurrency?

 My project includes a grid view with some updtable fields, some fields throw an error on update and some do not and it does not really make sense. WORK_STATION_ID does not cause an error, ROOM _ID cause an error, both are int? (I am using c#) and for update I use the code liste below.using (DataClassesDataContext db = new DataClassesDataContext()) { var product = (from p in db.ASSETs where p.ASSET_ID == ASSET_ID select p).Single(); product.WORK_STATION_ID=WORK_STATION_ID; product.ROOM_ID=ROOM_ID; db.SubmitChanges(); }    Row not found or changed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Linq.ChangeConflictException: Row not found or changed. Source Error: Line 93: Line 94: Line 95: db.SubmitChanges(); Line 96: Line 97: Source File: C:\Projects\TEST_II\trunk\ObjectDataSourceLibrary\AssetController.cs Line: 95 Stack Trace: [ChangeConflictException: Row not found or changed.] System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode) +963417 Syst

Compatibility problem: an "sql server 2008 R2" db backup cannot be restored to an "sql server 2008"

To verify if the "2008 R2" version can be restored back to a "2008" dbserver I make an experiment:  construct a database on R2 version ( version : 10.50.xxx )  and backup it; then I try to restore the db backup to a "sql server 2008" db-server ( version : 10.0.xxx ) but get failed. Error message is as shown: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.   Originally I want to upgrade a "2008" server to "2008 r2" , but this problem withdraws me: if I do so , I am afraid all the existing clientuser's dbs cannot be backed up to themselves if they don't have "2008 r2" locally:   if a database is backed up under "2008 r2" environment whereas client user only has "2008" db server, does it mean he cannot restore it anymore?   So I wonder if there is an approach that helps me to create a "backward-compatible" database; when creating database on wizard there is an option to choose "compatibility level" but I don't think it meets my requirement..    Anyone can help me on this ??    

Problem displaying a page using window.showModalDialog when resizing it.

 Hi, I have a page that is displayed using window.showModalDialog, when the page is resized the tables, text boxes and everything else that is in the page with the width 100% doesn't resize (fit the page) unless a post back is used.How can I make the page keep everything in proportion when it is resized without the need to post back? 

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Problem with displaying printDialog on Windows 7 64 bit

Hello.   I'm having problems with displaying PrintDialog on Windows 7 64 bit. I checked other threads on this forum and unfortunately none of the solutions worked for me.   Here are some experiences: 1. UseExDialog option does not work for me. If set to false the PrintDialog does not show at all. If set to true PrintDialog.ShowDialog() method throws SEHException. Below You can find exception stack trace: StackTrace "   in System.Windows.Forms.UnsafeNativeMethods.PrintDlgEx(PRINTDLGEX lppdex)\r\n   in System.Windows.Forms.PrintDialog.ShowPrintDialog(IntPtr hwndOwner, PRINTDLGEX data)\r\n   in System.Windows.Forms.PrintDialog.RunDialog(IntPtr hwndOwner)\r\n   in System.Windows.Forms.CommonDialog.ShowDialog(IWin32Window owner)\r\n   in printerDialogTest.Program.Main(String[] args) w C:\\Users\\plcmiodu\\Documents\\Visual Studio 2008\\Projects\\printerDialogTest\\printerDialogTest\\Program.cs:line 19" string 2. Setting Platform target in Build to x64 does not work either. Behaviour is exactly the same as above. 3. Setting dialog owner to this (ShowDialog(this)) does not work either. Behaviour exactly the same. The code I used for testing is as simple as possible: using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; using System.Drawing.Printing; namespace printerDialogTest {  &

Problem with Subreports in Tablix in 2008 SQL Reporting Services

Hi,  I have set up a report to get data from an SQL Table to build a matrix of possible combinations of 2 products, works fine. For each combination a subreport should be called with row and colum value as parameter - also OK. But for most of the first and second column are the same column values handed to the subreport, for all other columns it works Deleting and recreating the matrix does not help   Thanks in advance

SQL Express 2008 R2 Installation problem (getting error in silent installation)

Hi, I create install script that will install my application and also "Microsoft SQL Server Express 2008 R2"  (32 BIT) engine + Advanced tools (without the Management Studio). It been installed successful on Windows XP SP3 but on windows 7 i get an error. The full logs and Setup configuration are in the link files below. I will be grateful for any answer. Thanks, Shai. Log Files:  - **"MySetup.ini" file:**   http://justpaste.it/MySetupini  - **"ConfigurationFile.ini" that been generate by installation:** http://justpaste.it/ConfigurationFileinitxt  - **"Summary.txt file from "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log":**  http://justpaste.it/Summarytxt  - **"Details.txt" file that been created at "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_102314":**  http://justpaste.it/Detailstxt

SQL Express 2008 R2 Installation problem (getting error in silent installation)

Hello, I created install script that will install SQL Server 2008 R2 on windows XP SP3, windows vista and windows 7.  One of the command that i used in the installation is for silent installation of SQL Server 2008 R2. When i install it on windows XP everything works just fine but when i try to install it on Windows 7 i get an error. What am i doing wrong? Here is the command line that i use:  "Setup.exe /ConfigurationFile=Mysetup.ini" Mysetup.ini file: -------------------------------------End of ini file --------------------------------- ;SQL SERVER 2008 R2 Configuration File ;Version 1.0, 5 May 2010 ; [SQLSERVER2008] ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance. INSTANCEID="MSSQLSERVER" ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components. FEATURES=SQLENGINE ; Displays the command line parameter

SSAS 2008 attritube hierarchy doesn't group records and repeat rows

We are having problems with the dimension attributes in lower level hierarchies not grouping under 1 single level. Here is the hierarchy: VP    College      Department         Departmental Course            Course Level               Course Number The top 3 levels are grouping correctly without duplicate rows and they don't have compoud keys. The lowest 3 levels are not grouped correctly and they have compounds keys because the attributes are not unique by themself. The result of the hierarchy looks like this: VP Academic Affairs    Business School of Management        International Business School            Mgm101                 Lower                       Course Number 123            Mgm101                Upper                
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