Attache DB with single file
Posted on 2001-09-05
I have an application that allows a user to perform extensive data mining functions on data warehouses. Currently I am using MSDE to serve as the platform to house the data extracted for analysis.
Now MSDE gives the user a SQL server on the desktop and the application works great.
When a user starts a new project, a template database is copied from a template library and registered in the SQL server using
This works just fine since the user is storing the database mdf file on the local machine, thus local server.
I am now trying to modify the code to be a networked client server type of application where the SQL server no longer the MSDE on the local machine, but on some server on the network.
Now I can get the template MDF copied to the network SQL server, but I cannot get the AttachDBWithSingleFile method to work since the dbFilePath is now a network location. SQL server hates this intensely.
I need to figure a way to attach this file to the SQL server using a file reference that is not a network reference.