charts or trending on access from oracle 9i
Hello, I was wondering if someone is willing to help me with a little problem, I have to write a code to do some trending from a database, the issue is that the DB is on oracle 9i, and I know pretty much nothing about mannaging DB on oracle, so i thought about writing a script to do the trending from an access or excel DB (all the data is going to be taken out from the oracle one via ODBC), but I don't have the experience to do the script.
Is there a way that you can show me a script to do some charts and trending, so I can modify them to meet my needs?
Thanks in advance.
PS: I'm what we all know as a noob on this subject. :blush: :wave:
Re: charts or trending on access from oracle 9i
How much data are we talking about? Excel can only handle 65536 records per sheet.
You can find an ADO Database tutorial at the top of the DB Forum by
Beacon. Its a good starting point.
If youimport the data into Access as linked tables (or completely imported
depending of # of recs) then you could run your queries against them and
export the results into an Excel spreadsheet and graph or chart it. Easier
then trying to write Oracle queries.
Also, checkout connectionstrings.com for the appropriate connection string
for OD and Oracle.
Re: charts or trending on access from oracle 9i
it's a lot of info is an historical database for at least a 1000 points, but i'm going to get the exact number shortly.
About the ADO DB tutorial, I'm going to read it and see if I can get an idea of how it does work.
later I'm going to try to connect the database to my pc using the tutorial, the thing is that I need to read and trend some values of a database based on oracle on a PC with Access and/or excel, also I would need some help making a script to login/logoff/login, o I can get the hiistorical trends to look like a real time trending.
Did I explain myself?
saludos
Re: charts or trending on access from oracle 9i
Sure, In the tutorial its has examples of how to connect. :thumb: