Domino 9 Can't find ODBC drivers

HCL Domino Domino Forum
1

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.

2

Subject: ODBC drivers are not provided by IBM

I assume the drivers you need are not in Windows Server 2008 (but were on your desktop computer). Another issue is that 32 bit ODBC drivers don’t work on a 64 bit Windows with 64 bit Domino.

Maybe this article will help you? http://www.jirc.com/2009/12/04/where-did-all-the-odbc-drivers-go-from-windows-server-2008-64bit/ http://www.jirc.com/2009/12/04/where-did-all-the-odbc-drivers-go-from-windows-server-2008-64bit/

Howard

3

Subject: 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?

4

Subject: 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.