This has got to do with the fact that the provider is hard-wired to OLEDB1 through the Data Link dialog. Up until now, there was always an option to select SQL SERVER (.NET Default Data Provider for Sql Server).
For Some reason I don't have that option and although I can download every other provider, this one does not exist for download.
someone help, if you can and good luck as I have tried endlessly to fix.
NO LUCK STILL - ADO.NET PROVIDER NOT AVAILABLE ON MY MACHINE
Jon Limjap
BRUNO - You say "reinstall the Microsoft Data Access Component for the SQL Server Connection". How is this done This is most likely what I am looking for.
thanks,
Jdonahue1971
Iggy2
jdonahue1971,
In this situation, I suggest you to install the .NET SDK again for the first step. For the second step, could you tell me the version of your .NET Framework and IDE for developing You can also have a try to reinstall the Microsoft Data Access Component for the SQL Server connection.
If you are using Visual Studio 2005, I also suggest you to install the SP1 for this IDE.