How can i connect from VB 2005 Expresss Beta 2 to SQL Server 2000 ?

How can i connect from VB 2005 Expresss Beta 2 to SQL Server 2000 database
I try:

......
Dim connectStringBuilder As New SqlConnectionStringBuilder()
connectStringBuilder.DataSource = "127.0.0.1"
connectStringBuilder.InitialCatalog = "myDatabase"
connectStringBuilder.IntegratedSecurity = True
connectStringBuilder.UserInstance = True

Dim myConnection As SqlConnection = New SqlConnection(connectStringBuilder.ConnectionString)
myConnection.Open()
......

and i've got error:
SSE Instance re-direction is not supported for non-local user instances.

Any help will be appreciated.

Regards
Sebastian

Answer this question

How can i connect from VB 2005 Expresss Beta 2 to SQL Server 2000 ?

Michael Bartlett
You can use VS with any version of SQL Server in a remote (or traditional) style of connection. However, if you want to use the local data features of VS (i.e., add new item, add a SQL Server database, have it added to the project), then you must use SQL Server 2005. In particular, you can only use SQL Server Express 2005 ("SSE"). SSE is free though so getting it for use should not be an ostacle for you.

Hope this helps.
Javen
Looks like you are specifying True for User Instance which is not supported for SQL Server 2000.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
aghoneim
Hi,

I read you mail about VB 2005 Express and Sql server 2000 code.

I am new to .NET 2005 and expression editions.

I want to know that

Can we use VB.NET 2005 Express with Sql Server 2000

or

we MUST USE SQL SERVER 2005

are you developing any client server applications what is best combination for mid-level client server app

Please guide me.

ami
Danny Walroff
That's it !

Thank You for Your help.
mexmsdn
But can I connet VBExpress to SSE on a remote server (via IP) If yes, can I use the drag and drop features that are available with the local file version If I have to develop with a local copy to get those features, is there a way to upsize to a remote database for deployment (I have and MS Access 2000 app that hits SSE across the internet running on my home server. I would like to convert it to a VB app. After devopment, I'd like to deploy it on SS 2005 on a commercial web server provider.)
How can i connect from VB 2005 Expresss Beta 2 to SQL Server 2000 ?

Answer this question