Wednesday, June 20, 2012

ODBC/DSN Adventures


I was having issues with the ODBC connections of a legacy classic asp project i was working on.


I received the error "the specified dsn contains an architecture mismatch between the driver and application".


Unfortunately the previous "developers" (i use this term loosely)  decided to use DSN connections instead of a real connection string like:
(oConn.Open = "Provider=SQLOLEDB; Data Source=SERVER; Initial Catalog=CAT; User Id=sa; Password=*************").


Because I am running a Win7 x64 machine i needed to use the x32 odbc driver and not the x64 one.  If you type ODBC into the start menu you get the x64 version whereas if you type c:\windows\sysWOW64\odbcad32.exe it will open the x32 version.  This also help when connecting a mysql server through ODBC to excel.
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Phoenix

I am resurrecting this tech blog for notes related to Azure Logic Apps with SAP.

  • SQLITE NHibernate DateTime2
    While working on a project I was using a MsSQL 2012 database for my persistence layer but wanted to use a SQLITE in memory database for my u...
  • Redmine Setup using Turnkey Linux
    Redmine Install Process -- Download and install turnkey linux's redmine appliance http://www.turnkeylinux.org/redmine -- install up...
  • Visio Alternative
    If you are a developer you probably have Visio but if you don’t https://www.draw.io/  is a great  alternative and its free.