Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DSN Contains architecture mismatch

Posted on 2010-11-29
7
Medium Priority
?
2,266 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

971 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