Question

How can I setup an ODBC connection in Workflow on a 64 bit server?

Workflow

Updated April 23, 2014

asked on April 23, 2014

I have an Excel spreadsheet on the workflow server that I am trying to make an ODBC connection to from workflow but have run into a problem.

1. Excel is installed on the server

2. The worksheet I'm trying to access is in a folder on this server

3. The server has a 64 bit OS

The 32 bit ODBC interface doesn't show Excel driver as an option after doing some research I discovered that there is a different ODBC interface in C:\Windows\SysWOW64\odbcad32.exe that does work and lets me set up the connection to my Excel file. However when I try to get to this connection with workflow it brings up the 32 bit interface and I don't see the connection to the file that I created.

How can I get workflow to look-up data on an Excel 2010 file?

Thanks Sandy

0 0

Answer

SELECTED ANSWER

replied on April 23, 2014

You don't need Excel, you need the driver for it and it needs to match the archtecture. Like Bert said, you can either install the x64 Office drivers to go with your x64 Workflow or you can change WF to x86 to match the x86 driver installed with Excel. Unfortunately, it's not possible to have both the x64 drivers installed and Office.

If you have a choice, I'd go with x64 because it allows Workflow access to more resources.

0 0

Replies

replied on April 23, 2014

If you install Microsoft Access Database Engine 2010, it will give you x64 drivers for Office.

One thing to keep in mind though is that Excel only allows one connection at a time and Workflow may run multiple instances of the same rule concurrently.

0 0

replied on April 23, 2014

I just need workflow to look-up the values once a day to create a shortcut for each row found. On average the rows should be less than 50 - so I should be OK right?

Thanks

Sandy

0 0

replied on April 23, 2014

Yeah, that would be fine.

0 0

replied on April 23, 2014

Thank you for providing the download link. Trying to install it - it stops me because it sees the 32bit Office products installed and wants me to uninstall them first. I tried installing the 32 bit version of what you gave me but it didn't solve my problem - I get an error saying the Microsoft Jet OLE 4.0 provider is not register to the local machine when I try direct connect and if I try ODBC I don't get the choices....

So if I need to install the 64 bit ODBC driver in order for this to work, my question is - does workflow have to Excel installed on the server in order to access the spreadsheet OR can I uninstall Excel then install the 64 bit driver and be on my way?

Thanks for you're help - sorry this is such a pain.

Sandy

0 0

replied on April 23, 2014 • Show version history

The problem is that the X64 version of Workflow can not access the X86 ODBC drivers. That is why Miruna told you to install the X64 version of the drivers. If you do not need to use the actual Office products on the server, uninstall Office and just install the drivers from the link provided above. If you do need to have the Office products on the server, then you need to remove the X64 workflow and install the X86 version of Workflow to be able to access the X86 ODBC drivers.

0 0

replied on April 23, 2014

Got it thanks!

0 0

You are not allowed to follow up in this post.

Question

Question

How can I setup an ODBC connection in Workflow on a 64 bit server?

Answer

Replies

Sign in to reply to this post.