32 bit drivers on 64 bit machines

[Tony Brown]

Hi,
I'm trying to get a classic ASP website working on a 64 bit web server
talking to a 64 bit version of SQL Server. The ASP needs to load some
components that are only available as 32 bit so the website is set to run in
32 bit mode. However I'm getting a "architecture mismatch between the Driver
and Application " error. Which I guess is due to the 32 bit WOW not being
able to load the 64 bit drivers.

Is it possible to install 32 bit ODBC drivers on a 64 bit machine? If so
where could I get them from?

Thanks in advance
Tony

[Tony Brown]

For the second time today I find an answer to a question as soon as I ask
someone for help!

If anyone hits a similar problem you need to configure the 32 bit DSN using
C:\Windows\SysWOW64\odbcad32.exe

Tony

"Tony Brown" <tony...@example.com> wrote in message
news:ONNAMsne...@TK2MSFTNGP06.phx.gbl...

[Christian Stüben]

Yep, you can install 32bit odbc drivers on 64 bit windows.
although late, here is the answer...
http://fmp.haifischbar.com:88/faq.aspx?ui=bb3b4877-5e5b-40ff-b4b9-e6392eafc9b6

But, on 64 bit windows, only 32bit processes can utilize the 32 bit drivers.
64bit processes have bad luck (german only)...
http://fmp.haifischbar.com:88/faq.aspx?ui=68935dcb-1a0f-4863-a0e2-b5cb809788ee

For .net application there are some ways to force them to run as 32bit (as
described in the second faq)

greetings from gemany
Chris

"Tony Brown" <tony...@example.com> schrieb im Newsbeitrag
news:ONNAMsne...@TK2MSFTNGP06.phx.gbl...