Databases
StackOverflow2013
Postsdbo
POInvalid setting in Excel key of the Engines section of the Windows Registry
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInvalid setting in Excel key of the Engines section of the Windows Registry
    primarykey
    data
    text
    <p>I have a C# program that imports data from a csv file and puts the data into a SQLServerCE database table (on the local C-drive). The program works on many users' machines, but a few users keep getting the error:</p> <pre><code>System.Data.OleDb.OleDbException (0x80004005): Invalid setting in Excel key of the Engines section of the Windows Registry. 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() </code></pre> <p><strong>Here is the C# code:</strong></p> <pre><code>string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathToFile + ";Extended Properties=Text;"; string sqlCmd = "SELECT * FROM [" + filenameOnly + "]"; using (OleDbConnection conn = new OleDbConnection(connStr)) { OleDbCommand cmd = new OleDbCommand(sqlCmd, conn); using (OleDbDataAdapter dadapt = new OleDbDataAdapter(cmd)) { conn.Open(); dadapt.TableMappings.Add("Table", dataSourceAlias); dadapt.Fill(ds); conn.Close(); } } </code></pre> <p><strong>I've tried several things already:</strong></p> <ol> <li>verified HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4\Engines\Text has "CSVDelimited" for the Format Key</li> <li>verified the users have the most recent release of Jet4.0 (Msjet40.dll version 4.0.9511.0 Win dows XP SP3 and Security Bulletin MS08-028 )</li> <li>verified HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text does not have an extension that is more than 4 characters long</li> </ol> <p>But, after all this, the users still can't import the csv file data because "Invalid setting in Excel key of the Engines section of the Windows Registry"</p> <p><strong>Any suggestions?</strong></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Saunders
    1. US32Street
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInvalid setting in Excel key of the Engines section of the Windows Registry
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POInvalid setting in Excel key of the Engines section of the Windows Registry
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you seen this yet: http://support.microsoft.com/kb/290068?
      singulars
      1. POInvalid setting in Excel key of the Engines section of the Windows Registry
      1. USDonBoitnott
    2. COI have edited your title. Please see, "[Should questions include “tags” in their titles?](http://meta.stackexchange.com/questions/19190/)", where the consensus is "no, they should not".
      singulars
      1. POInvalid setting in Excel key of the Engines section of the Windows Registry
      1. USJohn Saunders
    3. CO@DonBoitnott - thanks for the suggestion. I've tried it but it hasn't fixed it.
      singulars
      1. POInvalid setting in Excel key of the Engines section of the Windows Registry
      1. US32Street
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload