locked
Could not find installable ISAM RRS feed

  • Question

  • I am having this error when I try to import my access file.

    Is there any way to solve this?!


    • Edited by limtingzhi Wednesday, November 16, 2011 2:43 PM
    Wednesday, November 16, 2011 2:29 PM

Answers

  • Hi limtingzhi,

    It's not the connection string. Here's some case that familiar with yours, and their issue has been solved, much of the issues are deal to the connection string, you can refer to it and find if the solution can solve your issue. If you have any problem, please feel free to let me know.

    Cases familiar with yours:

    http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/62ee4978-ca29-48d3-9367-6dd4ab639d2d/

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/282a05c2-2c1c-431f-8276-75055befeb76

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/0c8191b5-200d-4f54-ba30-fc3e93432b7a

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c14ed721-d6cd-4cdb-bc54-c6130c69fed6/

    http://social.msdn.microsoft.com/Forums/en-US/winforms/thread/8a374306-5a5a-4a93-ad05-ac1bcc2b6e1e

    Best Regards


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us
    • Marked as answer by Allen_MSDN Thursday, November 24, 2011 7:23 AM
    Monday, November 21, 2011 3:52 AM

All replies

  • Unfortunately I cannot tell what the application is. Is it 64-bit?
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, November 16, 2011 8:03 PM
  • Microsoft Excel 2010 - PowerPivot

    I think is 32-bit. 

    Thursday, November 17, 2011 6:09 AM
  • Do you know what the connection string to the Access database is? I can't tell from the image.

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, November 17, 2011 2:25 PM
  • Hi limtingzhi,

    In order to help you more effectively, could you please provide your connection string?

    Best Regards


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us
    Friday, November 18, 2011 2:31 AM
  • Is this the connection string? I am not so sure.
    ============================
    Error Message:
    ============================
    Could not find installable ISAM.
    ----------------------------
    Failed to connect to the server. Reason: Could not find installable ISAM.
    ============================
    Call Stack:
    ============================
       at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.OleDb.OleDbConnection.Open()
       at Microsoft.AnalysisServices.Modeler.Storage.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
    ----------------------------
       at Microsoft.AnalysisServices.Modeler.Storage.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
       at Microsoft.AnalysisServices.Modeler.Storage.RelationalDataSourceConnection.Open(String& connectionIdentifier)
       at Microsoft.AnalysisServices.Modeler.Storage.RelationalDataSourceConnection.Open()
       at Microsoft.AnalysisServices.Modeler.DataImportWizard.DataSourceBasic.TestConnection()
       at Microsoft.AnalysisServices.Modeler.DataImportWizard.DataSourceBasic.ClickTestConnection(Object progressControl)
    ============================
    Sunday, November 20, 2011 9:53 AM
  • Hi limtingzhi,

    It's not the connection string. Here's some case that familiar with yours, and their issue has been solved, much of the issues are deal to the connection string, you can refer to it and find if the solution can solve your issue. If you have any problem, please feel free to let me know.

    Cases familiar with yours:

    http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/62ee4978-ca29-48d3-9367-6dd4ab639d2d/

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/282a05c2-2c1c-431f-8276-75055befeb76

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/0c8191b5-200d-4f54-ba30-fc3e93432b7a

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c14ed721-d6cd-4cdb-bc54-c6130c69fed6/

    http://social.msdn.microsoft.com/Forums/en-US/winforms/thread/8a374306-5a5a-4a93-ad05-ac1bcc2b6e1e

    Best Regards


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us
    • Marked as answer by Allen_MSDN Thursday, November 24, 2011 7:23 AM
    Monday, November 21, 2011 3:52 AM
  • Hi limtingzhi,

    I marked my replay as answer, if you feel it not proper, please unmark it. If you have any problem, feel free to let me know.

    Best Regards


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us
    Thursday, November 24, 2011 1:49 AM
  • My English do not is very well, I had the same problem.
    the problem that I identificated is that the table has one relation with other and this table had values duplicate. I eliminated and updated corretly,

    El error que se me presento a mi era que tenia la tabla realcionada con otra y en el momento de actualizar la llave tenia un valor duplicado por lo que me generaba error en el momento de actualizarla.

    lo que hice fue eliminar o corregir la linea errada y funciono perfectamente.

    Wednesday, January 11, 2017 4:49 PM