asked on

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

kretzschmar

is your query bound to the tdatabase?
(property databasename -> select here the name of the tdatabase)

meikl ;-)

ASKER CERTIFIED SOLUTION

shaneholmes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

calinutz

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.

calinutz

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

Calinutz

meadorj

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.

shaneholmes

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