This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Querying an access db from scheduled agent on 64bit Domino server using ODBC
Probably a bit late, but in case it helps someone else here is a solution that worked for me ...
I needed to query a Microsoft Access database from a scheduled Lotusscript agent on a R8.5.3 server on Win 2008 server. Was getting the error "Error - LS:DO- ODBC could not complete the requested operation", at the point where I did a con.ConnectTo("<data source name>")
The agent worked fine when I tried it with a Notes client installed on the same server.
Turned out that my server was 64 bit, but I had 32bit ODBC drivers installed (which allowed Notes client on the server to successfully run a test agent querying Access db on a network file share).
When I removed the 32 bit drivers, and installed the 64bit drivers, then scheduled agent on Domino was able to query the Access db using ODBC.
Here are the general steps that worked for me:
1) Access db file is on another server
- In order to be able to use an ODBC data source that point to an Access db on the network, the Domino Server service needs to be running under a domain user account - see http://www-01.ibm.com/support/docview.wss?uid=swg21088498,
- That user account needs permission to read the Access db (may also need write privs so that it can create / update a lock file if multiple users need to use the Access db simultaneously)
2) Download and install "Microsoft Access Database Engine 2010 Redistributable"
- The Microsoft url in Sep 2013 is http://www.microsoft.com/en-ie/download/details.aspx?id=13255
- This will install either the 32bit or 64bit ODBC drivers
- If you are using 32bit server then you need to install the 32bit version, etc.
- For the 32bit version you need to use C:\Windows\SysWOW64\odbcad32.exe to create the data source
- If you install the 32bit version, and set up the 32bit ODBC data source, then it will work fine testing with an agent with Notes client installed on the server (Notes client is 32bit), but will give the error mentioned above with an agent run on a 64bit Domino server (eg. a scheduled agent).
- Note also that the scheduled agent being run under the Domino server will not have any mapped drives to the network location of the Access db, so define your data source using UNC paths (eg. \\serverName\folder\myAcccessDb.accdb
hth
Feedback response number WEBB9BXFM9 created by ~Vijay Dwowebergobu on 09/27/2013
Querying an access db from scheduled agent on 64bit Domino server using ODBC
Return to top
. . Querying an access db from schedule... (~Vijay Dwoweber... 27.Sep.13) 
