Hi Expert,
Hi I have been trying all day to connect to my local sql-server database using ODBC but I seem to be missing something because every time I am trying to conenct I get this error:
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "Library.mdf" requested by the login. The login failed.
my source code as following
private string connectionString;
public LibraryRepository()
{
connectionString = @"Driver={SQL Server};Server=(local);Trusted_Connection=Yes;Database=Library.mdf;";
}
public IEnumerable<Book> GetPersonDetails()
{
using (var conn = new OdbcConnection(connectionString))
{
conn.Open();
using (var command = new OdbcCommand("SELECT * FROM Books" , conn))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
yield return new Book()
{
Id = (int) reader["Id"],
Name = (string)reader["Name"],
Author = (string)reader["Author"],
Description = (string)reader["Description"],
Price = (string)reader["Price"],
CategoryId = (string)reader["CategoryId"]
};
}
}
}
}
I am not really sure that the conenction string is ok when I look at the properties of the database at connection string I see this line :
Data Source=(local);Initial Catalog=Library;Integrated Security=True
But if I add this line as the connection string I get this error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
In order to veify if the data source is ok I logged into SSMS with (local) server name and it works I can also see my database there.
I have also set NT AUTHORITY\NETWORK SERVICE as the db_owner after reading a blog about this issue but still I get the error Cannot open database "Library.mdf" request by the login.
I am not really sure what to do next to solve this problem.Can anyone provide some suggestions?
Anonymous User
30-Sep-2014Anonymous User
19-Jun-2013