Solved

DSN Contains architecture mismatch

Posted on 2010-11-29
7
2,226 Views
Last Modified: 2012-05-10
My ASP page is reporting an error when trying to connect to a database

     [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application


1)  I have Win7, 64 Bit Ultimate.
2)  I have the 32 bit DSN / driver configured using
c:\windows\syswow64\odbcad32.exe
3)  IIS is running on my laptop
4)  I'm connecting to localhost to a shared folder on my laptop, (it's not under InetPub)
5)  The DSN is connecting to a Oracle db on the network using the Microsoft Oracle driver.
I've rebooted etc.  

Hope you can help.



0
Comment
Question by:dillybar
  • 5
  • 2
7 Comments
 
LVL 9

Expert Comment

by:losip
ID: 34234604
0
 

Author Comment

by:dillybar
ID: 34234621
yes I did.  it doesn't apply  

I mentioned above, that I have the 32 bit DSN / driver configured using c:\windows\syswow64\odbcad32.exe
0
 

Author Comment

by:dillybar
ID: 34234636
that is unless I read the article wrong... it doesn't seem to apply.  
I'm connecting to a Oracle 9   (32 bit) database using the 32 bit driver as mentioned in the article.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 9

Expert Comment

by:losip
ID: 34234673
Are you sure you're not using the 64 bit odbcad32.exe instead of the 32 bit version of the same program?
0
 

Author Comment

by:dillybar
ID: 34239631
2)  I have the 32 bit DSN / driver configured using  c:\windows\syswow64\odbcad32.exe

the article explains this is the 32 bit
I don't have any dsn's configured in the 64 bit odbc
0
 

Accepted Solution

by:
dillybar earned 0 total points
ID: 34357481
Thanks for trying losip.

For anyone that is struggling with this, here's the apparent answer to get you through this.
Yes you have to set up the odbc driver in the 32 bit as mentioned above,
but you'll need to set the application pool to 32 bit.
http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/1c63e3ae-e001-4066-9eac-ad9162116603
0
 

Author Closing Comment

by:dillybar
ID: 34387672
i found the answer (not on experts exchange)
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
So many times I have seen the words written in a question "if only I could show you" or " I know how hard it is for you since you can't see it" in any zone. That has inspired me to write about this tool in windows 7 called "Problem Steps Recorder…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now