Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Basic >> Visual Basic Language

Problem connecting visual basic 2005 express to sql server 2000

What is the best way to connect visual basic 2005 express to a database sql server 2000. I try to make a connection using ado.net that was explained on the book Mastering Visual Basic 2005, and it gives me the error in the connection wizard and don't make the connection. What could be rong.

Please help me.

Fernando Silva

[342 byte] By [FernandoSilva] at [2007-12-24]
«« sorry for those repeated messages
»» Transaction context in use by another session. (Continued)
# 1

The only database that you can directly connect to in VS Express is a local SQL Express database instance.

There is a workaround that I don't remember exactly becuase I don't use Express, but I believe it basically involves creating a SQL Express connection locally using the wizard, and then modifing the connection string the wizard generates to use the SQL provider and to point at the correct database.

rkimble at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic Language...
Visual Basic
Visual Basic Language

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified