| Author |
|
mezlock
Newbie
Joined: October 20 2006
Location: United States
Online Status: Offline
Posts: 9
|
| Posted: October 20 2006 at 20:33 | IP Logged
|
|
|
Well I finally found the powerhome software as something much better for controling X10 and others. Would really like to do some larger data manipulation and use the database functionality.
But,in the FAQ section it says I can connect to the database using ODBC, and although I can use Access for example, I can not figure out how to do the OBDC thing and have been looking and reading for days. Perhaps it is right here but I haven't found it. How does one connect to this database from outside powerhome ??? 
HELP!
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: October 21 2006 at 09:59 | IP Logged
|
|
|
Welcome!
Check this thread.
|
| Back to Top |
|
| |
mezlock
Newbie
Joined: October 20 2006
Location: United States
Online Status: Offline
Posts: 9
|
| Posted: October 22 2006 at 14:52 | IP Logged
|
|
|
Tony,
Thank you!
I now have my ODBC concection to work, need to make sure correctly! At first is didn't work but when I started Powerhome it must start the server and then it works fine. Since I know what I'd like to do I need to find the porper table(s) and hopefully it will work. Ever se a table listing with info?
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: October 22 2006 at 17:54 | IP Logged
|
|
|
The user manual had table listings, but I believe several tables have changed. Dave will need to chime in on this one.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 24 2006 at 17:25 | IP Logged
|
|
|
Mezlock,
Welcome to PowerHome! I see that Tony has you covered on ODBC connectivity (thanks Tony  ).
The manual is a bit out-of-date on table listings (one of the reasons Im still in beta). However, the PowerHome Multi-Editor is a good research tool. If you shift into SQL mode (shift-F5) and press Alt-6 (these are on the "Edit" menu under "Language" and "AutoComplete" respectively so you don't have to remember these keystrokes), you'll get a list of all of the PowerHome tables. You can also get this by typing:
Code:
| select * from systable where creator = 6 |
|
|
Once you have a list of table names, then a simple
is handy for getting the structure. You can also get the details using this SQL:
Code:
| select * from syscolumns where tname = 'TABLENAME' order by colno |
|
|
Be sure to check out the available system tables by pressing Alt-5.
HTH,
Dave.
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: October 24 2006 at 19:52 | IP Logged
|
|
|
Saved to my PH notes file!
|
| Back to Top |
|
| |
mezlock
Newbie
Joined: October 20 2006
Location: United States
Online Status: Offline
Posts: 9
|
| Posted: October 26 2006 at 19:54 | IP Logged
|
|
|
Dave and Tony,
Thank you much!
As much as I want to dig in it has been a very busy week for me between work and another project. Hope to be back at it tomorrow.
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Powerhome Database
