Jump to content

VB .NET 2005 Express & SQL2000


sorex
 Share

Recommended Posts

Hello,Is it normal that VB .NET 2005 Express can't connect to my local SQL 2000 server ?It seems that all I can do is connec to an Access DB or create a new SQL mdf file but then it nags that I need SQL 2005 Express aswell?I'm new to this ide stuff so I might overlooked something here tho (tend to code in vbscript, asp so not familiar with all this)

Link to comment
Share on other sites

I usually don't use the database manager, try using

Dim cnt As SqlConnectioncnt = new SqlConnection("Data Source=(local);Initial Catalog=xxxx;User ID=xxxx;password=xxxx;Trusted_Connection=yes;")

sorry if that is not 100% correct my VB is a bit rusty...could imagine using this as apposed to C#, but that is just me. :)

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...