2

This week I have installed the Visual Studio 2015 Community and Microsoft SQL Server 2014 Express.

I am trying to connect on my databases using the option Tools > Connect to Database, selecting Microsoft SQL Server on list, and I am not able to find my server name and databases, same after trying to write manually my server name and instance.

I read on the data provider description that the data provider is used only for 2005 or above. So, I installed the Microsoft OleDB 2 version 5, but I am not able to find my databases yet.

Do you have any suggestion of what do i need to do to be able to connect on it?

shA.t
  • 16,580
  • 5
  • 54
  • 111
raddesso
  • 169
  • 7
  • 14
  • 1
    Vs2015 and SQ2014 should have no issues connecting to each other, support is native in .NET. Is SQL Express running? Is the SQL Browser service on your machine running? Can you connect to it with SQL Server Management Studio Express? – jessehouwing Jan 15 '17 at 15:00
  • You should not need to rely on OleDB at all, the System.Data.SqlServer is all you should need. That and possibly the SQL Server Client Libraries which should have been installed with SQL Server Express. – jessehouwing Jan 15 '17 at 15:01
  • 1
    Note that OLE DB is deprecated. Always use the .NET Framework Data Provider for SQL Server (SqlClient) in managed code. – Dan Guzman Jan 15 '17 at 15:02
  • Wasn't i be able to connect without use a managed code using Connect to Database function? – raddesso Jan 17 '17 at 01:47

0 Answers0