I am relatively new in ASP and need to switch from username+password ADODB authentication to integrated authentication ADODB.
My database is MSSQL 2005
My username+password ADODB authentication looks like this. And it is included in all my ASP sites.
Can someone please tell me how to change the code so it works with authentication to integrated authentication ADODB?
And do I have to change other parts in my code as well or only this part?
Set CS = Server.CreateObject("ADODB.Connection")
query = "SELECT * FROM tablename"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open query, CS