none
Is there a way to force Jet OleDB to create long file names? RRS feed

  • Question

  • OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +

    workdir + ";Extended Properties=DBASE IV;");

     

    OleDbCommand cmd = new OleDbCommand("CREATE TABLE exportimportx.dbf (ID varchar(8), ...

    connection.Open();

    cmd.ExecuteNonQuery();

     

    Instead of creating file name exportimportx.dbf it will create EXPORTIM.DBF. Why?

     

    My problem is that if I next try to call OleDbCommand("CREATE TABLE exportimportA.dbf

    it will try to create EXPORTIM.DBF again and I get an exception that exportimportA.dbf already exist.


    Is there a way to force Jet OleDB to create long file names?

    Thank You for your help.

    Michel Cunha

    Thursday, October 11, 2007 7:55 PM

Answers

  • This is a limitation of the dBase ISAM driver, which limits the length of filenames to eight characters. Working with anything longer than eight characters would require renaming the file. 

     

    Friday, October 12, 2007 11:52 AM