Connection with sql server 2000

  • Thread starter Thread starter Fabio
  • Start date Start date
F

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
 
I suppose the problem is that the device cannot resolve the name "mobile".
Try using the IP address to see if it helps
 
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.
 
He's using VB - in VB "\" is not doubled

Nicolas Nasdrovisky said:
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.
Click to expand...
 
Back
Top