Processing and SQL server on Windows
Tim Regan has a comprehensive description of how he got SQL Server 2008 running with processing. I found some steps to be superfluous while others were missing (it was still an invaluable guide though), here’s how I did it:
- Get the SQL Server JDBC driver, be sure to get the Windows version
- Unpack it somewhere and copy
sqljdbc.jar
tolibraries\sqljdbc\library
in your Processing folder - Copy
qljdbc_auth.dll
from theenu\auth\x86
folder of jdbc toC:\Windows\System32
- In your sketch, do Sketch->Import Library->sqljdbc
- You can now use the helper class from Tim’s post (which is inspired by the one in Ben Fry’s book)
Note that it is apparantly not necessary to muck around with the CLASSPATH
. Happy querying!
Leave a Reply