AC3 Database Query

[jleichtman]

I apologize if somebody else has asked this...

I'm looking at getting an AC3 system and I will have it plugged into my home network. I want to pull the data from the AC3(I'm assuming its in some Database format) and populate it out to my public web server so I can pull up my tank stats from anywhere in the world. I also have on having two webcams setup so I can watch the Tank and the Sump while I'm away as well.

Any info that you guys can give me on how the data is stored.

my setup will be.. AC3 -> MySQL/MSSQL Server -> Router -> Public Internet Site.

All I need to know is which Database server at home I need to point the data to.

Thanks All

Shua

 

[jleichtman]

I found the PDF for AquaNotes and from the picture it looks like an ODBC Connection Database. I'm going to have to bite the bullet and buy one and start playing around until I nail it.

 

[dhoch]

Shua,

It comes with an embeded web server... If you are smart enough you can write some dynamic code (either in MSSQL or web based code... or any programming language for that matter) to pull the content off the web page that has the stats on it....

Dave

 

[jleichtman]

From the Pictures it truely looks like an ODBC database. Once I get it I just have to start doing some poking around. Since I have access to an Oracle Database Guy and a MS/MySQL guy I'm sure I will be able to figure it out. Just gotta jump in and try.

 

[kbecker]

I have excel pull data directly from the controller via the AC3 controller's cgi script. It is datalogs.cgi ... or something to that effect. I can check when I get home.

 

[clp]

The data is stored in an Microsoft Access database. You can query the database w/ your own .asp scripts if desired.

Curt