Urgent Help Needed on SQL Error - A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
Posted on 2011-02-11
I've got a strange problem that I would sure appreciate some help with. When I try to run past working projects or create new projects that use an SQL server as a data source, I get the following error and no data is returned: "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll"
I am using Visual Studio 2008 and I have SQL 2008 Express Advanced edition (64 Bit), loaded on my development PC and have a mix of SQL 2005 and 2008 servers. My PC is running Vista 64.
I have tried the following in my troubleshooting efforts:
1. I've created a brand new simple project with a with a new connection string pointing at new table and still get the error.
2. I've created a local table in my SQL Express database and still get the error. Therefore, I get the error no matter what SQL Server I point to.
3. I unistalled my local SQL Server 2008 Express, cleaned all of the registry entries that I could find and reinstalled SQL Express 2008 Advanced.
4. I then retried all of the steps above with the same error.
Here is the odd thing, when I am within a project I can click on a tableadapter and preview the data from the "Preview Data" option and it brings back the data just fine. However, if I launch the project, I immediatly get the error and not data is returned. My sample project has a single datagridview that is bound to a simple test table. The default fill method is being called on the form load event.
I'm stumped on this one. HELP PLEASE!!!!!