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.mcint...@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.
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
