Post reply

connecting to Oracle on a 64 bit server 2008 windows

  • April 28, 2010 at 4:40 am

    #386805

    all

    been trying to get this to work for over a month now 🙁

    seems the Oracle DBAs can't handle windows 2008 and i know nothing about all this Oracle malarky, which doesn't help

    here's what i know:-

    the version of sql server:-

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (VM)

    the windows version:-

    Microsoft Windows Server 2008 R2

    Version 6.1 (Build 7600)

    the visual studio version:-

    9.0.30729.1

    version 3.5 SP1

    the Oracle client:-

    11g

    i appreciate there are two versions of the odbcad32

    C:\Windows\SysWOW64\odbcad32.exe (the 32 bit one!)

    C:\Windows\System32\odbcad32.exe (the 64 bit one!)

    and i can get DSNs working in both versions of the Odbcad32...

    so, nearly there you'd think, onto SSIS

    now firstly, it would be nice to not use ODBC, but use the Oracle driver... but any driver i try and call, the DLL isn't installed and the Oracle DBAs are saying they are. maybe I (or the DBAs) need to register them

    secondly, i'll try and use ODBC...

    well i notice it only recognises the DSNs from the 32 bit odbcad32 (fine, no bother)

    and if i try to use my Oracle DSNs, it errors giving

    DLL initialization routine failed (Oracle in OraClient11g_home2, e:\app\10Client32\product\11.2.0\client_2\BIN\SQORA32.DLL)

    (well they've had a few different versions of the client installed, so various error paths for each!)

    i'm completely stumped, the Oracle DBAs figured it out at my last job ok, but that was 2005

    any ideas welcome, thanks in advance

  • April 28, 2010 at 6:29 am

    #1158825

    there is a seperate download for 64 bit Oracle drivers from Oracle; so it might be true the oracle 32 bit client tools are installed on the server, and they can connect to the oracle instance via SQLPlus, so they say "it's installed and working".

    the seperate download for 64 bit drivers will allow you to make a linked server to your oracle instance.

    http://www.oracle.com/technology/software/tech/windows/odbc/index.html

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 28, 2010 at 7:42 am

    #1158915

    hi, thanks for the quick reply

    surely they have the 64 bit drivers installed if i can see it in the 64 bit odbcad32 and create a working DSN there?

  • April 28, 2010 at 7:48 am

    #1158923

    the 64 bit drivers are not named odbcad32; I'm very sure they have a different name,and contain "64" in their name.

    that's the issue i think; trying to use 32 bit drivers, when it needs to be 64 bit drivers.

    darth vodka (4/28/2010)

    hi, thanks for the quick reply

    surely they have the 64 bit drivers installed if i can see it in the 64 bit odbcad32 and create a working DSN there?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 28, 2010 at 7:58 am

    #1158933

    Lowell (4/28/2010)

    the 64 bit drivers are not named odbcad32; I'm very sure they have a different name,and contain "64" in their name.

    that's the issue i think; trying to use 32 bit drivers, when it needs to be 64 bit drivers.

    i didn't say the drivers were called odbcad32??

    that's the odbc data source administrator!

  • April 28, 2010 at 8:29 am

    #1158972

    got it, was a case of registering the DLLs

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply