What's wrong with database? Can anybody help? [modified]

[Badboy22TR]

I use InstallShield for my project. My project has database, i put it to Install Shield's "Application Folder", although i changed the connection string "c:\Documents and Setting\bla bla bla\xxx.mdb" to "xxx.mdb" (software runs my computer well with this string), i don't run it correctly on an another computer after installed it. It crashed when program tried to reach database. An error generated like this "c:\Documents and Settings\........\xxx.mdb couldn't be found". I don't understand :( Why it didn't work although i changed the connection string? Can anybody hel me please ? -- modified at 5:00 Saturday 31st March, 2007

[Sahir Shah]

Please see http://msdn2.microsoft.com/en-us/library/ms254499.aspx[^] Alternately you can also consider placing the .mdb file in the same folder as the application and use Application.StartupPath in your connection string.

[Badboy22TR]

Thanks for your reply. I tried to do your suggests. I find that the problem is dataset. However i changed the connectionstring in the forms, connectionstring in dataset remains. What i can do for it? Can i write a function to dataset.h? like " String^ path = Application::StartupPath; this->oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\""+path+"\\xxx.mdb\""; "

[Badboy22TR]

Ok..Finally i solved the problem. If anyone has the same problem, just replace the whole path (eg. "C:\Documents and Settings\XYZ\My Documents\Microsoft Visual Studio 2005\Projects\Release\") ConnectionString in Dataset Header with |DataDirectory| this->_connection->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"|DataDirectory|\\xxx.mdb\""; and if you have connection in form, write a simple code in Form_Load event, replace ConnectionString with something like : private: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e) { String^ path = Application::StartupPath; this->oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\""+path+"\\hasta.mdb\""; }