[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== SQL ODBC Driver (OpenInsight 32-bit Specific) ====
=== At 17 DEC 2003 12:25:57PM Ryan wrote: ===
{{tag>"OpenInsight 32-bit Specific"}}
We are looking into developing a website that will produce reports from the data that is in our OpenInsight db. The information that I have found so far on the SQL ODBC driver has been limited. Has anyone done this before? If so, can you point me in the right direction as to how to get started? Any help would be appreciated. Thanks.
----
=== At 17 DEC 2003 01:07PM Donald Bakke wrote: ===
Ryan,
Can you provide some more information/requirements on the nature of your web reporting? You might not need to use the ODBC driver. We have several web applications that report against OpenInsight data using the built-in OECGI.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 17 DEC 2003 11:18PM Steve Smith wrote: ===
What sort of web server are you intending to be on?
For a Windows web server there is the option of ASP pages (server side vbscript and a hook into open engine instance).
There's OECGI.
There is also the option of Perl or PHP.
There's S/Web (which is by far the best tool for this, IMHO)
You need to plan on whether there's any server interaction required, or if a read-only solution is valid. It will also depend on whether the usage will be low volume, or high volume (with many concurrent requests).
Steve
----
=== At 18 DEC 2003 03:47AM dsig@sigafoos.org wrote: ===
Ryan,
I use PHP with my web applications against OI data. There are some examples around or I can get you off some if you need
Also there is the JOI / java option which we are just starting to look at. Lot of discussion recently on the Works side of the forum
dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 971-570-2005
OS: Win2k sp2 (5.00.2195)
OI: 7.0
----
=== At 18 DEC 2003 03:49AM dsig@sigafoos.org wrote: ===
too fast on the button ..
OF Course IF you are looking for something that will be 'standard' across databases then SQL is your best bet.
dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 971-570-2005
OS: Win2k sp2 (5.00.2195)
OI: 7.0
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=97FFED1FFCC6A59C85256DFF005FC2C1|View this thread on the forum...]]