Avatar of Richard Teasdale
Richard Teasdale
Flag for United Kingdom of Great Britain and Northern Ireland asked on

automatically logging in via bde delphi

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?

Avatar of undefined
Last Comment
Richard Teasdale

8/22/2022 - Mon
Sinisa Vuk

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.
Geert G

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Richard Teasdale

Thank you very much!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes