topic Re: Odbc connection error in QlikView https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034519#M348886 <HTML><HEAD></HEAD><BODY><P>Does your SQL Server allow for connections over tcp/ip?</P></BODY></HTML> Wed, 20 Jan 2016 14:03:20 GMT Peter_Cammaert 2016-01-20T14:03:20Z Odbc connection error https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034515#M348882 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>while creating odbc connection after giving data source name db server and ntname authentication</P><P>it is giving error as</P><P></P><P></P><P>connection failed</P><P>sqlstate:'01000'</P><P>sqlserver error:<SPAN style="font-size: 10pt; line-height: 1.5em;">2</SPAN></P><P></P><P></P><P>any one please help me how to create</P><P></P><P>thanks in advanse</P></BODY></HTML> Wed, 20 Jan 2016 09:15:19 GMT https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034515#M348882 Anonymous 2016-01-20T09:15:19Z Re: Odbc connection error https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034516#M348883 <HTML><HEAD></HEAD><BODY><P>It is nothing to do with Qlikview. Please check the below link</P><P></P><P><A href="https://support.microsoft.com/en-us/kb/818047" title="https://support.microsoft.com/en-us/kb/818047">https://support.microsoft.com/en-us/kb/818047</A></P></BODY></HTML> Wed, 20 Jan 2016 09:38:31 GMT https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034516#M348883 manojkulkarni 2016-01-20T09:38:31Z Re: Odbc connection error https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034517#M348884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>in ODBC management (in Windows, not QlikView) you might have a Test Connection button.</P><P>Does it work?</P><P>S.</P></BODY></HTML> Wed, 20 Jan 2016 13:46:09 GMT https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034517#M348884 simospa 2016-01-20T13:46:09Z Re: Odbc connection error https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034518#M348885 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Do check this,</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-8973">Loading ODBC and OLE DB Data (video)</A></P><P></P><P>-Hirish</P></BODY></HTML> Wed, 20 Jan 2016 14:02:05 GMT https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034518#M348885 HirisH_V7 2016-01-20T14:02:05Z Re: Odbc connection error https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034519#M348886 <HTML><HEAD></HEAD><BODY><P>Does your SQL Server allow for connections over tcp/ip?</P></BODY></HTML> Wed, 20 Jan 2016 14:03:20 GMT https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034519#M348886 Peter_Cammaert 2016-01-20T14:03:20Z Re: Odbc connection error https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034520#M348887 <HTML><HEAD></HEAD><BODY><P>Have you actually created the ODBC connection in Windows first? And actually tested it?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112127_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Andy</P></BODY></HTML> Wed, 20 Jan 2016 15:07:34 GMT https://community.qlik.com/t5/QlikView/Odbc-connection-error/m-p/1034520#M348887 awhitfield 2016-01-20T15:07:34Z