wynalazkowo - eksperymenty małe i duże

RaspberryPI – project for „Baltic Robo Battles” 11 – how to connect from php to ActianZen

RaspberryPI – project for „Baltic Robo Battles” 11 – how to connect from php to ActianZen

Easy way – using ODBC connection: a) created 64-bit ODBC connection (System) in Windows b) create user in your DB acc. to ODBC connection c) use following source code: $conn_str=”dnsNameofYourDB”; $conn=odbc_connect($conn_str,’user’,’passwd’); $sql=”SELECT top 10 First_Name,Last_Name FROM Person”; $rs=odbc_exec($conn,$sql); if ($rs) { while (odbc_fetch_row($rs)) { echo odbc_result($rs,”First_Name”); echo odbc_result($rs,”Last_Name”); } } odbc_close($conn); 2. proper way acc.Więcej oRaspberryPI – project for „Baltic Robo Battles” 11 – how to connect from php to ActianZen[…]

RaspberryPI – project for „Baltic Robo Battles” 9

RaspberryPI – project for „Baltic Robo Battles” 9

In order to make our project more multimedia, we create some movies around „the making of”. All of the movies are recorded using cellphones – so nothing expensive and special. Nowadays cellphones have such a power that you will not see much difference between movie recoded by more professional camera and the cellphone. As postproductionWięcej oRaspberryPI – project for „Baltic Robo Battles” 9[…]

How to connect to ActianZen DB located on Windows server from RaspberryPI?

How to connect to ActianZen DB located on Windows server from RaspberryPI?

Again thanks to ActianCommunity, finally I found simple solution described here: https://www.codeproject.com/Articles/4113942/Embedded-IoT-Databases-with-Actian-Zen-and-Python to make it working also on Raspbian you have to issue following cmds : (as zen-svc) dsnadd -dsn=demo -db=Demodata -host=magda (as root) cat /usr/local/actianzen/etc/odbc.ini >> ./odbc.ini cat /usr/local/actianzen/etc/odbcinst.ini >> ./odbcinst.ini Install also pyodbc library (as root): apt-cache search odbc | grep python apt-getWięcej oHow to connect to ActianZen DB located on Windows server from RaspberryPI?[…]

RaspberryPI – how to install and run SMB client and server

RaspberryPI – how to install and run SMB client and server

First of all update the package list and all our packages by running the following two commands (as root). 2. Now that we have our Raspbian operating system entirely up to date, we can now proceed on to installing the Samba software to our Raspberry Pi. sudo apt-get install samba samba-common-bin 3. Before we setWięcej oRaspberryPI – how to install and run SMB client and server[…]

RaspberryPI – project for „Baltic Robo Battles” 7

RaspberryPI – project for „Baltic Robo Battles” 7

Now it is time to install ActianZen on RaspberryPI. As everybody knows RaspberryPI has its own Operating System called Raspbian – it is clone of Debian, my favourite Linux version;) So in this case installation of ActianZen couldn’t be difficult and there were only few simple steps: download ActainZen for Raspbian from Actian www copyWięcej oRaspberryPI – project for „Baltic Robo Battles” 7[…]