Click here to Skip to main content
15,918,976 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello!

I have a problem with connection from windows mobile 6.5 application to sql server!

The error message is that canont find the specified server!

the srever is SQL 2008 R2

Any ideas ?

Kind regards?
Posted

Your connection string is incorrect. Please correct it and try again.
 
Share this answer
 
Comments
Atmir 20-Mar-12 18:39pm    
my connection is correct but it is not recognised by device , what i should do to turn on to recognize the sql server
ZurdoDev 20-Mar-12 19:53pm    
Please share some of your code. Please use the Improve Question link.
Atmir 7-Apr-12 12:43pm    
Imports System.Data

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlClient.SqlConnection
Dim cmd As New SqlClient.SqlCommand
Dim da As New SqlClient.SqlDataAdapter
Dim dr As SqlClient.SqlDataReader
Dim strcon As String
Dim strsql As String
strcon = "Data Source=192.168.1.104;Initial Catalog=dbsel;Integrated Security=True"
strsql = "Select ID,Naziv FROM osnovnegrupeprodaajniartiklla"
da = New SqlClient.SqlDataAdapter(strsql, strcon)
con = New SqlClient.SqlConnection(strcon)
con.Open()

cmd = New SqlClient.SqlCommand(strsql, con)
dr = cmd.ExecuteReader
MsgBox(con.State.ToString)

con.Close()
MsgBox(con.State.ToString)

End Sub
End Class
this is code
Atmir 7-Apr-12 13:32pm    
I have enabled the tcp/ip on server all other stuff but stil is not working
Atmir 10-Apr-12 17:40pm    
where are the experts???????
You need to set up your DB correctly. Check this article

http://techyard.wordpress.com/2009/03/10/visual-studio-2008-smart-device-project-connect-to-sql-server/[^]
Good Luck, its a PITA to get it to work, but thats the solution
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900