Notes Error - <Data access application error> Could not execute @db function

HCL Domino Domino Forum
1

Hi All,

Now I am trying to create a field, that could use @DBcolumn to retrieve a list of data from a spreadsheet. But I got the error msg stated in the subject. Do not know the reason.

I have put the spreadsheet in the local drive, then using ODBC to set up a Microsoft Excel Driver. then Using @Dbcolumn(“ODBC”: “NoCache”…) to retrieve the data. But whenever I run, I got the error msg.

Below is the whole code:

@DbColumn(“ODBC”:“NoCache”;“BAT”;“”;“BATDB”;“Invoice No.”;“Distinct”:“Ascending”)

BAT - the ODBC file name;

BATDB - the excel file name;

Invoice No. - the column header name;

Anyone has idea how to slove it? Thanks for all the helps.

Thank you. =)

2

Subject: Notes Error - Could not execute @db function

I think you are not passing any user-id. But then you should also have an empty password-parameter.

3

Subject: RE: Notes Error - Could not execute @db function

Hi Rob, I have tried, but still can not work. I am not sure if the ODBC set up is correct.