robtyketto
Member
- Joined
- Jul 23, 2009
- Messages
- 23
- Programming Experience
- Beginner
Greetings,
I have encrypted my jet database (access 07) and to avoid hard coding my connection within the .net code, created a connection string in the application settings.
I discovered in the choose database source wizard has a tickbox "Remember password" is a red herring as it really doesnt save the password.
The test connection works, but you can't save the password, so my application has runtime errors.
Im a newbie but had a sneaky peek in the app.config and could see no password details.
Can anyone please advise if storing the connection string is a suitable way to avoid hardcoding it within the code and if it is how do I save the password to allow a connection?
Going slightly off topic, when I add the database (.accdb) to my project in the main application directory for publishing reasons its copied over to the release directory upon running the app.
For deployment purposes I assume that I should add files in the application folder from the main app directory and not reference those in the release directory?
Hope this problem is easy to understand
Thanks
Rob
I have encrypted my jet database (access 07) and to avoid hard coding my connection within the .net code, created a connection string in the application settings.
I discovered in the choose database source wizard has a tickbox "Remember password" is a red herring as it really doesnt save the password.
The test connection works, but you can't save the password, so my application has runtime errors.
Im a newbie but had a sneaky peek in the app.config and could see no password details.
Can anyone please advise if storing the connection string is a suitable way to avoid hardcoding it within the code and if it is how do I save the password to allow a connection?
Going slightly off topic, when I add the database (.accdb) to my project in the main application directory for publishing reasons its copied over to the release directory upon running the app.
For deployment purposes I assume that I should add files in the application folder from the main app directory and not reference those in the release directory?
Hope this problem is easy to understand
Thanks
Rob