topic Re: connecting to database problem in QlikView https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497280#M1138309 <HTML><HEAD></HEAD><BODY><P><IMG alt="aaa.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/47911_aaa.JPG" style="max-width: 620px;" /></P></BODY></HTML> Mon, 21 Oct 2013 10:24:48 GMT 2013-10-21T10:24:48Z connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497277#M1138306 <HTML><HEAD></HEAD><BODY><P>hi anybody using windows8 qlikview version i having a problem connecting to sql or Oracle , can u plz help, and please tell me how to do ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 21 Oct 2013 09:56:59 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497277#M1138306 2013-10-21T09:56:59Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497278#M1138307 <HTML><HEAD></HEAD><BODY><P>Can you paste your connection string please?</P></BODY></HTML> Mon, 21 Oct 2013 10:00:05 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497278#M1138307 2013-10-21T10:00:05Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497279#M1138308 <HTML><HEAD></HEAD><BODY><P> s</P></BODY></HTML> Mon, 21 Oct 2013 10:22:09 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497279#M1138308 2013-10-21T10:22:09Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497280#M1138309 <HTML><HEAD></HEAD><BODY><P><IMG alt="aaa.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/47911_aaa.JPG" style="max-width: 620px;" /></P></BODY></HTML> Mon, 21 Oct 2013 10:24:48 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497280#M1138309 2013-10-21T10:24:48Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497281#M1138310 <HTML><HEAD></HEAD><BODY><P>I think you haven't given the correct oracle SID</P></BODY></HTML> Mon, 21 Oct 2013 10:30:27 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497281#M1138310 2013-10-21T10:30:27Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497282#M1138311 <HTML><HEAD></HEAD><BODY><P>in your tnsnames.ora...</P><P></P><P>you'll have an entry like this:</P><P></P><P>a=</P><P>&nbsp; (DESCRIPTION =</P><P>&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 10.154.xxx.x)(PORT = 1521))</P><P>&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp; (CONNECT_DATA =</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SERVICE_NAME = B)</P><P>&nbsp;&nbsp;&nbsp; )</P><P>&nbsp; )</P><P></P><P>here B is your SID...</P><P>check if the server configuration is correct .i.e, server ip, oracle sid, db username and password.</P></BODY></HTML> Mon, 21 Oct 2013 11:11:16 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497282#M1138311 2013-10-21T11:11:16Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497283#M1138312 <HTML><HEAD></HEAD><BODY><P>where can i found tsnames.ora?</P></BODY></HTML> Mon, 21 Oct 2013 11:23:46 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497283#M1138312 2013-10-21T11:23:46Z Re: connecting to database problem https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497284#M1138313 <HTML><HEAD></HEAD><BODY><P>go to My Computer and search for tnsnames.ora</P></BODY></HTML> Mon, 21 Oct 2013 11:46:48 GMT https://community.qlik.com/t5/QlikView/connecting-to-database-problem/m-p/497284#M1138313 2013-10-21T11:46:48Z