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".
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".
Hi,
Please check whether your've submitted the duplicated database, if yes, please remove and re-try to attach.
akkemraju
Member
2 Points
20 Posts
Establishing connection with server
Feb 02, 2013 09:17 AM|LINK
Hi friends,
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.
Thank you.
rimagandhi
Participant
1585 Points
509 Posts
Re: Establishing connection with server
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
Regards
Rima Gandhi.
Software Developer.
akkemraju
Member
2 Points
20 Posts
Re: Establishing connection with server
Feb 02, 2013 11:01 AM|LINK
Hi,
My local database name is dbtest.mdf.
Thank you.
rimagandhi
Participant
1585 Points
509 Posts
Re: Establishing connection with server
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
Regards
Rima Gandhi.
Software Developer.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Establishing connection with server
Feb 04, 2013 12:22 AM|LINK
Hi,
Please check whether your've submitted the duplicated database, if yes, please remove and re-try to attach.
akkemraju
Member
2 Points
20 Posts
Re: Establishing connection with server
Feb 04, 2013 05:56 AM|LINK
Hi,
I modified the database name,still i am getting the same error.
Thank you.
akkemraju
Member
2 Points
20 Posts
Re: Establishing connection with server
Feb 04, 2013 06:02 AM|LINK
Hai,
I write my connection string as
"con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=ftp://raju@192.168.0.50/databasetest/databasetest/bankdb.mdf;
Integrated Security=True;User Instance=True";"
is it connect to server or we need to give any credentials?
Thank you.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Establishing connection with server
Feb 04, 2013 06:02 AM|LINK
Restart your Server site and re-build your app and have a try.
rimagandhi
Participant
1585 Points
509 Posts
Re: Establishing connection with server
Feb 04, 2013 07:09 AM|LINK
According to the connectionstring it seems that the database is in App_Data folder.
Is it true?
Regards
Rima Gandhi.
Software Developer.
akkemraju
Member
2 Points
20 Posts
Re: Establishing connection with server
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.