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.

Index › Programming Questions & Help › Integration › SQL and Processing

Ty YaBB Newbies Offline Posts: 3	SQL and Processing Nov 5th, 2007, 11:23pm   I have seen many posts that show connection to MySQL with Processing but need to know if there is a way to connect to a SQL 2000 database.

fjen God Member Offline Posts: 965	Re: SQL and Processing Reply #1 - Nov 6th, 2007, 8:20am   never tried it ( and i'm on mac ), but this should work: mysql-lib can handle other jdbc drivers as well, look into the source (included): http://bezier.de/mysql/ and the sql 2000 jdbc driver: http://www.microsoft.com/downloads/details.aspx?FamilyID=9f1874b6-f8e1-4bd6-947c-0fc5bf05bf71&displaylang=en let me know how it goes F

polymonkey Full Member Offline Posts: 137 Australia	Re: SQL and Processing Reply #2 - Nov 6th, 2007, 9:33am   as a side note that there is a great little bit of code at processing hacks for using SQL through PHP. http://www.processinghacks.com/hacks/sql?s=mysql It's been working a treat for some of the SQL stuff I've been doing.
	MattD(polymonkey)

Ty YaBB Newbies Offline Posts: 3	Re: SQL and Processing Reply #3 - Nov 6th, 2007, 9:33pm   I will give these a try.   Thanks.  Will post what happens.

Ty YaBB Newbies Offline Posts: 3	Re: SQL and Processing Reply #4 - Nov 30th, 2007, 11:02pm   I still couldn't get any of the suggested work-arounds to work as of yet.  Just had a little asp code to write the information to a .txt file and then had Processing read it from there.   I will have to come back and revisit this later though.

fjen God Member Offline Posts: 965	Re: SQL and Processing Reply #5 - Dec 1st, 2007, 11:01am   what's your setup now? did you write a SQL2000 class? .. how does it look like? did you manage to connect to a local (internal) server with it? what exactly is not working? F