Thread View: comp.lang.pascal.delphi.databases
2 messages
2 total messages
Started by Yossi Maish
Wed, 15 Mar 2000 00:00
DB login prompt
Author: Yossi Maish
Date: Wed, 15 Mar 2000 00:00
Date: Wed, 15 Mar 2000 00:00
14 lines
1428 bytes
1428 bytes
I realy need help about it. I guess it's a simple settings I have missed... I have a weird problem. I installed Delphi4 a while ago and always used Database Desktop creating & using DB files. Now I am trying to connect to MS Access MSB files from the SQL Explorer and when trying to expand the MS Access 97 Database I'm getting a login prompt. In fact any DB that I'm tring to expand requests a user & password which doesn't make sense in many cases. Surely not for the MS Access. The same happens if I try to access the DB using a TTable and specifying MS Access 97 Database. What's wrong? Yossi.
Re: DB login prompt
Author: Greg Martin
Date: Wed, 15 Mar 2000 00:00
Date: Wed, 15 Mar 2000 00:00
29 lines
1535 bytes
1535 bytes
I am not sure with your explorer but..... >The same happens if I try to access the DB using a TTable and specifying MS >Access 97 Database. >What's wrong? If you are already using a database component, then set the LoginPrompt property to False. If not, you will need to use one and point it to your alias, and then do the above. Actually you should always use a database component, as there is a limit on the amount of concurrent connections you can make without one, so it makes good sense. By the way, user names and passwords can be set on Access databases, so if this is the case. Set USERNAME=yourusername PASSWORD=yourpassword in the params strings list of the database component. Hope this helps, Greg.
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads