Get Data from access database

HCL Domino Domino Forum
1

I need someone help,

My problem is that i have created the linked table from EXCEL to get data by executeing SQl statement to ACCESS database

when i want to run the agent there is one Error message comes in server console.

message is “Operation is disallowed in this session”

. what should i do. bcz i want to import data from excel to notes by agent .

for doing this process i have created a database and created the linked table with excel sheet,

and i have created a dsn to connect that database so this error message comes ,when i run the agent,

i am puting the agent property for help

RUN TIME

On Event

“Action Menu Selection”

and

Target “All New & Modified Document”

please solve my problem if any one have any idea

thanx & regards

zubair a khan

2

Subject: Get Data from access database

Zubar,

I would suggest that you Google that error message or search this forum on it since others have done a much better job than I ever could in explaining what it means.

Also, since you already have a DSN involved, why not just point it directly at the Excel data rather than involving Access and linked tables? You are adding a layer of complexity to your design that is not required.

3

Subject: RE: Get Data from access database

Hi Dave,

thanks for quick response, i will surely use the direct connection by writing lotuscript agent but i m trying to run java agent by creating DSN.

thanx & regards

Zubair A Khan