connection problem?

[baran121]

hi i use sql server 2005 express.
i have connection problem with client to server.
i make surface area configurations. but still have problem.
computers which i use for sql 2005 express
have xp home edition.

i got the problem with connection. when i want to connect to server i got undefined error.
my connection string for 2000

With cnn
.CursorLocation = adUseClient
.ConnectionString = "provider=SQLOLEDB;server=" & server_adi & ";uid=" & Text2.Text & ";pwd=" & Text1.Text & ";database=" & database_adi
.Open
End With

my connection string for 2005 express
With cnn
.CursorLocation = adUseClient
.ConnectionString = "Provider=SQLNCLI;Server=" & server_adi & ";Database=" & database_adi & ";Trusted_Connection=yes;"
.Open
End With



please help me.

 

[baran121]

and i asked this problem in

http://www.tek-tips.com/viewthread.cfm?qid=1556763&page=1

 

[baran121]

i tried to ping to server

ping 192.168.1.2

and it is ok.

but telnet doesnt work.

telnet 192.168.1.2 1433

what is problem ?

 

[baran121]

i got the error.
it is about fire wall.
i close fire wall and i can connect now.
i opened fire wall and give permission for only 1433 port. but couldnt connect to server.
what can i do?

 

[mutley1]

Is 1433 your default port?

Also, in your connection strings, SQL 2000 seems to use a username and password and the 2005 is Trusted Connection = Yes.