topic Problems with data retrieval from SQL Server through an ODBC connection in QlikView https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364654#M494750 <HTML><HEAD></HEAD><BODY><P> Hi everyone,</P><P>For a customer I'm creating a dashboard.<BR />Normally we always have a connection to the database via OLEDB but this customer has a connection via ODBC.</P><P>When requesting the tables I get the message below (see attachment).<BR />I have never problems when I connect via OLEDB.</P><P>Has this to do with the ODBC connection?</P><P></P><P>Thx</P></BODY></HTML> Thu, 22 Mar 2012 12:14:54 GMT jjordaan 2012-03-22T12:14:54Z Problems with data retrieval from SQL Server through an ODBC connection https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364654#M494750 <HTML><HEAD></HEAD><BODY><P> Hi everyone,</P><P>For a customer I'm creating a dashboard.<BR />Normally we always have a connection to the database via OLEDB but this customer has a connection via ODBC.</P><P>When requesting the tables I get the message below (see attachment).<BR />I have never problems when I connect via OLEDB.</P><P>Has this to do with the ODBC connection?</P><P></P><P>Thx</P></BODY></HTML> Thu, 22 Mar 2012 12:14:54 GMT https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364654#M494750 jjordaan 2012-03-22T12:14:54Z Problems with data retrieval from SQL Server through an ODBC connection https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364655#M494751 <HTML><HEAD></HEAD><BODY><P>How's your ODBC sintax in your QV script?</P></BODY></HTML> Thu, 22 Mar 2012 12:47:53 GMT https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364655#M494751 jvitantonio 2012-03-22T12:47:53Z Re: Problems with data retrieval from SQL Server through an ODBC connection https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364656#M494752 <HTML><HEAD></HEAD><BODY><P>- You will need to create a ODBC connection (system or file) DSN via (Cntrl Pnl-Admin tools-ODBC Data source).&nbsp;&nbsp; - - Once you have a successfull connection you can use the QlikView ODBC "Connect" button to connect to your new source (DSN), which should now appear in the list of available data sources.&nbsp;&nbsp;&nbsp; Hope this helps !!</P><P></P><P>Also, If you don't have a problem with the connection...Then you may have a problem with your syntax....Trying using the Select button (see attached) to make a simple selection from the source and let QlikView build the script.&nbsp; Good Luck !!</P></BODY></HTML> Thu, 22 Mar 2012 13:32:14 GMT https://community.qlik.com/t5/QlikView/Problems-with-data-retrieval-from-SQL-Server-through-an-ODBC/m-p/364656#M494752 rsark 2012-03-22T13:32:14Z