7 Replies Latest reply on Feb 7, 2019 2:29 PM by Dan Cory

    SQL Server Minimum Driver

    andy.yu

      Hello everyone,

       

      I've been trying to research a strange issue I'm having.

       

      We're currently on SQL Server 2012 and using Tableau 9

       

      • I open Tableau and connect to SQL Server
        • Enter in my connection information as usual
        • Connect to a VIEW
        • Save my workbook.

       

      • So when I connect to this particular view (e.g., vw_departments)
        • After saving I open the workbook up in Textpad and see the connection information below.
        • I see this extra bit of information (minimum-driver-version .....)

       

      <connection authentication='sspi' class='sqlserver' dbname='XXXX' minimum-driver-version='SQL Server Native Client 10.0' odbc-native-protocol='yes' server='YYYY'>

       

      • But the weird thing is, when I connect to a different view (e.g., vw_employees)
        • I get the connection information below, WITHOUT the "minimum-driver-version"

       

      <connection authentication='sspi' class='sqlserver' dbname='XXXX' odbc-native-protocol='yes' server='YYYY'>

       

      Would anyone have any ideas or where I might look to see why it's causing this issue?

        • 1. Re: SQL Server Minimum Driver
          Dan Cory

          I'm not sure what problem this is causing you, but if you are curious:

           

          The different versions of the SQL Server driver report data types a bit differently. If you have such a column in your table, we mark the connection to make sure you use at least that version of the driver.

           

          Dan

          1 of 1 people found this helpful
          • 2. Re: SQL Server Minimum Driver
            andy.yu

            Thanks Dan.

             

            So I took your advice and looked at the two separate views.

             

            I'm not sure if this is causing it or not, but in our SQL Server view, we have one column of a datatype of "date".

             

            But once I switched it to "datetime" I didn't get that "minimum-driver-version" comment in the connection string anymore.

             

            I'm going to test it some more but hoping that was the cause of it.

             

            Thanks again!

            • 3. Re: SQL Server Minimum Driver
              Dan Cory

              Yes, the various types of date fields are the issue.

               

              Dan

              • 4. Re: SQL Server Minimum Driver
                Jess Hansen

                Thanks for your reply Dan, very useful. I have the same issue. I am working in an IT environment where newest drivers are not easily installed on computers and thus getting the 10.0 drivers spread across the organization is a hazzle. However, I still need datetime variables in my data source. How can I work around this error?

                 

                Thanks in advance!

                • 5. Re: SQL Server Minimum Driver
                  Dan Cory

                  Jess - Specifically what error are you seeing that you are trying to work around? And what mix of drivers do you have?

                   

                  In general this should only be an issue on drivers that are quite old at this point, and Tableau has been including updated SQL Server drivers at install time for quite a while. So I'd be surprised you are running into any problems.

                   

                  Dan

                  • 6. Re: SQL Server Minimum Driver
                    Jess Hansen

                    Hi Dan.

                     

                    I am running Tableau 10.3.0 on 32 bit machines. There are no native SQL drivers installed on the machines. I am getting the error below when trying to open the workbooks.

                     

                    • 7. Re: SQL Server Minimum Driver
                      Dan Cory

                      You are going to need some SQL Server driver. They should have been installed automatically with 10.3, unless you explicitly turned them off in the install dialog.

                       

                      I recommend you contact support and share the logs from one of the affected machines. They will also want to see the text that shows when you press the "Show Details" button above.

                       

                      Also, you are running the first maintenance release 10.3.0. Current release of 10.3 is 10.3.17. Upgrading to a newer maintenance release might help.

                      You could also upgrade to 10.4 (current release 10.4.13). Later versions are not supported on 32-bit machines.

                       

                      Dan

                      1 of 1 people found this helpful