Wireless Connection

[gundamhamtaro]

Hi all, i have a pda application that uses SQLServerCE, and i would like to have wireless support for it so that i can use Remote data access to access SQLServer on a desktop terminal, and synchronise the data on the pda with the data on the desktop. I have a few questions here: 1)do i need any extra hardware or software on the desktop to enable for wireless connection? 2)In the code i have below, i left InternetUrl as blank as i'm not sure what i am supposed to put there. what is the parameter supposed to be? address of the desktop? 3)Is the code below sufficient for me to connect to the desktop database wirelessly? Dim conn As String = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=admin;" & _ "Data Source=terminal;Packet Size=4096;Workstation ID=terminal;User Id=;Password=" Dim rda As SqlServerCe.SqlCeRemoteDataAccess = Nothing Try rda = New SqlServerCe.SqlCeRemoteDataAccess 'rda.internetUrl = "?" rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\test.sdf" rda.Pull("admin", "Select * from admin", conn, RdaTrackOption.TrackingOnWithIndexes, "ErrorTable") Catch err As SqlServerCe.SqlCeException MessageBox.Show(err.Message) Finally rda.Dispose() End Try Thanks for looking at my post =)

[Richard Jones]

SqlServerCE uses IIS (a web server) to bounce over to your SqlServer2000 server. The connection string would be a URL to the IIS page. The page would query the server, and forward it back to the device. See "SQL Server CE Database Development with the .NET Compact Framework" by Rob Tiffany I JUST got a wireless ppc yesterday, so I'm eager to try this book out. Top 10 Geek Resulutions: 5. To decipher what that big room is, which has the blue ceiling and poor climate control.