HOW TO CONNECT TO SQL SERVER 2000 DATABASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone:

I am writing a Pocket PC applicatrion using VB .net 2003. I need to connect
to a remote SQL server database and load records in DataGrid.

Any help in doing so would be very helpfull.

I try ;

Imports System.Data.SqlClient

Dim connection As New SqlConnection(ConnectionString)
Dim adapter As New SqlDataAdapter(mySqlCmd, connection)

But SqlDataAdapter line is not working... Looks like it does not like it. Is
there is a way, we can call a SQL database records to a pocket PC
application. I do not want to used Windows SQL CE though...

Any help, would be good.

Many Many Many Thanks
 
absolute88 said:
Hi Everyone:

I am writing a Pocket PC applicatrion using VB .net 2003. I need to
connect to a remote SQL server database and load records in DataGrid.

Any help in doing so would be very helpfull.

I try ;

Imports System.Data.SqlClient

Dim connection As New SqlConnection(ConnectionString)
Dim adapter As New SqlDataAdapter(mySqlCmd, connection)

But SqlDataAdapter line is not working... Looks like it does not like
it. Is there is a way, we can call a SQL database records to a pocket
PC application. I do not want to used Windows SQL CE though...
Click to expand...

I really wouldn't use an sqlserver 2000 server accessable through
wireless networks. This opens up hack attempts you can't even see.

Most of the time, data is transported from service to ppc and stored
locally in sqlce, then used on hte ppc, saved in sqlce and when you're
ready, replicated back to the sqlserver, via a service, encrypted.

Frans

--
 
Back
Top