Re: 64 Bits ODBC Drivers for SYBASE and ORACLE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Jun 12, 1:48 pm, AAF <A...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,

Does anyone know where I can download 64 bits ODBC drivers for SYBASE and
ORACLE 10G ?

How to make them available for the IMPORT/EXPORT Data Wizard in SQL SERVER
2005 ?

Thanks for any help.

André

Andre,
if you mean on windows I believe both products come with ODBC
drivers.......on linux/unix they do not necessarily have ODBC drivers.
I use easysoft drivers for Oracle on linux/unix....

Also, if you want to make them available for import export on sql
server what are you trying to do? It is not the case that you will be
able to easily move data between these databases just by doing ODBC
calls.....the data types are not always directly compatible....eg a
timestamp in sql server has 3 decimal places, and it does not in
Oracle, so if you try to unload a timestamp from sql server and load
it into oracle you get an error.....there are plenty of other such
cases....

Best Regards

Peter
www.peternolan.com

.

Relevant Pages

  • Re: Import problems on Windows Server
    ... your OWN research the Mickeysoft ODBC drivers do NOT support ANY ... Oracle feature beyond 7.3? ... There are plenty of non MS ODBC drivers that will connect with the various editions of non-MS databases, some of the drivers are actually better. ... Free speech - I'm here to stay dude - get used to it; when you see a post relating to SQL Server or Windows I'll be there with an answer to any myth you might want to TRY and spread. ...
    (comp.databases.oracle.server)
  • RE: Windows Services and SQL Server
    ... There are managed providers for Oracle, MySQL and other RDBMS's. ... SqlClient class with a regular SQL Server login? ... I'm using ODBC Drivers ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DTS writing to Non SQL Server Target
    ... > I want to use DTS to source data from various targets to build a staging area in SQL Server. ... Some of the data needs to be transferred/shared with a different Oracle database, ... If you have ODBC drivers to it then the chances are DTS will talk to it. ... Allan Mitchell (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)