We closed this forum 18 June 2010. It has served us well since 2005 as the ALPHA forum did before it from 2002 to 2005. New discussions are ongoing at the new URL http://forum.processing.org. You'll need to sign up and get a new user account. We're sorry about that inconvenience, but we think it's better in the long run. The content on this forum will remain online.
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1
Access Database? (Read 927 times)
erinc
Access Database?
May 11th, 2006, 11:51am  
Hi,

Is there a library or class or anyway to connect microsoft access database ?
Back to top
 
 
fjen
Re: Access Database?
Reply #1 - May 11th, 2006, 3:28pm  
i don't think there is ..

if you're familiar with java you could try to follow the approach outlined here. maybe have a look at processinghacks too (PHP can talk to Access [1] [2]).

i was thinking about expanding my mysql-library to include other databases as well. but i have no time at the moment to work on that ... the source-code is inside the jar, if you want to look at how i did it.

best,
F
Back to top
 
WWW  
fry
Re: Access Database?
Reply #2 - May 11th, 2006, 3:59pm  
any jdbc driver for java that works with access will work with processing. just add the .jar files for the driver to your sketch (drag the jar into the sketch window and see it say "one file added to sketch"). then, just connect to it the same way you would with java. i.e. you'd probably do a connect() in setup, and then run queries at certain events like mousePressed or whatever.
Back to top
 
WWW  
seltar
Re: Access Database?
Reply #3 - May 11th, 2006, 10:10pm  
fjen: i'm not sure how this would be, or if it at all could be done, but is there anyway to add some encryption of the password, or be asked to type it.. i don't know, but the problem with using the mysql library, is that it can be decompiled, and people can get ahold of your password.
Any safe way at all to get around this?

-seltar
Back to top
 
I'm bored, therefore I program
http://seltar.org  > seltar's special place
http://snippet.seltar.org > seltar's snippet palace
http://libraries.seltar.org > seltar's libraries
WWW  
fjen
Re: Access Database?
Reply #4 - May 12th, 2006, 9:21am  
hi!
yeah, i'm aware of that. there are some additional problems that arise from handing out an app or applet using the lib:
- you will have to open your mysql-server to let it be accessed from outside localhost.
- applets need to be signed to access other servers than the one they came from.

here are a couple of notes on that (scroll down to "applets").

so. i guess the lib is rather for closed environments or home-use. sadly.

F
Back to top
 
WWW  
Page Index Toggle Pages: 1
‹ Previous Topic | Next Topic ›