Create Database Connection in the C#.net
I have database named 'Marketing', and want to bound DropDownList control with it using 'add connection' dialog box in the C#.net.
I gave datasource: 'Microsoft SQL Server Database File (SqlClient)'. And when I give DataBase file name as 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Marketing_Data.MDF', I get error while testing the connection:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that
under default settings SQL Server dose not allow remote connections. (Provider:SQL Network Interfaces, error: 26-Error Locating Server/Instance specified)".
So what DataBase File name I should give here for completing the database binding?