I am using the @dbcolumn command to get data from an external .nsf file. However I get the following error message.
" the necessary external database driver cannot be located"
Any one has an idea what the cause of this error?
Subject: @dbColumn Error : “the necessary external database driver cannot be located”
Could you post your @DbColumn formula?
Subject: RE: @dbColumn Error : “the necessary external database driver cannot be located”
@If(LocalTravel = “Y”;@DbColumn(“AppServer”:“nocache”;“”:“_DIST.nsf”;“District View”;1);@DbColumn(“AppServer”:“nocache”;“”:“_CTRY.nsf”;“Country View”;1))
Subject: RE: @dbColumn Error : “the necessary external database driver cannot be located”
It’s the “AppServer” part. The first parameter is the database type, and if you are looking up something in a Notes view, it MUST say “Notes”. Other values are for ODBC sources and custom database drivers, and since you have specified “AppServer”, Notes is looking for a custom driver for an AppServer database type.
Subject: RE: @dbColumn Error : “the necessary external database driver cannot be located”
Yes, That sorted it. I was putting the name of the server where the database is located as the first parameter. thanks!