<div>
There are few possible authentication levels. You can set database level authentication - like in MS SQL, Sybase, Oracle, ... You can set application level authentication - where you make custom form and allow user to enter username/password. For database level authentication - your TDatabase component should have property LoginPrompt set to True - if you want to show login form or set it to False and put in Params list values for USER_NAME and PASSWORD. Do not put any authentication parameters in any BDE fields.
</div>


There are few possible authentication levels. You can set database level authentication - like in MS SQL, Sybase, Oracle, ... You can set application level authentication - where you make custom form and allow user to enter username/password. For database level authentication - your TDatabase component should have property LoginPrompt set to True - if you want to show login form or set it to False and put in Params list values for USER_NAME and PASSWORD. Do not put any authentication parameters in any BDE fields.

<div>
<div class="content wysiwyg-content">
Hi: I have a delphi program (BDS2006) which pulls data from our sage line50 accounting system via bde. I would like to schedule the program for out of hours but currently I am required to login. Is there a 'connection string&quot; (I looked it up! I am a delphi novice but it is great for paradox tables!) that I should write that puts in the password. Say the database in bde is called &quot;sage50&quot; and i login is as say 'manager' with password 'poop'. I have inserted 'manager' in the user name field of the database in bde but there is nowhere for password to be so preset. Can this be done?<br />
Thanks!
</div>
</div>


Hi: I have a delphi program (BDS2006) which pulls data from our sage line50 accounting system via bde. I would like to schedule the program for out of hours but currently I am required to login. Is there a 'connection string" (I looked it up! I am a delphi novice but it is great for paradox tables!) that I should write that puts in the password. Say the database in bde is called "sage50" and i login is as say 'manager' with password 'poop'. I have inserted 'manager' in the user name field of the database in bde but there is nowhere for password to be so preset. Can this be done?
Thanks!

automatically logging in via bde delphi

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.