How to set up ODBC connections to SQL Server Database file (.mdf)?

[#1]

Hi,

I have a local SQL Server Database file (Data.mdf) and a local SQL Server Log file (Log.mdf).

What driver do I use to set up ODBC connections?

I tried SQL Server, following steps as this page http://www.geekstogo.com/forum/ODBC-connection-error-t188228.html

But I am still facing errors, please see attached files.

Could someone please tell me how to set up .mdf and .ldf step by step? Thank you in advance.

[stevedark]

You can't connect directly to these files, they need to be attached to a running SQL server.  I believe it is possible to attach these files to an existing SQL Server instance.  You will need to search for how to do that on Microsoft's knowledgebase - it is not something I have had to do for some time now.

- Steve

[#3]

We need a local sql server express toolkit should be installed in the computer where you want to configure the ODBC connection.

Regards,

P.Prasath