Connection with sql server 2000

[Fabio]

Hello,

My name is Fabio.

I'm trying to connect with one intance of SQL 2000 (MSDE) via compact
framework. But I can't connect. What is wrong in my code?
My Connection String is OK? If not, how could i build one?
Imports System.Data.SqlClient

Public Class Database

Private Conn As New SqlConnection

Sub New()

Conn.ConnectionString = "user id=sa;password=;initial
catalog=Restaurate;server=mobile\msql2000"

Try

Conn.Open()

MsgBox("Conectado")

Catch ex As SqlException

MsgBox(ex.Message)

End Try

End Sub

End Class

 

[Alex Feinman [MVP]]

I suppose the problem is that the device cannot resolve the name "mobile".
Try using the IP address to see if it helps

 

[Nicolas Nasdrovisky]

Hi.

You should double your back slash:
Conn.ConnectionString = "user id=sa;password=;initial
catalog=Restaurate;server=mobile\\msql2000"

If you are connecting through an ActiveSync, try tu use "PPP_PEER" as the server
name.

Nicolas.

 

[Alex Feinman [MVP]]

He's using VB - in VB "\" is not doubled

Hi.

You should double your back slash:
Conn.ConnectionString = "user id=sa;password=;initial
catalog=Restaurate;server=mobile\\msql2000"

If you are connecting through an ActiveSync, try tu use "PPP_PEER" as the server
name.

Nicolas.