topic Arquivo .db in Brasil https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046142#M36215 <HTML><HEAD></HEAD><BODY><P>Bom dia!</P><P></P><P>Alguém sabe me dizer como conectar em um arquivo .db?</P><P></P><P>Desde já obrigado!</P></BODY></HTML> Tue, 16 Feb 2016 11:50:49 GMT cleitoncabral2 2016-02-16T11:50:49Z Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046142#M36215 <HTML><HEAD></HEAD><BODY><P>Bom dia!</P><P></P><P>Alguém sabe me dizer como conectar em um arquivo .db?</P><P></P><P>Desde já obrigado!</P></BODY></HTML> Tue, 16 Feb 2016 11:50:49 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046142#M36215 cleitoncabral2 2016-02-16T11:50:49Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046143#M36216 <HTML><HEAD></HEAD><BODY><P>Tente abri-lo através de uma conexão com banco de dados access (ODBC ou OLEDB). Ainda não fiz esse teste, mas creio que pode funcionar.</P></BODY></HTML> Tue, 16 Feb 2016 12:03:51 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046143#M36216 nicolett_yuri 2016-02-16T12:03:51Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046144#M36217 <HTML><HEAD></HEAD><BODY><P>Sim, mas eu crio uma conexão com o ODBC normalmente?</P></BODY></HTML> Tue, 16 Feb 2016 12:04:44 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046144#M36217 cleitoncabral2 2016-02-16T12:04:44Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046145#M36218 <HTML><HEAD></HEAD><BODY><P>Segue o arquivo!</P></BODY></HTML> Tue, 16 Feb 2016 12:07:19 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046145#M36218 cleitoncabral2 2016-02-16T12:07:19Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046146#M36219 <HTML><HEAD></HEAD><BODY><P>Tentei pelo driver do access, mas não funcionou.</P><P></P><P>Achei um driver que você pode testar: <A href="http://web.synametrics.com/SQLite.htm" title="http://web.synametrics.com/SQLite.htm">Using ODBC to connect to SQLite</A></P></BODY></HTML> Tue, 16 Feb 2016 12:15:10 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046146#M36219 nicolett_yuri 2016-02-16T12:15:10Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046147#M36220 <HTML><HEAD></HEAD><BODY><P>Aqui funcionou!</P><P></P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114809_1.jpg" style="height: auto;" /></P><P></P><P></P><P></P><P>ODBC CONNECT32 TO [SQLite3 Datasource];</P><P></P><P></P><P>LOAD tstamp,</P><P>&nbsp;&nbsp;&nbsp; action,</P><P>&nbsp;&nbsp;&nbsp; reason,</P><P>&nbsp;&nbsp;&nbsp; ifname,</P><P>&nbsp;&nbsp;&nbsp; ruleset,</P><P>&nbsp;&nbsp;&nbsp; rulenr,</P><P>&nbsp;&nbsp;&nbsp; subrulenr,</P><P>&nbsp;&nbsp;&nbsp; dir,</P><P>&nbsp;&nbsp;&nbsp; proto,</P><P>&nbsp;&nbsp;&nbsp; saddr,</P><P>&nbsp;&nbsp;&nbsp; daddr,</P><P>&nbsp;&nbsp;&nbsp; sport,</P><P>&nbsp;&nbsp;&nbsp; dport;</P><P>SQL SELECT *</P><P>FROM registros;</P></BODY></HTML> Tue, 16 Feb 2016 12:43:46 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046147#M36220 nicolett_yuri 2016-02-16T12:43:46Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046148#M36221 <HTML><HEAD></HEAD><BODY><P>Segue app em anexo com os dados carregados</P></BODY></HTML> Tue, 16 Feb 2016 12:44:29 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046148#M36221 nicolett_yuri 2016-02-16T12:44:29Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046149#M36222 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/28979">nicolett.yuri</A>‌ Muito obrigado funcionou, eu testei aqui no Server é a versão 64 bits, já instalei e testei e funcionou perfeitamente..</P><P></P><P>Muito obrigado mesmo pela ajuda!</P><P></P><P>Gratooooooooooooo...</P></BODY></HTML> Tue, 16 Feb 2016 12:56:02 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046149#M36222 cleitoncabral2 2016-02-16T12:56:02Z Re: Arquivo .db https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046150#M36223 <HTML><HEAD></HEAD><BODY><P>Show ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 16 Feb 2016 12:58:34 GMT https://community.qlik.com/t5/Brasil/Arquivo-db/m-p/1046150#M36223 nicolett_yuri 2016-02-16T12:58:34Z