Question

Work flow query data

Workflow

Updated December 8, 2016

asked on December 5, 2016 • Show version history

I have WF 86 installed on a 64 bit server. I have designer installed on a win 7 64 bit workstation. Running Office 2010 32 bit. I am able to created a system DSN out side of workflow but when I try to configure the connection in workflow the DSN I configured does not show up. I originally installed WF 64 on the server thart did not work so I uninstalled it and installed the 32 bit version. Could use some help.

Happy Holidays

John

0 0

Replies

replied on December 5, 2016

Install the 32 bits desdigner on your workstation

Install the 64 bits drivers you need on your workstation

0 0

replied on December 5, 2016

You'll have to install a x86 Designer too. Windows does not show x86 ODBC data sources to x64 applications and the other way around.

0 0

replied on December 7, 2016

I have installed the 32 bit designer and still can not see the system DSN in workflow designer. Still could use some help.

Thanks

John

ODBC Admin.PNG (23 KB)

| Download

ODBC.PNG (24.63 KB)

| Download

0 0

replied on December 7, 2016

This data source screenshot comes from the Workflow Server? Or from the workstation where you have the Designer?

0 0

replied on December 8, 2016

The work station where designer is installed. The excel file is also local to the machine.

0 0

View 1 previous reply

replied on December 8, 2016

That's not going to work. The Workflow Server is the one who will be doing the querying, so the data source needs to be created on the server. The file needs to be accessible to the Workflow Server service user.

(Keep in mind that services can't access mapped drives when you're setting up the data source. Also note that Excel only allows one connection at a time, while Workflow is multi-threaded. So depending on your load and design, multiple instances may try to access the file at the same time.)

0 0

replied on December 8, 2016

Does that mean Excel has to be installed on the server?

0 0

replied on December 8, 2016

If you want to use Excel data sources, then yes. That applies to all data sources. The queries are done from the server, so drivers have to be installed on the server and data sources have to be created on the server.

Though, I'd strongly recommend going with a x64 Workflow installation and the Microsoft Access Database Engine which will give you x64 drivers for Office.

1 0

replied on December 8, 2016

Thanks for your help I will most likely have the customer import the data into a SQL DB. I will also go back and install the 64 bit server and Designer.

Happy Holidays

John

0 0

You are not allowed to follow up in this post.

Question

Question

Work flow query data

Replies

Sign in to reply to this post.