Error Importing data


  • Hi All


    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)

    Additional Information:

    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.

    Can someone help me on this issue




    Thursday, May 01, 2008 12:21 PM


  • 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.


    Thursday, May 01, 2008 1:23 PM