I can not connect SqlServer2000 with PocketPC with WIFI

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

Guest

Hello,
I am new guys here .
When I debug a application and connect sqlserver 2000 using PPC via
active sync, everything is OK,
After that ,I enable wireless Lan ,PPC can get a IP from wireless router,I
can ping the ppc from PC.But after run the PPC application,it can not
connect Sqlserver200 in the PC.
The SqlException message is server is not exist or can not access.I
change the server name to IP , the sympton is same
 
I also find another problem:
When I use active sync to run my application from PPC ,I wirte 1000
line information to database use insert SQL,There always have sqlexception
happen :server is not exist or can not access.But there is very OK run in
simulator ,No any sqlexception happen!

The code is :

Dim i As Integer
For i = 1 To 1000
AddFeederIDMobileXX()
Next

Public Function AddFeederIDMobileXX() As Boolean

Dim scnnDB As SqlConnection
Dim sReader As SqlDataReader
Dim scmd As SqlCommand

scnnDB = New SqlConnection(SQL_CONNECTION_STRING)
scmd = New SqlCommand("INSERT INTO FeederID_Mobile
VALUES('asdf','asdf',34,'Nil')", scnnDB)
Try
scnnDB.Open()
scmd.ExecuteReader(CommandBehavior.CloseConnection)
scnnDB.Close()

Catch exp As SqlException

Dim i As Integer
For i = 0 To exp.Errors.Count - 1
MessageBox.Show("Index #" & i & ControlChars.NewLine & _
"Error: " & exp.Errors(i).ToString() &
ControlChars.NewLine)
Next i

Finally
End Try
End Function

The connection string is :
"User ID=sa;Password=sa;Initial Catalog=Northwind;Server=192.168.1.100;Data
Source=192.168.1.100"



Flattron said:
Hello,
I am new guys here .
When I debug a application and connect sqlserver 2000 using PPC via
active sync, everything is OK,
After that ,I enable wireless Lan ,PPC can get a IP from wireless router,I
can ping the ppc from PC.But after run the PPC application,it can not
connect Sqlserver200 in the PC.
Click to expand...

The connection string is :
"User ID=sa;Password=sa;Initial Catalog=Northwind;Server=192.168.1.100;Data
Source=192.168.1.100"
 
Are you set the IP Address in the Mobile Device

goto
Settings -> connections -> Modem
Click New Connection
give a connection name
click the Advanced tab -> TCP/IP
select:Use Specfic IP Address and give an IP Address (192.168.1.150)
 
I encounter the same problem.. the ppc always got problem connecting to the
wireless router every few days... the IP is gone... for my application, I use
ppc 2003 to connect to access wireless via web service... check out at
www.doitech.com anyone knows how to fix the problem... even with fix ip at
2003, I also got problem to connect.... the password sometime is also reset...
 
Back
Top