Device Activation Error

Question

Hi,
Iam using Sql 2000 as Back End
Iam attaching Database at runtime.
I have used foll code to attach database:
vConn.ConnectionString = "Data source=Localhost;uid=" + UID + ";pwd=" + UPWD + ";database=Demo;AttachDbFileName=|DataDirectory|Demo.MDF;";
But while running code it giving me foll error:
Device activation error. The physical file name 'C:\Documents and Settings\admin\Desktop\Demo\Demo\bin\Debug\Demo.MDF' may be incorrect.
Could not attach database 'Demo' to file 'C:\Documents and Settings\admin\Desktop\Demo\Demo\bin\Debug\Demo.MDF'.

Plz help me out!

Sam Hobbs · Answer

Suthish, is that not where Visual Studio puts databases when we take the default, which is to copy the database to our project each time the project is built? I think it is normal for the database to be in the Debug folder. I can't be sure because I usually don't use the default but I have a few projects with mdb files in the Debug folder. The connection string is using " |DataDirectory| ", which is very normal. The problem is that the rules for determining what that means (what that directory is) is quite complicated. I think it is very normal for it to be the debug directory for the project, so if the path and filename for the mdf file are correct, the problem must be something not shown here. I just don't know where to look, but I think it is best to first ensure that the path and filename are correct.

Suthish Nair · Answer

Why you keeping the database file in debug folder. Move it to the Project folder.

Pravin Ghadge · Answer

This code is used in Window application My querry is not resolved

Pravin Ghadge · Answer

Thanks 4 u reply I have check path but it is correct

Suthish Nair · Answer

Praveen, Your query resolved?

Sam Hobbs · Answer

Are you sure your project is in: C:\Documents and Settings\admin\Desktop\ Demo \ Demo Note that there are two folders with the name "Demo". That is possible and it can work and there is nothing wrong with that if you want that, but it seems suspicious to me. It might not be the correct path for your project.

Suthish Nair · Answer

Web or windows application?

Madhu K · Answer

Check the properties security of the folder check the account which you are using like Administrator, IIS_WPG.. give the permissions Read Execute Write.

Pravin Ghadge · Answer

Thanks 4 ur reply. But i dont know hw 2 check permissions for accessing the file.

Madhu K · Answer

It seems to be permissions issue check the permissions for accessing the file.

Device Activation Error

Bechir Bejaoui

egi roka

Bechir Bejaoui