Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BigQuery ODBC Driver error - failed to decrypt data (v2.5)

Recently, we have upgraded the simba ODBC driver  for Google BigQuery to 2.5.0.1001, and re-created the sytem DSN and Linked Server. We are getting the following error then connecting to the BigQuery.

 

Show More
[Simba][DriverSupport] (1030) Failed to decrypt data: Key not valid for use in specified state.

 

That means re-creating the DSN won't solving the issue mentioned in the document. Do we have to downgrade the driver version in order to fix this issue?

Show More
Caution: If you are upgrading to BigQuery ODBC 2.5 on the Windows platform, you may see a "Failed to decrypt" data error after the upgrade. To resolve the issue, recreate your data source names (DSNs).
Solved Solved
0 5 2,499
1 ACCEPTED SOLUTION

Hey @cassiemkt I've seen this error come up on Windows machines. Sometimes it can be resolves by looking at users permissions on the machines and ensuring that this driver is available to all users... the other solution I've seen floated is downgrading to a previous version of the driver. 

Let us know if you're still experiencing this issue... and if not, how did you fix it?!

 

View solution in original post

5 REPLIES 5