sorex Posted December 16, 2006 Share Posted December 16, 2006 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 More sharing options...
aspnetguy Posted December 18, 2006 Share Posted December 18, 2006 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 More sharing options...
Guest senthilmurugan Posted January 23, 2007 Share Posted January 23, 2007 using the following class to connect sql database with dot net1.sqlcleint2.sqlconnection3.sqlcommand4.sqldatareader5.sqldataadapter Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now