You are viewing limited content. For full access, please sign in.

Discussion

Discussion

ODBC Error From Workflow Connecting to CSV File

Workflow
Updated April 24, 2017
posted on April 19, 2017

We have created a System ODBC connection within Windows to a CSV file and can test that connection successfully. When we setup the ODBC connection as a Data Source within Workflow we receive the following error message:

Any idea as to why we would be having a problem from within Workflow but in the ODBC administration itself?

1 0
replied on April 24, 2017

Just wanted to state that while csv can be used as a data source for workflow, in a production environment, you should try to avoid it.  The Text/CSV files are locked when opened and can cause issues if multiple workflows are trying to access the file at the same time.

1 0
replied on April 24, 2017

Make sure that the full path is defined in the DSN. You MIGHT need to define it as network such as \\computer\c$\directory.

 

If you can't do this through ODBC then you will need to modify it through the registry:

1. HKey_Local_Machine\software\Wow6432Node\odbc\odbc.ini\<DSN Name>

2. Change the DefaultDir and DBQ fields with the full file path

0 0
replied on April 19, 2017

Hey Blake, this looks like a user access error. the user that is utilized by workflow service may not have access to the path where the file resides. I have seen this happen when the Workflow service is running under local system account and the csv file is located on a different server or the folder where the csv file is located has special permissions.

 

Tato

0 0
replied on April 19, 2017

We checked that, but it is indeed using specified windows account. We can log into Windows with that user account and access the file, so permissions should be good. Just not sure what else to check.

1 0
replied on April 19, 2017

That is weird. I did a similar configuration just to test and I cannot replicate your error.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...