How to connect VB.NET 2005 Express edition with SQL server 2000 Professional

Hot Topic

Tabs and not spaces
CollectionEditor in VB 2005 Express
running an .exe
Non-Microsoft OS
How does one run VB
Newbie - File copying confusion
Beginner Code help
cant create windows applications
.Net Framework SDK 2.0
RSS Screensaver Starter Kit

VS Express Editions

What happened to SoundPlayer?
How to create transparent "Computer Locked" window?
Missed only one think: Code Friendly
Noob Combobox ?
invalidcastexception derived treenode
How do I retrieve an SQL database record by primary key?
Web Services Enhancements ...
vbe layout toolbar problems
how to import Bookmarks favorites file to treeview
Playing sound from a IO.Stream object

How to connect VB.NET 2005 Express edition with SQL server 2000 Professional

I have installed VB.NET 2005 Express edition installed and SQL Server 2000 on my machine. I try to add database connection in data source. From new connection, in the Change Data Source window, there should be be 4 options while i have only two options (Microsoft SQl server database file and MS access database file) but there also should be an option for Microsoft SQL Server. 
there is any one who can guide me and thanks in advance for guidence.

Shahid

Answer this question

How to connect VB.NET 2005 Express edition with SQL server 2000 Professional

  • Anthony Giambalvo

    I have got a complete version of visual studio 2005 but even the same has got the same problem to being unable to connect to sql server 2000. Is there any way vs2005 can access sql server 2000.

  • Macerick

    VB Express (and C#, etc. .. all of the Express SKUs) only connect to local data databases.  That's defined as SQL Express 2005 and Access.  There is an exception for Web Express in that it can access a remote database for access purposes (i.e. Insert, Update, and Delete) operations, but you cannot use the tools to alter schema to say, create a new database or alter a table. 
  • How to connect VB.NET 2005 Express edition with SQL server 2000 Professional
Answer this question