Abby Sims - the web site | about me, my work, and things i love

Architecture Mismatch In Connection Between SQL 2008 and MySQL ODBC

Jun 16 2010

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

Jun 09 2010

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

Apr 07 2010

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