ODBC & Jet Engine Registry Entry Error

Discussion in 'Windows 7 Help and Support' started by Steiny, Jan 18, 2010.

  1. Steiny

    Steiny New Member

    Joined:
    Jan 18, 2010
    Messages:
    4
    Likes Received:
    0
    Hi,I have an application which uses sun.jdbc.odbc.JdbcOdbcDriver to bridge from JDBC to ODBC. First I created a simple CSV file and registered it as a Text Data Source using the ODBC Data Source Administrator.

    Now whenever I try to change the file extension list for this data source to only include *.csv it sometimes seems to save ok, other times it displays a message box saying "Invalid setting in Excel key of the Engines section of the Windows Registry". When it appears to save ok, if I run my application a runtime exception is generated with the same error message as above.

    I searched this error and came across You receive an error message when importing, exporting or linking text files and ACC2000: Run-time Error 3433 When You Import or Export a Text File. However these problems are different or the solution has already been applied.

    I tried setting the data source again and noticed that all the default extensions that I had removed were back again, and it also included another one which had a few strange characters in it. This can be seen in the attached screenshot.

    After spotting this bit of weirdness I tried just going with the default extension *.* and then it seemed to work fine. Why am I seeing this strange behaviour?
     

    Attached Files:

  2. reghakr

    reghakr Excellent Member

    Joined:
    Jan 26, 2009
    Messages:
    14,220
    Likes Received:
    180
    I'm no expert on ODBC, but have you tried re-installing Excel.
     

Share This Page

Loading...