Problems connecting when compiled to x86

[Administrator]

For those familiar with 64-bit (x64), as I'm learning now running Windows Vista x64, OleDb JET doesn't work under x64. To make OleDb (JET) work you have to go to the project settings area, compilation tab, advanced settings and target specifically the x86 processor. Once you do so, you can then access MDB's via Jet OleDb. However, I noticed when I compile to x86, I can no longer connect to SQL 2005. I have a smart client that uses MDB's locally but connects to SQL 2005 as well.

Anyone know why I cannot connect to SQL 2005 when compiling to x86, but when set to the default "Any CPU" (x64 in my case) it DOES work?

It's been one heck of a learning experience using x64 for the first time, and a good thing to learn. Now if someone can tell me how to connect to both JET OleDb and SQL 2005 in this scenario, I'd appreciate it!

 

[cjard]

If the project were decomposed into two DLLs, one compiled for x86 and targeting jet, and one compiled to x64 targeting SQLS, do you achieve any usable results?