Meeting the needs of your business from a distance

ODBC Data Sources on 64-bit machines

by Mark Shiffer 10/2/2007 4:16:00 PM

I recently ran into some issues when attempting to run ODBC on a 64-bit machine. The particular ODBC driver I was using installed as a 32-bit driver, and thus had to be accessed through SysWow64\odbcad32.exe. After setting up the data source and running my application, I recieved the error "Data source name not found and no default driver specified" even though it was clearly setup. After doing some digging I found that the application was compiled with the 'Any CPU' option. I am not entirely clear here, but it appears that when the application runs on a 64-bit machine it will run as a 64-bit application and only look at the 64-bit data sources on the machine. If I compile the application with a platform target of x86, and run it on the 64-bit machine it runs and looks at the 32-bit data sources. Problem solved.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

Issues

Related posts

Comments

January 18. 2008 18:22

kiran Lokhande

above suggestion resolve my problem
Thanks

kiran Lokhande us

Add comment


(Will show your Gravatar icon)  

  Country flag





Live preview

May 16. 2008 20:23

About the author

Name of author Mark Shiffer
CEO & CIO of MS Consulting

E-mail me Send mail

Calendar

<<  May 2008  >>
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar

Pages

    Recent posts

    Recent comments

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2008

    Sign in

    Copyright © 2001-2008 MS Consulting, Inc. All Rights Reserved.