C#.NET path error. Please guyzz. its urgent

Hari M

I ve created a C#.NET Project in my PC. I used MS Access as Database. When I tried to copy and run the same project in other PC's its showing path error.

I tried using Application.StartupPath() in my connection string path. But while using it the database is empty as soon as i stopped running the project. Somebody please help me.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Kumar11y ago
Hi

It seems that your database is not accessible to your project using the connection string which you are providing. .. chech this point

Thanks
Hari M11y ago
Yep. Sujeet. I ve gone through it. I used it in my project. first time it is running fine. but when closing the application and restarting , all the data stored in database during the first time is not available.
Sujeet Suman11y ago
Hari have you gone through my reply?
Hari M11y ago
I can't quite understand it. can u please explain me. please
Mukesh Kumar11y ago
Hi,

This issue comes when the path does not exists on the system. so, please check that the path which you are providing for first system is exists on other system or not.

Hope this will help you.
thanks
Sujeet Suman11y ago
Hari as per my understanding & experience when we are developing a software then always we should think dynamically.

Write the connection string like below: -
   Data Source = MS-Access_File.accdb" name = "myConnectionString"/>

Use in your application like below: -
using(OdbcConnection myConnection = new OdbcConnection())
{
   myConnection.ConnectionString = myConnectionString;
   myConnection.Open();
   //execute queries, etc

}

Create a new folder like MYAPPLICATION & put your MS-Access file & EXE in that folder. So your MS-Access file & EXE will be in same directory.

When we are developing a software then always we should take care of standards.

If this is helpful for you then please accept my Answer.
Srinivas Rao11y ago
connection.Connection String=@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source= give the path name here";Persist Security Info=False;
Hari M11y ago
string Connstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Hari\Documents\Visual Studio 2013\Projects\newLIB\Lib2\Mine.accdb";

my path is like this. but when i tried to copy and run this project in other PC. I need to change the path according to that PC. is there any method to avoid doing that?
Srinivas Rao11y ago
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
mention the path of database u created, [eg..,as I mentioned above]
can u try this...