i am having trouble with connection for the device emulator to sql
server databse residing in my pc. i manage to get network connection to
the emulator but i still canot connect to the database.

i tried connecting using activesync to my emulator n acces the sql
server but i doesn't work. saying there is a connection problem. but i
can access the internet using the emulator thru my pc network. i dun
understand wat am i doing wrong.?

i also tried using the NE2000 to connect to my pc instead of
activesync. the connection is up but i still canot access sql server
also . it gave me a diff error msg though. saying the sql server do not
exist or access deny.

need help figuring out wat did i do wrong. thanks

Re: sql server in pocket pc by ctacke/>

ctacke/>
Thu Apr 27 15:13:53 CDT 2006

Can you show us the code that fails to connect?

-Chris


<alexoh84@gmail.com> wrote in message
news:1146165712.371527.225410@v46g2000cwv.googlegroups.com...
>i am having trouble with connection for the device emulator to sql
> server databse residing in my pc. i manage to get network connection to
> the emulator but i still canot connect to the database.
>
> i tried connecting using activesync to my emulator n acces the sql
> server but i doesn't work. saying there is a connection problem. but i
> can access the internet using the emulator thru my pc network. i dun
> understand wat am i doing wrong.?
>
> i also tried using the NE2000 to connect to my pc instead of
> activesync. the connection is up but i still canot access sql server
> also . it gave me a diff error msg though. saying the sql server do not
> exist or access deny.
>
> need help figuring out wat did i do wrong. thanks
>



Re: sql server in pocket pc by alexoh84

alexoh84
Thu Apr 27 15:41:47 CDT 2006

this is the code which i use to connect to the database.


dbconn = New SqlConnection("Server=192.168.1.7;initial
catalog=GroceryDB;user id=sa;password=password")
dbconn.Open()
strSqlCommand = New SqlCommand("SELECT * from UserDb where UserID='" &
Trim(LCase(txtUserID.Text)) & "'", dbconn)
strReader = strSqlCommand.ExecuteReader()
strReader.Read()