c# - How to make SQL Server Connection (not from file) appear in ADO.Net Connection Model Wizard? -


i trying add connection adventureworks on new development machine running vs 2010. have ssms running , able query adventureworks database. however, when click “new connection” (steps followed below after *) , not see sql server connection option. there way configure vs 2010 sees localhost connection sql server?

second option: when try using option microsoft sql server database file, whenever browse mdf file adventureworks, see message 'file in use', though have 1 instance of vs 2010 open , ssms closed.

  • steps followed new project class library right click solution explorer add new item ado.net entity data management new connection

just type in localhost server name, test connection , click ok. saved, next time appear in list.

  • the data source type set "microsoft sql server (sqlclient)"

if doesn't pop in screen install sql server native client here: http://msdn.microsoft.com/en-us/sqlserver/ff658533.aspx


Comments

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

jquery - Clone last and append item to closest class -

c - Unrecognised emulation mode: elf_i386 on MinGW32 -