locked
Failure to Open SQL Server with Given Connect String RRS feed

  • Question

  • Dears

    Im working with VS 2008 trying to connect SQL Server from Windows Mobile Device,I have error while running the below Code

    Failure to Open SQL Server with with given connect string.

    i tried check this link http://social.msdn.microsoft.com/forums/en-us/sqlce/thread/B052311D-199F-4156-A27E-2ED159EA1275 also http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/4ff1c92e-c2b3-4bc3-a317-087164e75995/ ,still have error msg.

    I am using SQL 2008.

     

    Please any help 

    Public rda As SqlCeRemoteDataAccess = Nothing
    Dim rdaOleDbConnectString As String = "Data Source=My-PC;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=SQL;User ID=sa;Password=abcdef;"
    
    Public Sub Init()
    
      Try
    
        rda = New SqlCeRemoteDataAccess()
        rda.InternetUrl = "http://192.168.1.111/Sql/sqlcesa35.dll"
        
        rda.LocalConnectionString = "Data Source=OSF.sdf;password=tick"
        rda.Pull("NCB", "Select * From table1", rdaOleDbConnectString, RdaTrackOption.TrackingOn)
        MsgBox("OK ")
    
      Catch err As SqlCeException
    
        MsgBox(err.Message)
    
      Finally
    
        rda.Dispose()
    
      End Try
    

    Saturday, July 16, 2011 1:53 PM

Answers

All replies