Im running SQL Express 2005 on my 64bit windows 2003 R2 server, and im having a problem converting some data over to the database. The error i get is:
There was a problem connecting to the library.mdb database (NormalSystem)
Error [IM002] [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.
I have done a couple of searches on the net, but not found anything to do with SQL express 2005, and it mentions something about run64bitruntime.exe. I cannot seem to find this option anywhere in SQL server management studio Express.
SQL Server Express does not have the SSIS Import/Export Functionality in it. This is one of the items that was left off of the Express Edition and is only available in the Developer/Standard/Enterprise Editions.