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:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Vera Nimlubergoden
Feb 19, 2015, 4:13 PM
16 Posts
topic has been resolvedResolved

Domino 9 Can't find ODBC drivers

  • Category: Domino Server
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags: ODBC
  • Replies: 3

Hi there, I'm having problems connecting to the windows ODBC drivers using scheduled lotus script tasks on the domino server.

When I open the designer client on the server and run my agent manually from there I find the ODBC driver no problem and can access my tables OK.

I'm connecting to an old Fox Pro database table.  on my domino 8.5 windows 2003 server I connected to my table using the Normal Data SOurces ODBC Admin Link.  Problem is, it's only bringing up a very limited amount of drivers on windows 2008 and not the Microsoft dBase Driver that I need.  if I put odbcad32.exe into a command prompt I can bring up the other drivers, I set them up from there.  No idea what's going on but bottom line is that my client can see and use the driver, my server can't!  Anyone got any ideas?

 

Also, I tried running the server under the system ID and my domino ID, neither worked.

~Vera Nimlubergoden
Feb 23, 2015, 9:46 AM
16 Posts
32 Bit Client

Hi Howard, thanks for your reply, I'll read the article.  I'm guessing I can find the ODBC drivers from the Designer client as it's 32 bit?

~Vera Nimlubergoden
Feb 23, 2015, 10:15 AM
16 Posts
workaround

I managed to use the Microsoft access 64 bit drivers to access my FoxPro tables.  It doesn't work in all instances though.  for example I was only able to read the tables using the Microsoft access drivers.

For now, I use the server to read the tables in it's scheduled tasks and anything that updates the tables I run from the client.


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:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal