Jump to content
Sign in to follow this  
sorex

VB .NET 2005 Express & SQL2000

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)

Share this post


Link to post
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. :)

Share this post


Link to post
Share on other sites
Guest senthilmurugan

using the following class to connect sql database with dot net1.sqlcleint2.sqlconnection3.sqlcommand4.sqldatareader5.sqldataadapter

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...