connect Mobile 5.0 to SQL Server


D

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
 
Ad

Advertisements

B

Brian Nantz

This sounds like an installation of sql that didn't work right or a
config setting incorrect. Is there a way to verify that SQL works
independent of your program.
 
D

David de Passos

´The SQL server works fine, with windows aplication and Mobile aplication
2003, but with Mobile 5.0 2005 doesn´t work
 
N

Nino Benvenuti

David said:
´The SQL server works fine, with windows aplication and Mobile aplication
2003, but with Mobile 5.0 2005 doesn´t work

David,

In addition to changing the target platform to Windows Mobile 5.0, have
you also done an "Upgrade" to .NET CF 2.0?

FYI, you need .NET CF 1.0 to work with SQL CE 2.0 and .NET CF 2.0 to
work with SQL Mobile 2005.
 
D

David de Passos

Yes I have already upgrade to .NET CF 2.0

Nino Benvenuti said:
David,

In addition to changing the target platform to Windows Mobile 5.0, have
you also done an "Upgrade" to .NET CF 2.0?

FYI, you need .NET CF 1.0 to work with SQL CE 2.0 and .NET CF 2.0 to work
with SQL Mobile 2005.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top