ODBC connection

HCL Domino Domino Forum
1

Hi,

I am currently working on a project where I need to create an Agent which extracts data from a table in an Access database. I have done lots of investigations and played with bits of code but have been undecided on the method to use. I have been going down the path of using ODBC connection with an SQL statement within my LS. Someone gave me a very short code example they used to connect which simply opened the database without using ODBC (hardcoded path to db). How do I go about querying the data once at this point?

Any thoughts?

REgards

2

Subject: ODBC connection

If it is Access 2000 you would be better off using lclsx. I’ve posted some examples though I do not know the specific args to use with Access.