Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 07, 2013 05:02 AM by Decker Dong - MSFT
Feb 02, 2013 09:17 AM|LINK
I developed a login form application.Validation with the local database is working properly.When i am trying to validate the login form with server database it is showing an error message like"An attempt to attach an auto-named database for file
ftp:\\192.168.0.55\Application\dbtest.mdf failed.A database with the same name exists,or specified file cannot be opened,or it is located on UNC share".
I am using Filezilla client server application.
Feb 02, 2013 10:55 AM|LINK
seems your database name has some common name which is there on the server.. What name are you using for your database
Feb 02, 2013 11:01 AM|LINK
My local database name is dbtest.mdf.
Feb 02, 2013 11:08 AM|LINK
Can you modify the name and its reference name all over the project and try..Also make sure you have your database stored up in the server
Feb 04, 2013 12:22 AM|LINK
An attempt to attach an auto-named database for file ftp:\\192.168.0.55\Application\dbtest.mdf failed.A database with the same name exists,or specified file cannot be opened,or it is located on UNC share".
Please check whether your've submitted the duplicated database, if yes, please remove and re-try to attach.
Feb 04, 2013 05:56 AM|LINK
I modified the database name,still i am getting the same error.
Feb 04, 2013 06:02 AM|LINK
I write my connection string as
"con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=ftp://firstname.lastname@example.org/databasetest/databasetest/bankdb.mdf;
Integrated Security=True;User Instance=True";"
is it connect to server or we need to give any credentials?
Restart your Server site and re-build your app and have a try.
Feb 04, 2013 07:09 AM|LINK
According to the connectionstring it seems that the database is in App_Data folder.
Is it true?
Feb 04, 2013 10:02 AM|LINK
No,database folder is not there in App_Data folder.
and one more thing is i am using Data Source =.\\SQLEXPRESS,in place of .(dot) symbol what i need to write??
Please tell me the syntax.