A .net project I had working for some time, suddenly is not, despite *nothing* having changed in the project nor the system (old story, I know). It simply involves reading from a SQL Server database, but is failing on the Open....(line 52)
Line 50: cmd.CommandType = CommandType.Text
Line 51: If conn.State = ConnectionState.Closed Then
Line 52: conn.Open()
Line 53: End If
Line 54: cmd.Connection = conn
The error message is one which had occurred some months ago but got resolved and I can't remember how.
The message reads "The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later."
This is despite the fact that I have MDAC 2.8 installed on my machine. Can anyone help please, as it's driving me crazy?