Mobile 5.0

[David de Passos]

Hi!

I have a Pocket PC aplicattion developed in VS 2003, I have converted in VS
2005 but I get a error.
So, I have create a new Pocket PC aplication from Vs 2005, with the same
code and I get the same error:
"SQL Server does not exist or access denied."
The program work well but when try myConnection.Open() I get the exception
error.

There is my code:

Imports System.Data.SqlClient

Module RCMobile

Dim myConnection As New SqlConnection

Dim ConnGestao As String

Sub Main()

Try

MsgBox("ola")

'ConnGestao = "Password=aaa;User ID=teste;database='" & BaseDados &
"';server='" & Servidor & "' ;Connect Timeout=10"

ConnGestao = "Persist Security Info=False;Integrated Security=False;server="
& Servidor & ";initial catalog=" & BaseDados & ";User ID=teste; Password =
aaa;Connect Timeout=10"

myConnection.ConnectionString = ConnGestao

myConnection.Open()

myConnection.Close()

Catch ex As SqlException

MsgBox(ex.Message & Err.Description)

Application.Exit()

End Try

End Sub

End Module

 

[Ginny Caughey [MVP]]

David,

It sounds like either your server IP address is not reachable or your userID
and password are incorrect for that server. You could also try removing the
Connect Timeout clause temporarily in case you are just timing out on the
connection. If you're using the name of the server and not the IP address,
try the IP address.

 

[David de Passos]

No, the IP is correct.
That works in Visual Studio 2003