4 posts in this topic

Posted

i'm trying to use ado net entity framework 4 with visual studio 2010, but i'm having some issues. i've created a data connection to a remote sql server, and now i'm trying to create a data model, the wizard goes ok, up until the ending part when i'm presented with the following error:

Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)

'.

i've checked and remoting is working. i can browse the database using visual studio, but the model isn't configured. i've tried refreshing the model from database and the same problem occurs.

can anyone give some pointers on how to create the model without any issues?

thanks in advance

Share this post


Link to post
Share on other sites

Posted

Make sure your SQL Server instance accepts TCP/IP connections (seems to be disabled by default in Developer Edition) - you can check the status in 'Sql Server Configuration Manager' on the left side find 'SQL Server Network Configuration' then 'Protocols for <name of instance>' make sure TCP/IP is Enabled.

Share this post


Link to post
Share on other sites

Posted

tcp is enabled, i enabled as soon as i finished the instalation

Share this post


Link to post
Share on other sites

Posted

the problem is now fixed. it was it the mapping process, entity framework doesn't like huge databases. so mapping a huge database is pita

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.