"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" <sylvainlafontaine2***@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" <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" <sylvainlafontaine2***@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" <sylvainlafontaine2***@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" <sylvainlafontaine2***@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
>>>>
>>>>
>>>
>>>
>>
>>
>
>