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

--
Hello, All CF programming fans

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" wrote:

> 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 connection string is :
"User ID=sa;Password=sa;Initial Catalog=Northwind;Server=192.168.1.100;Data
Source=192.168.1.100"


> The SqlException message is server is not exist or can not access.I
> change the server name to IP , the sympton is same
>
> --
> Hello, All CF programming fans

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)
--------
Regards
Praaksh





"Flattron" <(E-Mail Removed)> wrote in message news:<D913455D-82A8-4C98-80FA-(E-Mail Removed)>...
> 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"
>

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...

"Flattron" wrote:

> The IP address in the mobile devce is get from Wireless Router .I think the
> USB active sync transfer is not very stable,some times the transfer will
> broken when mass data is transfer.
>
>
> "prakash" wrote:
>
> > 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)
> > --------
> > Regards
> > Praaksh
> >
> >
> >
> >
> >
> > "Flattron" <(E-Mail Removed)> wrote in message news:<D913455D-82A8-4C98-80FA-(E-Mail Removed)>...
> > > 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"
> > >
> >