View previous topic :: View next topic |
Author |
Message |
gavin
Joined: 08 Sep 2004 Posts: 28
|
Posted: Sun Oct 10, 2004 3:34 am Post subject: Database |
|
|
Hi,
I need to set a password for my database but my application cannot access the database because of the password. How can I go about this?
Regards
Gavin |
|
Back to top |
|
|
CodeMorphis
Joined: 02 Dec 2003 Posts: 252
|
Posted: Sun Oct 10, 2004 6:00 pm Post subject: |
|
|
Gavin,
Let's suppose your database password is abc123.
Then set the two input data ports of the "Connect" service for the Access Database component as follows:
Input Data Port 0:
Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=abc123;Data Source=
Input Data Port 1:
PATH_TO_YOUR_DATABASE
Note that you can also construct the password and path arguments dynamically, i.e. at run-time of the program and then pass the argument strings to the input data ports. This of course, is normal treatment of data in Synopsis.
As well, the argument in input data port 1 is optional - if you leave it empty you can specify the entire connection string in input data port 0. So you could specify it in input data port 0 as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=abc123;Data Source=PATH_TO_YOUR_DATABASE
Hope that this helps. |
|
Back to top |
|
|
gavin
Joined: 08 Sep 2004 Posts: 28
|
Posted: Mon Oct 11, 2004 3:48 am Post subject: |
|
|
Yes it helps a great deal.
Thank's
Gavin |
|
Back to top |
|
|
|