<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span id="misspell-0" class="mark">fpODBC</span> 1.0.15</div><div> </div><div><span id="misspell-1" class="mark">DSN</span> = <span id="misspell-2" class="mark">fp</span>-<span id="misspell-3" class="mark">sqlserver</span></div><div> </div><div>Which one of the following two lines is correct? Both pass syntax check and will run when tested.</div><div> </div><div>Connection = new <span id="misspell-4" class="mark">ODBC</span>_CONNECTION("<span id="misspell-5" class="mark">fp</span>-<span id="misspell-6" class="mark">sqlserver</span>")</div><div> </div><div>or</div><div> </div><div>Connection = new <span id="misspell-7" class="mark">ODBC</span>_CONNECTION("<span id="misspell-8" class="mark">fp</span>-<span id="misspell-9" class="mark">sqlserver</span> ; ")</div><div> </div><div>The question
has to do with the semi colon at the end of the <span id="misspell-10">statement</span>.</div><div> </div><div>I am still trying to resolve why the connection sometimes fails. Then if you immediately run it again it works correctly.</div><div> </div><div>Thank you,</div><div>Rick Hane</div><div> </div></div></body></html>