MVC2: How to connect to ODBC datasource
I have built an ASP.NET classic application that references an ODBC connection to a DBISAM database.
When I try to connect to the same database in a MVC2 application I do not see any option to select an ODBC Data Source.
I right-click on my Models folder and select Add -> New Item
Choose "Data" on the left panel
Select ADO.NET Entity Data Model 开发者_运维问答 than click "Add"
Options were: ADO.NET Entity Data Model DataSet LINQ to SQL Classes SQL Server Database XML File XML Schema XSLT File
Select "Generate from database..... click "Next"
Here I am presented with a "Choose Your Data Connection" screen. When I click the "New Connection" button I am given a "Choose Data Source" screen.
I am only presented with the following options on the "Choose Data Source" screen:
Microsoft SQL Server
Microsoft SQL Server Compact 3.5
Microsoft SQL Server Database File
- This is where I expected to see ODBC as one of my options. What do I need to do to access ODBC?
Thank You for all help provided!
if you want to connect to Oracle be sure to use the Oracle ODP, http://www.oracle.com/technetwork/topics/dotnet/index-085163.html
精彩评论