That's 11.5 documentation and in 11.5 you can do it. Not in 10.2B.
You can't install 32 and 64-bit OE of same version (on Windows) prior 11.5.
this program was working fine until about a week ago. Now, it gives this error:
System.Data.Odbc.OdbcException: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
The explanation: You are accessing a 32 bit odbc driver on a 64 bit system.
**** Both 64-bit and 32-bit versions were installed on the machine until yesterday, when it was noticed. Both were removed, and now I am attempting to put them back.
I am not sure what the question is here, but:
First of all, to say that you can't install 32 and 64-bit OE of same version (on Windows) prior 11.5 is not true, as both WERE installed on this system until yesterday.They were uninstalled to try and address a new problem that had arisen since last weekend. Our software was not changed, and had been working fine until last weekend. The only possible change was through Windows Update.
> First of all, to say that you can't install 32 and 64-bit OE of same version (on Windows) prior 11.5 is not true, as both
> WERE installed on this system until yesterday
Oh, my apologies. I should have said 'using the installation routine'. Of course you can copy the files over and create the required registry and files and config yourself. If that's what you want to do again, then I'd suggest you to find someone who did that hack at the first place.
You said you downloaded SQL Client access to install it - why to download it again? It was (as you claim) already installed, so the installation files should be present somewhere? Was it really SQL client access you had there or was it perhaps Data Direct Connect Suite? (the name might not be exactly correct).
For more information on how to bypass the limtis of the installer utility and get the drivers installed.
Or you can just get 11.x SQL client access instead.....
OK. Apparently releases below 11.5 do need to be at different release levels when installing on the same server so I may be able to install 32bit 10.1B Client Access. I'll let you know.
That worked. I had to install 32bit 10.1B Client Access. Then, using C:\Windows\SysWOW64\odbcad32.exe I had to create 32 bit DSN names.