Unable to connect

[alanyu]

Dear Everyone,

Why I wrote the program in OS wm5.0 can't be connected server? In the computer can be connected?
Who can help me?

Thanks

Alan

 

[alanyu]

Sub Globals
'Declare the global variables here.
Dim connected As Boolean
 
server="SQL5004.Smarterasp.net"
port="1433"
database="DB_9AACA3_alan"
login="DB_9AACA3_alan_admin"
pass="blq4ever"
End Sub
 
Sub App_Start
Form1.Show
Scanning.Focus
Mssql.New1
 
connected = Mssql.Open("Persist Security Info=false;Integrated Security=false;Server=" & server & ", " & port &"; initial catalog=" & database & "; user id="& login & "; password=" & pass)
 
If connected = True Then
msg.FontColor=0,0,255
msg.Text="server has been connect "
Else
msg.FontColor=255,0,0
msg.Text="Unable to connect to server"
 
Inbound.Enabled=False
Qutbound.Enabled=False
End If
End Sub

 

[alanyu]

Unable to connect

Erel，Can you help me……pls

 

[Erel]

I'm sorry but I never worked with the MSSQL library. Are you sure that the device is correctly connected to the network?

 

[alanyu]

I'm sorry but I never worked with the MSSQL library. Are you sure that the device is correctly connected to the network?

Device has been connected to the network,Other programs can access the network.I wrote the program can't access.But tests on the computer can be connected to the network,Do you know why?

 

[Erel]

Sorry but I don't know why it doesn't connect.

 

[agraham]

Try using the server IP address and not it's name. Computer names don't always seem to get resolved properly on Windows Mobile for reasons I do not understand.

 

[alanyu]

Try using the server IP address and not it's name. Computer names don't always seem to get resolved properly on Windows Mobile for reasons I do not understand.

Sorry but I don't know why it doesn't connect.

Thanks Buddy.
Seems wm5.0 no open port 1433,the wm6.0 test can be connected.