Chart control won't populate due to invalid path

Asked Mar 21 '16 at 16:02

Active Mar 21 '16 at 16:36

Viewed 33 times

I can't populate my chart control due to invalid path exception, yet all my Database paths are correct in both App.Config and Settings.Designer.cs, the database is located in Bin\Debug\DB\Access.accdb.

App.Config:

connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB\maindb.accdb"

Settings.Designer.cs:

[global::System.Configuration.DefaultSettingValueAttribute("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\DB\\maindb.accdb")]

This is the path given in the error:

edited Mar 21 '16 at 16:36

asked Mar 21 '16 at 16:02

Omarrrio

1,075
1
16
34

What's the correct path? And what is the output folder of your project? – Gosha_Fighten Mar 21 '16 at 16:29
@Gosha_Fighten correct path is `C:\Users\Omar\Documents\Visual Studio 2015\Projects\Inventory And Costumer Manager\Inventory And Costumer Manager\bin\Debug\DB\maindb.accdb`, output as in Debug or Release ? – Omarrrio Mar 21 '16 at 16:37
In this case, you need to remove |DataDirectory| from the connection string. – Gosha_Fighten Mar 21 '16 at 16:39
@Gosha_Fighten ...that will just make the stuff more troublesome, also it doesn't work, it just makes the path `C:\DB\maindb.accdb` – Omarrrio Mar 21 '16 at 16:51
Where is the exe file located? Just right on C:? – Gosha_Fighten Mar 21 '16 at 16:52
@Gosha_Fighten `C:\Users\Omar\Documents\Visual Studio 2015\Projects\Inventory And Costumer Manager\Inventory And Costumer Manager\bin\Debug\` – Omarrrio Mar 21 '16 at 16:53
connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DB\maindb.accdb" Try like this. – Gosha_Fighten Mar 21 '16 at 16:54
@Gosha_Fighten Nope, same result, empty chart. – Omarrrio Mar 21 '16 at 16:56
Are you manually setting the "DataDirectory" variable to a custom path as described in http://stackoverflow.com/questions/12187068/where-is-datadirectory-defined ? – Gosha_Fighten Mar 21 '16 at 17:07
@Gosha_Fighten i do not remember doing so, and there is no trace of it in the form's code neither in the whole project. – Omarrrio Mar 21 '16 at 17:20

Chart control won't populate due to invalid path

0 Answers0