ODBC errors

Using ODBC to connect to another database can be an important requirement, whether the connection is part of the initial data import or an ongoing integration.

There are a couple of error messages that you might experience when using the ODBC connection within DAX, with the main two, often cryptic messages being returned being:

error 1: Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english

error 2: [Microsoft][SQL Server Native Client 10.0]Invalid Descriptor Index

Continue reading