[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2276
  • Last Modified:

DSN Contains architecture mismatch

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
dillybar
Asked:
dillybar
  • 5
  • 2
1 Solution
 
losipCommented:
0
 
dillybarAuthor Commented:
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
 
dillybarAuthor Commented:
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
losipCommented:
Are you sure you're not using the 64 bit odbcad32.exe instead of the 32 bit version of the same program?
0
 
dillybarAuthor Commented:
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
 
dillybarAuthor Commented:
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
 
dillybarAuthor Commented:
i found the answer (not on experts exchange)
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now