any one know whats wrong with it

[code]

 

private sub pulllikehell()
        dim cn sqlceconnection
        dim rda sqlceremotedataaccess = nothing
        dim sqlengine sqlceengine

        try

            ' create database if doesn't exist
            if (not file.exists("\my documents\order.sdf")) then
                sqlengine = new sqlceengine
                sqlengine.localconnectionstring = "data source=\my documents\order.sdf;"

                sqlengine.createdatabase()
                sqlengine.dispose()
            else
                ' open connection database
                cn = new sqlceconnection("data source=\my documents" & _
                                         "\order.sdf:")
                cn.open()
                dim cmd sqlcecommand = cn.createcommand()

                ' drop fieldmemos table
                cmd.commandtext = "drop table staff"
                cmd.executenonquery()

                ' close connection

            end if

            ' instantiate rda object
            rda = new sqlceremotedataaccess
            ' connection string sql server.
            dim remoteconnectstring string = "provider=sqloledb;" & _
                                                "data source=kangalert/sqlexpress;" & _
                                                "initial catalog=order;"

            rda.internetlogin = ""
            rda.internetpassword = ""
            rda.interneturl = "http://kangalert/server/sqlcesa30.dll"
            rda.localconnectionstring = "data source=\my documents\" & _
                                        "order.sdf;"

            rda.pull("staff", "select * staff", remoteconnectstring, _
             rdatrackoption.trackingonwithindexes)
            msgbox("ok")

        catch sqlex sqlceexception
            dim sqlerror sqlceerror
            each sqlerror in sqlex.errors
                messagebox.show(sqlerror.message)
            next
        catch ex exception
            messagebox.show(ex.message)
        finally
            rda.dispose()
        end try

    end sub

[/code]

computer server name kangalert

and got 2 sqlservice run in pc,  sqlexpress  , mssqlserver

database name order table call staff

when come statement

rda.localconnectionstring = "data source=\my documents\order.sdf"

error message: request send data computer running iis has failed. more information, see hresult.

 when come statement

rda.pull("staff", "select * staff", remoteconnectstring, _
             rdatrackoption.trackingonwithindexes)

error message :a required property not specified. [ property name = subscriberconnectionstring ]

hopefully can me solve it. in advance

error: request send data computer running iis has failed

this occurs when client agent box (emulator or device) not have network connectivity iis box.  make sure have connectivity.  try browsing above sqlcesa30.dll url in emulator/device ie, ensure connectivity. 

error: required property not specified. [ property name = subscriberconnectionstring ]

i not understand how have got error.

let know results after resolving first error.

thanks,

laxmi narsimha rao oruganti, msft, sql mobile, microsoft corporation

SQL Server  >  SQL Server Compact