Hello, good morning, my colleagues, I am trying to create a connection string through a program. The problem I have is that when I add the string and I tell the application to connect it gives me the following error.
It is not a valid file name.
The chain I'm using is this one.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|muestra.accdb;Persist Security Info=False;Jet OLEDB:Database Password=datos2017
If I use the following connection string it tells me that I must have the file or the DB in C: \
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\muestra.accdb;Persist Security Info=False;Jet OLEDB:Database Password=datos2017
And if I use this string it tells me that I have to have the connection file in C: \ Windows \ System32 \
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=muestra.accdb;Persist Security Info=False;Jet OLEDB:Database Password=datos2017
How can I make this connection chain know that the file it shows is in the installation folder and not somewhere else? I also use MapPacht and nothing if someone can guide me or help me in some way I would appreciate it
By the way, what I'm doing is built on logger radbuilder, which is kind of like a quick constructor of basic applications.
Greetings and Thanks.