Author - Abby Sims

1
Architecture Mismatch In Connection Between SQL 2008 and MySQL ODBC
2
Mid-Year Recap
3
Support Bryant Soccer Club at Reynolds Road Chick-fil-A

Architecture Mismatch In Connection Between SQL 2008 and MySQL ODBC

Spent too much time this morning troubleshooting this error when attempting to setup a linked server in SQL 2008 Express to a MySQL database.

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LINKEDSERVERNAME".
OLE DB provider "MSDASQL" for linked server "LINKEDSERVERNAME" returned message "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". (.Net SqlClient Data Provider)

The simple solution to my problem was to uninstall my 32-bit driver and instead install the 64-bit Connector/ODBC driver. For those of you looking for additional help on how to configure a linked server connection to MySQL, see HOWTO: Setup SQL Server Linked Server to MySQL and How to create a Link Server for mySQL in SQL Server Management Studio (SSMS) in SQL Server 2005.

Mid-Year Recap

Biggest achievements of the year so far:

  • 4 new ASP.net MVC apps
  • 2 enhanced PHP apps
  • 1 website launched
  • 1 new job as rock star [web developer]
  • 1 trip to Jersey to visit new niece
  • 1 mommy-son trip to Branson

Goals for the rest of the year*:

  • Continue to rock the projects at work
  • Develop an Android app and put on market
  • Find something with OS X and port Android app to Objective-C
  • Complete at least one more side web development projects
  • Hot air balloon ride this fall sounds nice (sans kids)
  • Weekend trips with the kids
  • Vacation with the hubby
  • Chill

*subject to change

Support Bryant Soccer Club at Reynolds Road Chick-fil-A

From April 6 – 20, 2010, bring in this flyer to donate 15% of your purchase at the Reynolds Road Chick-fil-A to the Bryant Soccer Club!

Bryant Soccer Club Chick-fil-a Fundraiser Flyer

Copyright © 2016, Abby Sims