1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

ODBC Drivers 64-Bit

Discussion in 'Windows Home Server' started by NMahmoud, Apr 23, 2009.

  1. NMahmoud

    NMahmoud Guest

    I have 64 bit sqlserver 2008 installed on a 64bit Window Server,

    and my problem is "there is no drivers listed in the 'ODBC/create New Data
    Source' box other than the sql server",



    1. I tried to install "64-Bit OLEDB Provider for ODBC (MSDASQL)" but the
    installation give me the error "Not enough storage is available to process
    this command"

    2. I tried to install MDAC 2.8, but it did not run at all, it just flashed
    and died

    3. Installed "CompChecker", and I perform analysis to determine the release
    version, I get unknown version

    4. the register

    "HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer" =
    6.0.6001.18000

    "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI" has only the sqlserver's



    any advise



    thanks

    Nabila
     
    NMahmoud, Apr 23, 2009
    #1
  3. Sylvain Lafontaine

    Sylvain Lafontaine Guest

    First, many ODBC providers such as those for Access or Excel are 32 bit
    driver and cannot be accessed from a program running under the 64 mode of
    Window Server 64 bit and installing the 64 Bit OLEDB Provider for ODBC
    (MSDASQL) will change nothing to that.

    Second, your installation problems look strange. What kind of 64 bit Window
    Server do you have? Is this Itanium or the more regular Intel X64 flavor?

    --
    Sylvain Lafontaine, ing.
    MVP - Windows Live Platform
    Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
    Independent consultant and remote programming for Access and SQL-Server
    (French)


    "NMahmoud" <Nabila_No_spam@ChildrensOncologyGroup.org> wrote in message
    news:%232xJk%23ExJHA.4176@TK2MSFTNGP03.phx.gbl...
    >I have 64 bit sqlserver 2008 installed on a 64bit Window Server,
    >
    > and my problem is "there is no drivers listed in the 'ODBC/create New Data
    > Source' box other than the sql server",
    >
    >
    >
    > 1. I tried to install "64-Bit OLEDB Provider for ODBC (MSDASQL)" but the
    > installation give me the error "Not enough storage is available to process
    > this command"
    >
    > 2. I tried to install MDAC 2.8, but it did not run at all, it just
    > flashed and died
    >
    > 3. Installed "CompChecker", and I perform analysis to determine the
    > release version, I get unknown version
    >
    > 4. the register
    >
    > "HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer" =
    > 6.0.6001.18000
    >
    > "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI" has only the sqlserver's
    >
    >
    >
    > any advise
    >
    >
    >
    > thanks
    >
    > Nabila
    >
    >
     
    Sylvain Lafontaine, Apr 23, 2009
    #2
  4. NMahmoud

    NMahmoud Guest

    thank you for your response Sylvain, you are right, we installed the 64 bit
    Oracle client utilities and we were able to see Oracle odbc driver listed.
    We have X64,

    and I thought that 32/64 translation layer will make the 32
    applications/drivers appear to the system as 64, apperantly not.
    but I was able to see the 32 ODBC dirvers when I run the 32bit
    "odbcad32.exe" which I found in

    C:\Windows\winsxs\x86_microsoft-windows-m..-odbc-administrator_31bf3856ad364e35_6.0.6001.18000_none_444fe75e3db70c2d

    Thanks again
    Nabila

    "Sylvain Lafontaine" <sylvainlafontaine2009@yahoo.ca> wrote in message
    news:e3TKRaGxJHA.1088@TK2MSFTNGP04.phx.gbl...
    > First, many ODBC providers such as those for Access or Excel are 32 bit
    > driver and cannot be accessed from a program running under the 64 mode of
    > Window Server 64 bit and installing the 64 Bit OLEDB Provider for ODBC
    > (MSDASQL) will change nothing to that.
    >
    > Second, your installation problems look strange. What kind of 64 bit
    > Window Server do you have? Is this Itanium or the more regular Intel X64
    > flavor?
    >
    > --
    > Sylvain Lafontaine, ing.
    > MVP - Windows Live Platform
    > Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
    > Independent consultant and remote programming for Access and SQL-Server
    > (French)
    >
    >
    > "NMahmoud" <Nabila_No_spam@ChildrensOncologyGroup.org> wrote in message
    > news:%232xJk%23ExJHA.4176@TK2MSFTNGP03.phx.gbl...
    >>I have 64 bit sqlserver 2008 installed on a 64bit Window Server,
    >>
    >> and my problem is "there is no drivers listed in the 'ODBC/create New
    >> Data Source' box other than the sql server",
    >>
    >>
    >>
    >> 1. I tried to install "64-Bit OLEDB Provider for ODBC (MSDASQL)" but the
    >> installation give me the error "Not enough storage is available to
    >> process this command"
    >>
    >> 2. I tried to install MDAC 2.8, but it did not run at all, it just
    >> flashed and died
    >>
    >> 3. Installed "CompChecker", and I perform analysis to determine the
    >> release version, I get unknown version
    >>
    >> 4. the register
    >>
    >> "HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer" =
    >> 6.0.6001.18000
    >>
    >> "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI" has only the sqlserver's
    >>
    >>
    >>
    >> any advise
    >>
    >>
    >>
    >> thanks
    >>
    >> Nabila
    >>
    >>
    >
    >
     
    NMahmoud, Apr 26, 2009
    #3
  5. Sylvain Lafontaine

    Sylvain Lafontaine Guest

    Exactly: there is no translation layer available at this moment; so if you
    don't have a 64 driver available, you cannot use a 32 bit driver instead
    from the 64 world. The 32 bit drivers that you can see with the 32 bit
    version of odbcad32.exe are only for the programs running under the 32 bit
    emulated mode (WOW64) and cannot be accessed from any program running under
    the native 64 bit mode.

    --
    Sylvain Lafontaine, ing.
    MVP - Windows Live Platform
    Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
    Independent consultant and remote programming for Access and SQL-Server
    (French)


    "NMahmoud" <Nabila_No_spam@ChildrensOncologyGroup.org> wrote in message
    news:e7jD5BvxJHA.3476@TK2MSFTNGP05.phx.gbl...
    > thank you for your response Sylvain, you are right, we installed the 64
    > bit Oracle client utilities and we were able to see Oracle odbc driver
    > listed. We have X64,
    >
    > and I thought that 32/64 translation layer will make the 32
    > applications/drivers appear to the system as 64, apperantly not.
    > but I was able to see the 32 ODBC dirvers when I run the 32bit
    > "odbcad32.exe" which I found in
    >
    > C:\Windows\winsxs\x86_microsoft-windows-m..-odbc-administrator_31bf3856ad364e35_6.0.6001.18000_none_444fe75e3db70c2d
    >
    > Thanks again
    > Nabila
    >
    > "Sylvain Lafontaine" <sylvainlafontaine2009@yahoo.ca> wrote in message
    > news:e3TKRaGxJHA.1088@TK2MSFTNGP04.phx.gbl...
    >> First, many ODBC providers such as those for Access or Excel are 32 bit
    >> driver and cannot be accessed from a program running under the 64 mode of
    >> Window Server 64 bit and installing the 64 Bit OLEDB Provider for ODBC
    >> (MSDASQL) will change nothing to that.
    >>
    >> Second, your installation problems look strange. What kind of 64 bit
    >> Window Server do you have? Is this Itanium or the more regular Intel X64
    >> flavor?
    >>
    >> --
    >> Sylvain Lafontaine, ing.
    >> MVP - Windows Live Platform
    >> Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
    >> please)
    >> Independent consultant and remote programming for Access and SQL-Server
    >> (French)
    >>
    >>
    >> "NMahmoud" <Nabila_No_spam@ChildrensOncologyGroup.org> wrote in message
    >> news:%232xJk%23ExJHA.4176@TK2MSFTNGP03.phx.gbl...
    >>>I have 64 bit sqlserver 2008 installed on a 64bit Window Server,
    >>>
    >>> and my problem is "there is no drivers listed in the 'ODBC/create New
    >>> Data Source' box other than the sql server",
    >>>
    >>>
    >>>
    >>> 1. I tried to install "64-Bit OLEDB Provider for ODBC (MSDASQL)" but the
    >>> installation give me the error "Not enough storage is available to
    >>> process this command"
    >>>
    >>> 2. I tried to install MDAC 2.8, but it did not run at all, it just
    >>> flashed and died
    >>>
    >>> 3. Installed "CompChecker", and I perform analysis to determine the
    >>> release version, I get unknown version
    >>>
    >>> 4. the register
    >>>
    >>> "HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer" =
    >>> 6.0.6001.18000
    >>>
    >>> "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI" has only the sqlserver's
    >>>
    >>>
    >>>
    >>> any advise
    >>>
    >>>
    >>>
    >>> thanks
    >>>
    >>> Nabila
    >>>
    >>>
    >>
    >>
    >
    >
     
    Sylvain Lafontaine, Apr 26, 2009
    #4
  6. NMahmoud

    NMahmoud Guest

    Thank you for your help Sylvain,


    "Sylvain Lafontaine" <sylvainlafontaine2009@yahoo.ca> wrote in message
    news:uR$SkQvxJHA.1196@TK2MSFTNGP03.phx.gbl...
    > Exactly: there is no translation layer available at this moment; so if you
    > don't have a 64 driver available, you cannot use a 32 bit driver instead
    > from the 64 world. The 32 bit drivers that you can see with the 32 bit
    > version of odbcad32.exe are only for the programs running under the 32 bit
    > emulated mode (WOW64) and cannot be accessed from any program running
    > under the native 64 bit mode.
    >
    > --
    > Sylvain Lafontaine, ing.
    > MVP - Windows Live Platform
    > Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
    > Independent consultant and remote programming for Access and SQL-Server
    > (French)
    >
    >
    > "NMahmoud" <Nabila_No_spam@ChildrensOncologyGroup.org> wrote in message
    > news:e7jD5BvxJHA.3476@TK2MSFTNGP05.phx.gbl...
    >> thank you for your response Sylvain, you are right, we installed the 64
    >> bit Oracle client utilities and we were able to see Oracle odbc driver
    >> listed. We have X64,
    >>
    >> and I thought that 32/64 translation layer will make the 32
    >> applications/drivers appear to the system as 64, apperantly not.
    >> but I was able to see the 32 ODBC dirvers when I run the 32bit
    >> "odbcad32.exe" which I found in
    >>
    >> C:\Windows\winsxs\x86_microsoft-windows-m..-odbc-administrator_31bf3856ad364e35_6.0.6001.18000_none_444fe75e3db70c2d
    >>
    >> Thanks again
    >> Nabila
    >>
    >> "Sylvain Lafontaine" <sylvainlafontaine2009@yahoo.ca> wrote in message
    >> news:e3TKRaGxJHA.1088@TK2MSFTNGP04.phx.gbl...
    >>> First, many ODBC providers such as those for Access or Excel are 32 bit
    >>> driver and cannot be accessed from a program running under the 64 mode
    >>> of Window Server 64 bit and installing the 64 Bit OLEDB Provider for
    >>> ODBC (MSDASQL) will change nothing to that.
    >>>
    >>> Second, your installation problems look strange. What kind of 64 bit
    >>> Window Server do you have? Is this Itanium or the more regular Intel
    >>> X64 flavor?
    >>>
    >>> --
    >>> Sylvain Lafontaine, ing.
    >>> MVP - Windows Live Platform
    >>> Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
    >>> please)
    >>> Independent consultant and remote programming for Access and SQL-Server
    >>> (French)
    >>>
    >>>
    >>> "NMahmoud" <Nabila_No_spam@ChildrensOncologyGroup.org> wrote in message
    >>> news:%232xJk%23ExJHA.4176@TK2MSFTNGP03.phx.gbl...
    >>>>I have 64 bit sqlserver 2008 installed on a 64bit Window Server,
    >>>>
    >>>> and my problem is "there is no drivers listed in the 'ODBC/create New
    >>>> Data Source' box other than the sql server",
    >>>>
    >>>>
    >>>>
    >>>> 1. I tried to install "64-Bit OLEDB Provider for ODBC (MSDASQL)" but
    >>>> the installation give me the error "Not enough storage is available to
    >>>> process this command"
    >>>>
    >>>> 2. I tried to install MDAC 2.8, but it did not run at all, it just
    >>>> flashed and died
    >>>>
    >>>> 3. Installed "CompChecker", and I perform analysis to determine the
    >>>> release version, I get unknown version
    >>>>
    >>>> 4. the register
    >>>>
    >>>> "HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer" =
    >>>> 6.0.6001.18000
    >>>>
    >>>> "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI" has only the
    >>>> sqlserver's
    >>>>
    >>>>
    >>>>
    >>>> any advise
    >>>>
    >>>>
    >>>>
    >>>> thanks
    >>>>
    >>>> Nabila
    >>>>
    >>>>
    >>>
    >>>
    >>
    >>
    >
    >
     
    NMahmoud, Apr 30, 2009
    #5

Share This Page