Um blog sobre nada

Um conjunto de inutilidades que podem vir a ser úteis

Tableau driver problem querying SQL 2012

Posted by Diego em Fevereiro 25, 2014


Just sharing a situation I’ve been through these past few days.

 

After updating a SQL Server Instance from 2008R2 to 2012, a dashboard that connected to a DB on that instance – and was working perfectly fine – started to produce a “driver not found ” error.

After some digging I realized that the problem was due to a particular GROUP BY clause. If the group by was there, I got the error, otherwise not.

 

Checking the XML, I realized that, on the presence of the GROUP BY, tableau was adding the highlighted clause bellow to the connection tag:

 

<connection authentication=’sqlserver’ class=’sqlserver’ dbname=’XXXXX’ minimum-driver-version=’SQL Server Native Client 10.0′ odbc-native-protocol=’yes’ server=’XXXX’ username=’XXXXX’ workgroup-auth-mode=’prompt’>

 

It’s  clearly telling you that the minimum driver necessary to that operation is the Native client for SQL 2008.

First thing I wondered was: why didn’t tableau put this clause before when the DB was SQL 2008? – I don’t really have an answer to this question.

 

 

To fix the problem I had to install the Microsoft SQL Server 2012 SP1 Native Client x64 (version 11.0.2100.60) driver (found here http://www.tableausoftware.com/support/drivers), which felt a little strange because:

1) I didn’t have to install the above driver to query SQL 2012 in the first place (any queries without the GROUP BY clause where working)

2) The dependency clearly says native client version 10 (which was installed) – not sure why only v11 fixed the problem.

 

Anyway, just sharing the information.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

 
%d bloggers like this: