Any gotchas there? I am opening an Access db via ODBC and binding those
columns (including a date field) and passing that to the Oracle handle
to do inserts (i.e. Access -> Oracle migration).
Re: Whats so bad about ODBC ... It is far better to connect to Oracle using the native connectivity. ... What exactly might be a problem with ODBC?... data to be fetched to the client, and have it filtered on the client. ... actual execution paths are often unpredictable, ... (comp.databases.oracle.server)
RE: Windows to Oracle ... resolved yet (with respect to a Windows OS). ... and Oracle DBDs.... Need to install Oracle on your own machine before you can connect to the ... If you are truly trying to use ODBC, why are you specifying the Oracle ... (perl.dbi.users)
Re: MS OLE DB for ODBC with Oracle ODBC source headaches ...John Bell wrote: ... the Oracle OLEDB provider (as opposed to the Microsoft OLE for ODBC... >> I have no idea why sometimes I can connect to the linked server with no ... (comp.databases.ms-sqlserver)
Re: Probleme unter Access beim Zugriff auf Oracle-Daten ... Der Zugriff erfolgt via ODBC mit dem Microsoft Treiber. ... Hier wird allerdings nicht wirklich etwas Bewegendes gemacht: mit Access-backend verkünpfte Tabellen, mit via ODBC eingebundene Oracle Tabellen und eine PT-Abfrage. ...Schema: Es gibt zwei Schemata, welche vom Aufbau absolut identisch sind. ... (microsoft.public.de.access.clientserver)
Re: MSACCESS hangs ... Client -- Windows XP, MS Access 2003 using Oracle's ODBC driver ... I would try to isolate whether it is the query or ODBC....Senior Oracle Dba... other thoughts are windows patches may have been installed, ... (comp.databases.oracle.server)