mssql 2000 connect but 2005 not connect

hi
mssql 2000 the following code connecting...
cn.Open "Provider=SQLOLEDB.1;Password=" & sqlpass & ";Persist Security Info=false;User ID=" & _
sqluser & ";Initial Catalog=" & sqldataname & ";Data Source=" & sqlservername & sqlport & ","

but mssql 2005 not connection 2 authorization available
1. windows authorization
2. sql authorization

1. windows authorization by how connectionstring


another application connect but my application not connect :(

add sqlserver user and password i gave authorization after 1433 port open but not my application connect what could be the problem?

For connection strings: http://www.connectionstrings.com/ :wave:

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

Quote:

---

Originally Posted by akhileshbc

For connection strings: http://www.connectionstrings.com/ :wave:

---

i know connectionstring site but i've tested all the links in there as :(

When you try to connect what does it complain? May we see your connectionstring?