How to connect ".mdf" file - URGENT

[ajewahar]

Dear all,

I have detached a file from SQL server which is "pubs.mdf".

Now, I need to open an ADO or ADO.NET connection from VB 6.0 or VB.NET application to "pub.mdf".

I do not have SQL Server or MSDE installed on the client machine. Is there any way that we can open a connection to "mdf" file without having any datbase engine on client ?

Kindly advise..

 

[Administrator]

You will need SQL Server/MSDE, attach the DB, then open it via ADO.NET, etc.