topic Unable to connect to database in QlikView https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524500#M1140352 <HTML><HEAD></HEAD><BODY><P>hi</P><P>I am unable to connect database from qlikview , i am using windows 8 qlikview 64 bit version , i tried to connect to Oracle or SQL it is showing errors can u plz help how to connect to database <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 08 Oct 2013 07:34:39 GMT 2013-10-08T07:34:39Z Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524500#M1140352 <HTML><HEAD></HEAD><BODY><P>hi</P><P>I am unable to connect database from qlikview , i am using windows 8 qlikview 64 bit version , i tried to connect to Oracle or SQL it is showing errors can u plz help how to connect to database <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 08 Oct 2013 07:34:39 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524500#M1140352 2013-10-08T07:34:39Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524501#M1140353 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Could</SPAN> <SPAN class="hps">you</SPAN> <SPAN class="hps">post the</SPAN> <SPAN class="hps">error that</SPAN> <SPAN class="hps">was</SPAN> <SPAN class="hps">displayed</SPAN>?</P></BODY></HTML> Tue, 08 Oct 2013 11:25:53 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524501#M1140353 2013-10-08T11:25:53Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524502#M1140354 <HTML><HEAD></HEAD><BODY><P>Try Clicking on Force 32 Bit in the script</P></BODY></HTML> Tue, 08 Oct 2013 11:29:27 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524502#M1140354 saumyashah90 2013-10-08T11:29:27Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524503#M1140355 <HTML><HEAD></HEAD><BODY><P>Hi Vinay,</P><P></P><P>Please post the error that was displayed</P><P>Also,please post your connection string.</P><P></P><P>Rochelle</P></BODY></HTML> Tue, 08 Oct 2013 11:30:55 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524503#M1140355 2013-10-08T11:30:55Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524504#M1140356 <HTML><HEAD></HEAD><BODY><P>Hi Vinay,</P><P></P><P>Pls make sure that you have the required drivers installed. can you please post the error.</P></BODY></HTML> Tue, 08 Oct 2013 11:37:51 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524504#M1140356 2013-10-08T11:37:51Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524505#M1140357 <HTML><HEAD></HEAD><BODY><P>I tried by Force 32 , but its not work </P></BODY></HTML> Thu, 17 Oct 2013 03:46:02 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524505#M1140357 2013-10-17T03:46:02Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524506#M1140359 <HTML><HEAD></HEAD><BODY><P>error i did not&nbsp; get&nbsp; , oracle ODBC is not showing there </P></BODY></HTML> Thu, 17 Oct 2013 03:47:21 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524506#M1140359 2013-10-17T03:47:21Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524507#M1140361 <HTML><HEAD></HEAD><BODY><P><BR />have you installed SQL server properly.... if yes go to</P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/47752_1.png" />\</P><P>Qlik on 32-bit ODBC Administrator and then you will get a name of the driver which you have installed.</P><P></P><P>like this</P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/47765_1.png" /></P><P></P><P>select you server and add it.</P></BODY></HTML> Thu, 17 Oct 2013 05:38:39 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524507#M1140361 saumyashah90 2013-10-17T05:38:39Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524508#M1140362 <HTML><HEAD></HEAD><BODY><P>Microsoft SQL Server ODBC Driver Version 06.03.9600</P><P></P><P></P><P>Running connectivity tests...</P><P></P><P></P><P>Attempting connection</P><P>[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.</P><P></P><P></P><P>TESTS FAILED!</P></BODY></HTML> Mon, 21 Oct 2013 08:08:16 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524508#M1140362 2013-10-21T08:08:16Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524509#M1140364 <HTML><HEAD></HEAD><BODY><P>Microsoft SQL Server ODBC Driver Version 06.03.9600</P><P></P><P></P><P>Running connectivity tests...</P><P></P><P></P><P>Attempting connection</P><P>[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.</P><P></P><P></P><P>TESTS FAILED!</P></BODY></HTML> Mon, 21 Oct 2013 08:09:50 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524509#M1140364 2013-10-21T08:09:50Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524510#M1140365 <HTML><HEAD></HEAD><BODY><P>Microsoft SQL Server ODBC Driver Version 06.03.9600</P><P></P><P></P><P>Running connectivity tests...</P><P></P><P></P><P>Attempting connection</P><P>[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.</P><P></P><P></P><P>TESTS FAILED!</P></BODY></HTML> Mon, 21 Oct 2013 08:10:05 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524510#M1140365 2013-10-21T08:10:05Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524511#M1140367 <HTML><HEAD></HEAD><BODY><P>Microsoft SQL Server ODBC Driver Version 06.03.9600</P><P></P><P></P><P>Running connectivity tests...</P><P></P><P></P><P>Attempting connection</P><P>[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.</P><P></P><P></P><P>TESTS FAILED!</P></BODY></HTML> Mon, 21 Oct 2013 08:10:16 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524511#M1140367 2013-10-21T08:10:16Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524512#M1140368 <HTML><HEAD></HEAD><BODY><P>Can you pls make sure that your system has access to the Database system? No firewall issues from your system to database.</P></BODY></HTML> Mon, 21 Oct 2013 08:23:00 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524512#M1140368 sudeepkm 2013-10-21T08:23:00Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524513#M1140369 <HTML><HEAD></HEAD><BODY><P>yes im sure</P></BODY></HTML> Mon, 21 Oct 2013 08:37:56 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524513#M1140369 2013-10-21T08:37:56Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524514#M1140371 <HTML><HEAD></HEAD><BODY><P>Has the Windows Account that you are logged in with been granted permission to access the SQL Server Database?</P><P></P><P>Peter </P></BODY></HTML> Mon, 21 Oct 2013 08:40:58 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524514#M1140371 Peter_Cammaert 2013-10-21T08:40:58Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524515#M1140372 <HTML><HEAD></HEAD><BODY><P>yes </P></BODY></HTML> Mon, 21 Oct 2013 08:50:59 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524515#M1140372 2013-10-21T08:50:59Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524516#M1140373 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This version number doesn't look right - it returns no results when searching the Microsoft site. For example, my 32-bit SQL Server driver is version 2000.85.1132.00. If you go to the ODBC Administrator and look at the drivers tab, scroll down to SQL Server and check the Version, Company, File and Date.</P><P></P><P>Also, Shared Memory suggests the databases and Qlikview are installed on the same machine - is this the case? If not, look at configuring TCP/IP or Named Pipes (look for the Client Configuration button when setting up/amending the DSN).</P><P></P><P>flipside</P><P></P><P><BR /> </P></BODY></HTML> Mon, 21 Oct 2013 09:21:05 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524516#M1140373 flipside 2013-10-21T09:21:05Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524517#M1140375 <HTML><HEAD></HEAD><BODY><P><IMG alt="sql.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/47914_sql.JPG" style="width: 620px; height: 354px;" /></P></BODY></HTML> Mon, 21 Oct 2013 11:46:54 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524517#M1140375 2013-10-21T11:46:54Z Re: Unable to connect to database https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524518#M1140376 <HTML><HEAD></HEAD><BODY><P><IMG alt="sql.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/47915_sql.JPG" style="max-width: 620px;" /></P></BODY></HTML> Mon, 21 Oct 2013 11:47:16 GMT https://community.qlik.com/t5/QlikView/Unable-to-connect-to-database/m-p/524518#M1140376 2013-10-21T11:47:16Z