<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>Setting Database</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Hi</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">This may be dumb</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">question</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">, but I just can</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t think what</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">s wrong, but I have an application which uses an ODBC</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">settings</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">definition to an SQL database. I want to run a stored procedure on the database and</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">i</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t works fine i</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">f</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial"> I have the</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">‘</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">change the default database to</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial"> set</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">i</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">n the ODBC</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">setting, but if I don</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t select one it won</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t run because it says it can</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t find the sp. I</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">m assuming that</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">it</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">s</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">because there is no specific database it</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">s pointing too when opening the connection,</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">so</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">it just uses Master and of course</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">the sp</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">won</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t be in there.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">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</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t like that.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">So how do I set the specific database I want access the field on the</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Arial">componen</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">t or setting some parameters?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Regards</FONT></SPAN></B></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Eion McIntosh | Business Systems Analyst |</FONT></SPAN></B><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT SIZE=1 FACE="Arial"> Silver Fern Farms</FONT></SPAN></B><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial"> Limited</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><BR>
</SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial">199 - 201 Cashel St</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT SIZE=1 FACE="Arial"></FONT></SPAN></B><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"> <FONT COLOR="#808080" SIZE=1 FACE="Arial">|</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial"> PO Box 283, Christchurch 8041, New Zealand</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"><BR>
</SPAN></B><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Tel</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial"> +64 3 371 6725</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"> <FONT COLOR="#808080" SIZE=1 FACE="Arial">| Fax</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial"> +64 3 366 4412</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"> <FONT COLOR="#808080" SIZE=1 FACE="Arial">| Mob</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=1 FACE="Arial"></FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT COLOR="#808080" SIZE=1 FACE="Arial">+64 27 221 1438<BR>
</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Email</FONT></SPAN></B><SPAN LANG="en-nz"> </SPAN><A HREF="mailto:eion.mcintosh@silverfernfarms.co.nz"><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><U></U></SPAN><U><SPAN LANG="en-nz"></SPAN></U><U><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=1 FACE="Arial">eion.mcintosh@silverfernfarms.co.nz</FONT></SPAN></U><SPAN LANG="en-nz"></SPAN></A><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial"> Web</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=1 FACE="Calibri"></FONT></SPAN><SPAN LANG="en-nz"> </SPAN><A HREF="http://www.silverfernfarms.co.nz/"><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><U></U></SPAN><U><SPAN LANG="en-nz"></SPAN></U><U><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=1 FACE="Arial">http://www.silverfernfarms.co.nz</FONT></SPAN></U><SPAN LANG="en-nz"></SPAN></A><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT COLOR="#384802" SIZE=1 FACE="Arial">Silver Fern Farms - 100% Made of New Zealand</FONT></SPAN></B></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT COLOR="#808080" SIZE=1 FACE="Arial">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.</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> </SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><BR>
</SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN></P>
</BODY>
</HTML>