Solved

Disable ODBC logon prompt

Posted on 1998-10-19
3
522 Views
Last Modified: 2010-04-06
Hi there,

I would like to disable (not display) the logon prompt when connecting to a MSaccess DB with ODBC.

How do I do this?

Thanks

Later
Jay
0
Comment
Question by:hulsej
3 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 40 total points
ID: 1343339
hi hulsej again,

use the TDatabase Component,
give on the Property DataBaseName a name
give on the Property AliasName the Name of the Alias you want to use

on the TTable(s) and/or TQuery(s) Components you use the Property DataBaseName should have the same entry as TDataBase.DataBaseName.

Now you can use Following code :

procedure TForm1.Database1Login(Database: TDatabase;
  LoginParams: TStrings);
{The Event OnLogin from TDataBase}
begin
  LoginParams.Values['USER NAME'] := 'YourUserName';
  LoginParams.Values['PASSWORD'] := 'YourPassWord';
end;

procedure TForm1.BitBtn1Click(Sender: TObject);
begin
  {Connect Now}
  database1.connected := true;
  table1.open;
end;

good luck on the try

Meikl
0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1343340
hey, ... what's this? I entered an answer and now it's gone...? Anyway it was the same as kretzschmar... so I couldn't give you more advise then he does. Regards, Zif.
0
 

Author Comment

by:hulsej
ID: 1343341
Thanks again, it worked fine.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ddeman not working in activex 3 103
How to fill array with TArray.Create? 14 87
add combobox item based on numbers 9 141
Sending files from  idTcpServer Socket to idTcpClient 2 39
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now