topic Re: How can I run a sql query??? - QlikView Server in QlikView https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453696#M698430 <HTML><HEAD></HEAD><BODY><P>I guess you are running x64 server.</P><P>No x64 ODBC driver exists for MS Access?</P></BODY></HTML> Wed, 20 Feb 2013 13:02:57 GMT jerrysvensson 2013-02-20T13:02:57Z How can I run a sql query??? - QlikView Server https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453695#M698429 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>how can I run a query on a db using a macro??</P><P></P><P></P><P>on the desktop version i use this macro:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13613516924614116" jivemacro_uid="_13613516924614116"><P>set con = CreateObject("ADODB.Connection") </P><P></P><P>&nbsp;&nbsp;&nbsp; con.Open("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\demo_sviluppo\Budget_Vendite\Bgt_Salvataggi.accdb;")</P><P></P><P>&nbsp; ins = "INSERT into Bgt_Salvataggi values ('3','ciao')"</P><P></P><P>&nbsp; con.execute(ins)</P><P></P><P>&nbsp;&nbsp;&nbsp; con.Close</P><P></P></PRE><P></P><P></P><P>I need help on the server version??</P><P></P><P></P><P>thanks for the replies!</P></BODY></HTML> Wed, 20 Feb 2013 09:14:12 GMT https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453695#M698429 Anonymous 2013-02-20T09:14:12Z Re: How can I run a sql query??? - QlikView Server https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453696#M698430 <HTML><HEAD></HEAD><BODY><P>I guess you are running x64 server.</P><P>No x64 ODBC driver exists for MS Access?</P></BODY></HTML> Wed, 20 Feb 2013 13:02:57 GMT https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453696#M698430 jerrysvensson 2013-02-20T13:02:57Z Re: How can I run a sql query??? - QlikView Server https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453697#M698431 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>try to look here</P><P><A href="http://answers.microsoft.com/en-us/office/forum/officeversion_other-access/64-bit-driver-for-dsn-for-ms-access-database/be8c0ad4-d8fd-48e0-9026-b95d84135820" title="http://answers.microsoft.com/en-us/office/forum/officeversion_other-access/64-bit-driver-for-dsn-for-ms-access-database/be8c0ad4-d8fd-48e0-9026-b95d84135820">64 bit driver for DSN for MS access database - Microsoft Community</A></P></BODY></HTML> Tue, 01 Oct 2013 02:50:01 GMT https://community.qlik.com/t5/QlikView/How-can-I-run-a-sql-query-QlikView-Server/m-p/453697#M698431 2013-10-01T02:50:01Z