[RESOLVED] am i crazy or wat?

[avrail]

look, i lost alot of days, in searchin' and i didnt find any the same old error
General Network error, check your network documentation
someone help me and i will be so gratful , i can clean ur car, may b i can pay for U

someone states to me wat is the steps to make a successful connection to SQL Server 2000 database working with c# .Net and the Emulator on my local machine wiche is called AVRAIL.
thx alot,
really i mean it when i said i will clean ur car

[petevick]

In VS2005 try
1. Run Tools->Device Emulator Manager
2. Select Pocket PC 2003 SE Emulator
3. Actions->Connect
4. Actions->Cradle
Then try connecting with a string like...

Dim sqlConn As New SqlConnection
Try
sqlConn = New SqlConnection
sqlConn.ConnectionString = "Persist Security Info=False;Integrated Security=False;Server=avrail;initial catalog=Pubs;user id=sa;password=;"
sqlConn.Open()
Catch ex As SqlException
MessageBox.Show(ex.Message)
End Try

Pete

[avrail]

this wat i have done and i still have the same prob.

[petevick]

Have you got a network card in your machine - if not, install the microsoft loopback adapter and try again.

Pete

[avrail]

k, petevick i dont got a netowrk card on my pc, i get the microsoft loopback adapter, and i installed it on my pc.
i used this link to install it. http://www.pocketpcdn.com/articles/e..._loopback.html

but really i dont know how this can help me in my prob?

[petevick]

Hi,
because you need a network connection from the emulator to the PC.

Can you now ping the PC from the emulator?

Pete

[avrail]

k, i try to ping my pc from the emulator using the vxUtil, my pc name is avrail
i try to ping the host this was the message cannot find host avrail
wat i have to do now

[avrail]

by the way, iam so sry, i cant connect to the internet using the emulator why?

[petevick]

Hi,
what IP address does VXUtil give you?
How did you install VXUtil - if you installed it to the emulator using activesync, you should have no problem.

Try opening the database using ip address rather than host name.

Did you try the connection string I gave you?

If you can get the emulator to connect using activesync, you should be able to open the database

Pete

[avrail]

this is the ip address that the vxutil gived it to me 192.168.55.101
and i installed the emulator using activesync

[petevick]

Hi,
in that case, unless it is a firewall or connection string problem, you should be able to open the database, as you have proved you can connect with the emulator by installing VXUtil.
The IP address is correct for an activesync session, so step through your code, and put a try catch around the open statement.

[avrail]

it is have been solved
all i have done is getting the sp3 for sql server 2000
hate u microsoft they have to tell us
i lost about 4 days for this