Question

Error in ODBC using Workflow

Workflow

Updated May 16, 2014

asked on May 15, 2014

Does anyone have any ideas for the following error?

We get this semi0frequently at clients and always end up moving the file to the local drive and then Workflow works. That however is not an option here.

I am just using an .xls ODBC system DSN. I do not understand the error as I can map a drive to the location, browse to the location manually, and open the file. I am logged into their server as an administrator and using Windows Authentication in the ODBC. During the setup of the ODBC I can browse to the file as well. Its when I click to select the table that I get the error and I can't make any sense as to why. I clearly have access to the file and the path is correct...

Thanks

0 0

Answer

SELECTED ANSWER

replied on May 16, 2014

If I remember correctly, you cannot use a network drive in a system DSN with Workflow. You need to define what's called a DSNless connection as follows:

...then:

...and finally something like:

Hope that helps

1 0

Replies

replied on May 16, 2014

Thanks Louis. Never had to use the direct connection before. That worked for us and I was able to connect.

For others that do this since the screenshot was cuttoff you need the name of the file but WITHOUT the extension. Was still getting errors and could not figure out why. In the database field It should look like this:

\\servername\foldernames\filename

I was using:

\\servername\foldernames\filename.xls

Thanks again!

1 0

replied on May 16, 2014

Glad Chris it worked!

Let me know if you expect concurrent accesses to the spreadsheet (e.g. multiple workflow instances) as there are additional considerations you need to be aware of.

0 0

You are not allowed to follow up in this post.

Question

Question

Error in ODBC using Workflow

Answer

Replies

Sign in to reply to this post.