locked
ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified RRS feed

  • Question

  • Hi, 
    I Get this error when trying to extract data from SQL database to Excel format on a 2003 Server 64 bits
    ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    here is my connectionstring:

    string connectionString = string.Format("Driver={{Microsoft Excel Driver (*.xls)}};FIL=excel 8.0;DriverId=790;DSN='';READONLY=false;DBQ={0};", saveFileDialog.FileName);
    System.Data.Odbc.OdbcCommand odbcCmd = new System.Data.Odbc.OdbcCommand("", new System.Data.Odbc.OdbcConnection(connectionString));

    It works fine on my personnal computer but stuck on the Server
    is it due to 64 bits ?

    Any Idea ?

    Thanks



    Wednesday, September 10, 2008 4:10 PM

Answers