ADO.NET Entity Data Model for ODBC Connection

  • Thread starter Thread starter TAN TH
  • Start date Start date
T

TAN TH

Guest
Using Visual Studio 2010, Professional Edition, in my Server Explorer, there are listed 4 Data Connections, but when I Add New Item to my existing project, with ADO.NET Entity Data Model, on the Entity Data Model Wizard, Generate from database, I have only 3 Data Connections as below:

ac3233117447b90d575b7c9044640104._.jpg


When I click the New Connection button, I am only shown the below Data Source, without the Microsoft ODBC Data Source.

But with Data Connection at Server Explorer, Add Connection, it gives below with the Microsoft ODBC Data Source.

5c0970c89a5a35a683c8b0cc4297f316._.jpg


http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx mentions

The .NET Framework Data Provider for ODBC requires MDAC 2.6 or a later version, and MDAC 2.8 SP1 is recommended. You can download MDAC 2.8 SP1 from the Data Access and Storage Developer Center.


I have downloaded and run MDAC 2.8 SP1 from

http://www.microsoft.com/en-sg/download/details.aspx?id=5793

I am still not able to add ADO.NET Entity Data Model for my ODBC Connection.

Please help.




Continue reading...
 
Back
Top