Using RDA problems

  • Thread starter Thread starter dave m
  • Start date Start date
D

dave m

A couple questions about accessing a sqlce database via Remote Data Access.

When using the SQL Server CE Virtual Directory Creation Wizard, when I
choose to use basic authentication, it tells me the domain is the name of my
desktop PC ('MyPCName' in this case). So in my code, I reference this
name, like this -

rda = New SqlCeRemoteDataAccess
' connection string to the sql server
Dim remoteConnectString As String = "provider=SQLOLEDB;" & _
"Data Source=MyPCName;Initial Catalog=MyDatabaseName;" & _
"User Id=sa;Password=dbpassword"
rda.InternetLogin = "davem"
rda.InternetPassword = "mypw"
rda.InternetUrl = "http://mypcname/fieldagentrda/ssces20.dll"

However, this fails. Using PIE, using the 'domain' name to see ssces20.dll
also fails, but succeeds when using the IP address of my desktop PC.

Can someone tell me why I'm having this problem? Should the connection on
the PPC be set to connect to 'Work' or the 'Internet'?

Also, I know I'm using IIS in this process, but can RDA or Merge Replication
also be used via the sync. cable?

Thanks in advance for any advice!

Dave M.
 
It's to do with your network/dns server, I'm not a network boffin,
unfortunately he's on holiday. We often come across installations where
we need to use IP address rather than machine name and we always
connect to 'Work', but this may differ depending on your scenario.

Your last question is a bit confused, RDA only works against IIS since
it uses the sscesa20.dll which is an IIS service. Providing the handset
has a network connection via any of the myriad of methods, WIFI,
internet, active sync, serial, ethernet, bluetooth, it will work,
subject to network rights/configuration etc.

Cheers,

Chris
 
Back
Top