none
Can't Connnect to a MDB database RRS feed

  • Question

  • Hi!

    I'm writing a application that uses Access 2.0 database as a datasource. My connection string is :

    Code Block

    provider=Microsoft.Jet.OLEDB.4.0;DataSource="some_path"



    When i test my app it throws and exception saung "cannot find installable ISAM file". As I analised this problem was even more serious. I also try to port my database to SQL SERVER 2005 using Microsoft SQL Server Migration Assistant for Access. And it turned out that this tool doesn't "see" tables inside ANY access database. It seams thaere is a prlbem with JET Engine on my development machine,but I can't tell what's wrong.
    Friday, November 2, 2007 10:53 AM

Answers

  • There should be a space between Data and Source.

     

    Code Block

    provider=Microsoft.Jet.OLEDB.4.0;Data Source="some_path"

     

     

    Monday, November 5, 2007 2:10 PM