I am trying to upgrade my server from SQL 2000 to SQL 2003 and am having some trouble with an application that talks to the SQL server from Access 2003 using VBA code. The code works fine on the 2000 server, but I am getting login errors when I use it on the 2005 server. Is it as simple as changing a connection string? I have tried a few, but have not had any success. Here is a snippet of the code - I hope someone can help! I get the error at the conn.Open command. Thank you!
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=sqloledb;Data Source=datacruncher;" &_
"Initial Catalog=mmcsdb;Integrated Security=SSPI;"
strInitial = Form_frmInitialize.cboOrdProd.Column(1)
strsql = "if exists (select * from sysobjects " & _
"where name = 'vwomit" & strInitial & "') " & _
"drop view vwomit" & strInitial & ""