February 29, 2004 at 6:37 pm
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?
March 1, 2004 at 10:33 am
If this is a ASP .NET web application then this newsgroup item might help you: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=1163d41c.0310170506.134be4a2%40posting.google.com&rnum=2&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3D.net%2Bsql%2Bprovider%2Bmdac%2B2.8%26sa%3DN%26tab%3Dwg
It looks like it was a security issue around identity impersonation.
Good luck!
[font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
Business Intelligence Administrator
MSBI Administration Blog
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply