SqlCeRemoteDataAccess Pull issue with ConnectionString

I am using a tested connection string.

when I execute the following code:

Me.Cursor = Cursors.WaitCursor

Try

clsRDA.VerifyDatabaseExists()

clsRDA.DeleTable("WorkOrder")

Dim rda As SqlCeRemoteDataAccess

rda = clsRDA.GetRDAObject()

rda.Pull("WorkOrder", "SELECT * FROM WorkOrder", My.Settings.RemoteAbacBillConnectionString, RdaTrackOption.TrackingOnWithIndexes, "WorkOrder_Errors")

Catch ex As Exception

MsgBox(ex.Message)

Finally

Me.Cursor = Cursors.Default

End Try

I get the following error:

Failure to open SQL Server with given connect string.

Answer this question

SqlCeRemoteDataAccess Pull issue with ConnectionString

dgaynes

What is the result of My.Settings.RemoteAbacBillConnectionString

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere
Dave Waterworth
My.Settings.RemoteAbacBillConnectionString =
"Data Source=200.2.128.9;Initial Catalog=AbacBillRep;Persist Security Info=True;User ID=test;Password=test"

My.Settings.RDASyncPointURL=

"http://200.2.128.9/SQLMobileSubscriptions/sqlcesa30.dll"
rod_r

Can you connect to SQL Server directly using the above credentials

If the above credentials are SQL Server user, then open SQL Server Management Studio (SSMS) and Connect to Database Engine using 'SQL Server Authentication' mode and with the above credentials. If this is not working, then you should add this credentials into SQL Server for security.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft
SqlCeRemoteDataAccess Pull issue with ConnectionString

Answer this question