topic Re: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open in Talend Studio

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open

Anonymous — Sun, 01 Apr 2012 09:22:45 GMT

Hello,
I'am new in Talend and I have a problem to integrate Talend generate java code in my program (IDE : netbeans).
I have two files : a excel file and a access file. I want to insert the path of this file in parameters.
My code is :

   
public static void  importData (String excelPath, String accessPath){
        String [] context = {"--context_param ExcelPath=C:/Users/Nat/Desktop/Template.xlsx","--context_param AccessPath=C:/Users/Nat/Desktop/DB.accdb"};
        ImportExcelToAccessSimpleTemplate.main(context);
    }

This line provide me the following exception : java.sql.SQLException: General error Unable to open registry key Temporary (volatile) Ace DSN
If I remove context-param to my talend job and write path directly on my tAccessConnection etc, it works...
Someone have an idea to solve this issue ?
Thanks,
Best regards,

Re: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open

Anonymous — Sun, 01 Apr 2012 09:53:27 GMT

I have find the solution :

    public static void main(String[] args) {
        String [] context = {"--context=Default","--context_param ExcelPath=C:/Users/Nat/Desktop/Template.xlsx","--context_param AccessPath=C:/Users/Nat/Desktop/DB.accdb"};
        ImportExcelToAccessSimpleTemplate.main(context);
    }

I have inserted file Default.properties in netbeans 🙂

Re: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open

Anonymous — Sun, 01 Apr 2012 10:34:25 GMT

Hi
Great! Glad to see you have fixed it!
Regards,
Pedro