Invalid UDL file while adding a database connection


  • I recorded a web test using VSTS 2008 Test Edition.

    Then  created an excel spread sheet with data.

    Using the new test data source wizard, I selected the 'microsoft jet 4.0 ole db provider' to connect to the file. After entering all the required details correctly, I pressed  the button 'Test Connection'.

    A message appeared 'Invalid UDL file'.

    Hence I couldnt add the data.

    My OS is WinXP with SP2 and Excel 2003.
    Tuesday, January 13, 2009 12:10 PM


  • I resolved it myself after playing with the xls file, ensuring that I defined a name in the workbook
    • Marked as answer by a2162 Wednesday, January 14, 2009 11:10 AM
    Wednesday, January 14, 2009 11:10 AM