[DUG] Setting Database

[Eion McIntosh]

Hi

This may be dumb question, but I just can't think what's wrong, but I
have an application which uses an ODBC settings definition to an SQL
database. I want to run a stored procedure on the database and it works
fine if I have the 'change the default database to' set in the ODBC
setting, but if I don't select one it won't run because it says it can't
find the sp. I'm assuming that it's because there is no specific
database it's pointing too when opening the connection, so it just uses
Master and of course the sp won't be in there.
I have parameters setup for the username and password, which are fine,
so I have tried putting in a new one DATABASE and giving it the name,
but it doesn't like that.
So how do I set the specific database I want access the field on the
component or setting some parameters?



Regards

Eion McIntosh | Business Systems Analyst | Silver Fern Farms Limited
199 - 201 Cashel St | PO Box 283, Christchurch 8041, New Zealand
Tel +64 3 371 6725 | Fax +64 3 366 4412 | Mob +64 27 221 1438
Email eion.mcintosh at silverfernfarms.co.nz  Web
http://www.silverfernfarms.co.nz <http://www.silverfernfarms.co.nz/> 
Silver Fern Farms - 100% Made of New Zealand
This email (including any attachments) is confidential. If you have
received it in error, please let us know immediately by return email and
delete it from your system.
	



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100806/dfa8a24e/attachment.html