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?
Thanks!
Thanks!
Delphi
Last Comment
Richard Teasdale
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
ASKER
Thank you very much!