I have a vb6 app that uses a sql server express database. Suddenly I am having difficulty opening it. Here is what I use to open the db:
sWhichSrvr = lstWhichComp.Text
Set conn = New ADODB.Connection
If sWhichSrvr = "Remote" Then
conn.Open "Provider=SQLNCLI10;Server=" & sWhichSrvr & "\SQLExpress;Database=VIRA;Trusted_Connection=yes;"
Now I get an error when I try to access the db. What might cause that to change? Antivirus? Malware? I don't think I have added any of that since last use.
Thanks so much!!