Can a full file path be used to open a sql database connection?

I have a requirement to open an unattached sql server database file with a given path. Can this be done?
This would be similar to opening a Jet database using the path as the Data Source.  For example, the path might be "C:\MyFolder\MyDatabase.mdf".  I need to put the path in the connection string and open the database.  It would look something like the following.
Provider=SQLOLEDB;Data Source=C:\MyFlolder\MyDatabase.mdf;Itegrated Security=SSPI;
Rob E.