Database

I have a SQL query connected to a data source and to a database component on a form.
I have turned the login prompt to false on the database component so I dont receive a login box when I activate the query.

My problem is that I still receive a login box even though I have carried out the above. Am i missing something?

I am using Delphi 5 Professional and the query is performing a select on a SQL Server system.

Any suggestions would be great.
Thanks
Sct
SCOTT78Technical AdvisorAsked:
Who is Participating?
 
shaneholmesCommented:
Thats because your database requires a login, even though you shut it off, by telling the LoginPrompt = false


Try passing the login info using the Params property of the database.

You can set it at design time,

or

runtime

here is an example:

{------------------------------------------------------------------------------}
function TAdmin_DataModule.Connect_Database(aServer, aUserName,
aPassword : string; aDatabase : TDatabase) : Boolean;
var
 TmpStrList : TStringList;
begin
 TmpStrList := nil;
 Result := True;
   try
    TmpStrList := TStringList.Create;
    TmpStrList.Add('SERVER NAME=' + aServer);
    TmpStrList.Add('USER NAME=' + aUserName);
    TmpStrList.Add('PASSWORD=' + '');
    aDatabase.Params.Assign(TmpStrList);
   finally
    try
     aDatabase.Connected := True;
     Result := aDatabase.Connected;
     TmpStrList.Free;
    except
     Result := False;
     aDatabase.Connected := False;
     TmpStrList.Free;
    end; {try except}
   end;

end;
0
 
kretzschmarCommented:
is your query bound to the tdatabase?
(property databasename -> select here the name of the tdatabase)

meikl ;-)
0
 
calinutzCommented:
You probabely placed the Database component on a form ... and not on a DataModule and you probabely placed another query component on another form. You should place all the data acces components (query, table, database, datasources) in a DataModule and try to see if you get the login prompt.
 Cheers.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
calinutzCommented:
And of course you must obviously link the form that uses the query with the data module.

Calinutz
0
 
meadorjCommented:
Also if your dbms requires a uname and password then you will have to set those properties for the database.  I think you can set them at design time but I know you can set them at run time like was poseted above.
0
 
shaneholmesCommented:
SCOTT78, yoy might want to try being a liitle more hospitable with your grading.

If you didn't get the answer you wanted, hold off until you get it. ( question = 1 day old)

Experts may not answer your questions if you are gonna grade in the fashion you do.

Shane
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.