Member Avatar for anup.maverick

Hi,

I am using asp.net 2.0, SQL 2005 Express Edition.

I have created one database, thats working fine on local host.

But when I transfered files to my hosting server, Then its giving me Error:-
Invalid value for key 'attachdbfilename'.

My connection string is as follows:-

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|DataTestingServer.mdf;Database=DataTestingServer;User Instance=true


Please Help me.

Anup

  • 3 Contributors
  • 3 Replies
  • 1K Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by kaar3k
Member Avatar for ajijacobm

you can write right click the database(mdf) file in the database(server) explorer and click properties..on the right side, you can view the properties window,Which you can get the connection string....
eg;
Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Jacob Varghese\My Documents\Visual Studio 2005\WebSites\sample\App_Data\Database.mdf;Integrated Security=True;User Instance=True
you copy all that and use

string connectionstring="Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True";
Edited by ajijacobm because: n/a
Member Avatar for ajijacobm

if you got it correct,please mark it as solved.

Member Avatar for kaar3k

if you got it correct,please mark it as solved.

even i was having the same prob,,, it helped me in solving thanks bro :))))

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.