codemorphis.com Forum Index codemorphis.com
Software development: pure and simple.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Database

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    codemorphis.com Forum Index -> Visual Programming Forum
View previous topic :: View next topic  
Author Message
gavin



Joined: 08 Sep 2004
Posts: 28

PostPosted: Sun Oct 10, 2004 3:34 am    Post subject: Database Reply with quote

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
View user's profile Send private message Send e-mail
CodeMorphis



Joined: 02 Dec 2003
Posts: 252

PostPosted: Sun Oct 10, 2004 6:00 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
gavin



Joined: 08 Sep 2004
Posts: 28

PostPosted: Mon Oct 11, 2004 3:48 am    Post subject: Reply with quote

Yes it helps a great deal.

Thank's

Gavin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    codemorphis.com Forum Index -> Visual Programming Forum All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group