problems when connecting with server

Hi, I am developing an application in where I connect with my server of SQL,

but at the time of making pull this offer one exepcion,

the code that I use is the following one

Dim rda As SqlCeRemoteDataAccess = Nothing

rda = New SqlCeRemoteDataAccess

rda.InternetUrl = "http://my-computer/SQLCE/sscesa20.dll"

rda.LocalConnectionString = "Data Source = C:\BD\rda_lab.SDF"

rda.Pull("authors", "SELECT * FROM Authors", "Provider = SQLOLEDB.1; Data Source = my-server; User ID = sa; PASSWORD = psw; initial catalog = SQLCE", RdaTrackOption.TrackingOn)

rda.Dispose()

The message that shows is:

Unhandled Execution Error

Line 40: rda.Pull("authors", "SELECT * FROM Authors..............

I have proven many things and I have not been able to solve I hope it and somebody can help me

So you're using SQL CE 2.0 (from InternetUrl property) which is not supported on desktop and yet providing path to the SDF file which is only valid on desktop (as it has drive letter). That seems to be wrong…

|||Hi Ilya Tumanov , perhaps it does not explain to me correctly.I am developing to an application Web where desire to take the data from my DataBase and to show them in a List Box, when executing the instruction pull before gives back the mentioned error to me|||

What I'm saying is: your RDA code is definitely wrong, it does not matter what exactly you're planning to do with data.

Your InternetUrl and LocalConnectionString properties are in conflict, they can't both be correct.