This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've created a workflow locally, then attempted to promote it to the gallery and got the following error:
Oops! The job CreateJobWF did not complete successfully and resulted in the following errors: • Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (Tool Id: 6)
Is it really that I have on my desktop a SQL Server ODBC driver version 6.01.7601.17514 and the Gallery has version 6.03.9600.17415 ?
I'll try to find the specific version for install, but would like to check that this is the issue.
You need to check the bitness of the actual SQL ODBC Driver on the Server, not the bitness of the computers. I am not sure if you are using and USER or SYSTEM DSN but you could check also to see if that DSN name is showing up on the 64 bit ODBC DataSource Administrator or your 32 bit one. To check the 32 bit one, make sure you don't already have the ODBC Data Source Administrator running in 64 bit, your default, because it will still be showing the 64 bit DSNs.