SQL Server 2000 DB attached in SQL Server 2005 Express not connecting to VB .NET 2003 application now. WHY ?
-
I made a S/W using VB .NET 2003 and SQL Server 2000. Now, i uninstalled both and installed Visual Basic 2005 Express and SQL Server 2005 Express. I attached the old database (created in SQL Server 2000) with SQL Server 2005 Express and it attached successfully. But when i run the executable of my application (created in VB .NET 2003), it doesn't connect to the database suceessfully. What might be the reason for that and what should i do to resolve it ??? ... Thanks, Zain.
-
Answer:
Check the connection string and make sure your application has access to the database. Be aware that the default instance created by SQL Server 2005 Express is (local)\SqlExpress. Use Microsoft's free SQL Server Management Studio Express to check the connection settings, connect to the database, manage it, run SQL queries, etc.
PuraniJe... at Yahoo! Answers Visit the source
Other answers
Check your connection strings.
sinkablehail1978
Related Q & A:
- How can I restore Sharepoint web app when the DB is in another server?Best solution by SharePoint
- How to upgrade sql server express 2005 to 2008R2?Best solution by Server Fault
- How Do I Configure SQL Server 2005 Backend?Best solution by Server Fault
- How to increase application performance with Centralised SQL Server?Best solution by Database Administrators
- How to save from DatagridView to Database VB.NET?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.