Solved

DSN Contains architecture mismatch

Posted on 2010-11-29
7
2,229 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
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.
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.

910 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

18 Experts available now in Live!

Get 1:1 Help Now