Message
From
26/09/2006 05:14:18
To
25/09/2006 17:53:52
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156495
Message ID:
01157182
Views:
23
>64-bit applications cannot see or use 32-bit OLEDB/ODBC drivers. Period.
>
>
>
>>Does the same limitation exist in using odbc/oledb for Excel or Access data on 64-bit operating systems?
>>
>>>Not all MS products are going 64 bit. Office 2007 will still be 32-bit.
>>>
Doug's problem was the use of 32 bit ODBC drivers on x64 servers, right? He found out that 32-bit ODBC drivers do not appear in the ODBC Data Source Administrator. He can use %SYSTEMROOT%\SysWOW64\odbcad32.exe instead of the default program in system32.
This will show all installed 32-bit ODBC drivers. At this point he can use his DSN as he would with any other system.
José
>
>
>
>>Does the same limitation exist in using odbc/oledb for Excel or Access data on 64-bit operating systems?
>>
>>>Not all MS products are going 64 bit. Office 2007 will still be 32-bit.
>>>
Doug's problem was the use of 32 bit ODBC drivers on x64 servers, right? He found out that 32-bit ODBC drivers do not appear in the ODBC Data Source Administrator. He can use %SYSTEMROOT%\SysWOW64\odbcad32.exe instead of the default program in system32.
This will show all installed 32-bit ODBC drivers. At this point he can use his DSN as he would with any other system.
José
José Constant
Constant Software Systems
Constant Software Systems