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?
Re: mssql 2000 connect but 2005 not connect
Re: mssql 2000 connect but 2005 not connect
Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)
Re: mssql 2000 connect but 2005 not connect
Quote:
Originally Posted by
akhileshbc
i know connectionstring site but i've tested all the links in there as :(
Re: mssql 2000 connect but 2005 not connect
When you try to connect what does it complain? May we see your connectionstring?