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

[favouriteanimal]

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. =)

 

[pmonett]

Where is the Notes database located, on a server, or on your local disk ? If it is on the server, then there's a good chance that the server is trying to establish an ODBC access to a connection it does not have.
Your solution can work locally, but it will only ever work for you given the parameters of execution.


Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[favouriteanimal]

Hi Pascal,

Thanks for your advise. Now I run it locally but still can not work, get the same error msg. What's the meaning of "given the parameters of execution"?

Thanks for your help.

Wang Qi

 

[pmonett]

Means that since you're calling a local ODBC connection, nobody else is going to be able to use your application in that way.
So you put the db locally and it still does not work ? Did you make a functionality test of your ODBC link ?
Another thing : do you have MS Excel on your PC. If so, can you test if Excel can open a Notes db ? Normally, if your ODBC is working, it works both ways and you should be able to open a Notes database from Excel.
If none of that is working, I'd make sure your ODBC drivers are compatible with Notes. You did install the Office ODBC extensions, right ?

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.