Advertisement

12.20.2007 at 05:51PM PST, ID: 23037440
[x]
Attachment Details

How to connect VB 2008 Express to SQL Server 2000 Database?

Asked by sandygettings in Microsoft Visual Studio Express, MS SQL Server, Microsoft Visual Basic.Net

Tags: 2008, express, sql, connect, server

I have a large SQL Server database, and I have a VWD 2008 Express project that can connect to it okay. However, in VB 2008 Express it doesn't seem to know about SQL Server 2000. In particular, under the Data menu, Add New Data Source, Database, New Connection, the Data Source only has three choices: Microsoft Access Database File, Microsoft SQL Server Compact 3.5, and Microsoft SQL Server Database File. Note that this last option is referring to a database file, not the database server.

In contrast, VWD 2008 Express has additional data sources, including Microsoft SQL Server. Its Data Provider is also ".NET Framework Data Provider for SQL Server", which recognizes SQL 2000 just fine.

So, how do I configure VB 2008 Express to recognize SQL Server 2000?Start Free Trial
[+][-]12.20.2007 at 07:06PM PST, ID: 20511470

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Visual Studio Express, MS SQL Server, Microsoft Visual Basic.Net
Tags: 2008, express, sql, connect, server
Sign Up Now!
Solution Provided By: jaime_olivares
Participating Experts: 2
Solution Grade: B
 
 
[+][-]12.21.2007 at 03:06AM PST, ID: 20512634

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]12.28.2007 at 07:22AM PST, ID: 20542378

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628