:eek2:Hi Please can u see the attached attaching database problem i am just new to This Please guide me.
thanks
Printable View
:eek2:Hi Please can u see the attached attaching database problem i am just new to This Please guide me.
thanks
You can't have two databases of the same name attached to SQL. The error is quite clear... you already have a database that is the same name as the one you are trying to attach.
-tg
Welcome! :wave:
Where is the D: drive? Did you attach any other databases that way?
NO actually i attached that database from a remote Area now i deleted it from the Visual Studio and i want to attach again but i am getting this message is it possible that i can know where the information is still saved which is not allowing me to attach. Thanks Please i am just new to this, it does not matter even i attach from the same remote area or from the D: Drive local drive i get the same message.
Jsut because you deleted it from VS doesn't mean you deleted it from the database server... you just simply removed it from the data source explorer.
-tg
As techgnome mentioned, you probably deleted the link to your DB in visual studio. DB is probably still attached in SQL server. In your add-a-connection dialog, choose "Select or enter a database..." instead of "Attach a database"
Also, in future, it is probably a good idea to use a particular database name instead of auto-name.
First of all thanks
DataBase Name is CAD_Data_Base.mdf
when i select the databse i get this message, remember that i have sql server running.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Please i have one more question but it is very important
when i import a MS Access Data base from remote area like \\10.0.0.155\V-Schedule\CAD_Data_Base.mdf to mdb file why the destination place of the file is changed i want the file to stay in the same place.
THanks