Martin Gainty wrote:
the error states your DSN is incorrect
if you fix DSN name to already configured DSN this should work..
Martin
That is just because DBD::ODBC calls SQLDriverConnect first (since it
accepts DSN=xxx and is way more flexible) but if that fails it goes on
to try SQLConnect - which in this case worked. You can avoid the wasted
call by using dbi:ODBC:DSN=XXX. DBD::ODBC has been like this for ages
for some still very good reasons.
It is not why Lars is getting no errors or data - he did get connected
and successfully issued the query and fetched no data.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
_______________________________________
Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality note
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
This message is confidential and may be privileged. If you are not the intended
recipient, we kindly ask you to please inform the sender. Any unauthorised
dissemination or copying hereof is prohibited. This message serves for
information purposes only and shall not have any legally binding effect. Given
that e-mails can easily be subject to manipulation, we can not accept any
liability for the content provided.
Subject: RE: Problem with Oracle ODBC connection
Date: Tue, 31 Mar 2009 16:45:25 +0200
From: [email protected]
To: [email protected]
There are no errors because no errors have occurred. You need to run
your SQL to the database directly and check what you get. Are
you in the
schema you expected?
oh, what I forgot: in the ODBC trace I do see the properties of the
columns, so I *should* be in the correct schema, no?
Lars
_________________________________________________________________
Internet Explorer 8 – Get your Hotmail Accelerated. Download free!
http://clk.atdmt.com/MRT/go/141323790/direct/01/
