[[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]]


==== OI & SQL server data (OpenInsight Specific) ====
=== At 14 JAN 2002 04:03:41PM Raju Tamrakar wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
CAN YOU READ AND WRITE TO SQL server FROM AN OI data window (directly or ODBC) ? AND can LH data and SQL server data be Shared by one OI data window?

ANy info would be appreciated.



TIA



Raju Tamrakar
</QUOTE>
----

=== At 14 JAN 2002 05:28PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]  wrote:  ===

<QUOTE>Yes you can. In fact some of us Sprezzies are currently working at a client site who has an MFS to read/write to Oracle/SQL etc concurrently with OI tables.



You can either use the client/server workspace to set up a connection and a dataset, or you can use the various XOMethods (see on line docs). 



[url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] 

[i]World Leaders in all things RevSoft[/i] 

[img]http://www.sprezzatura.com/zz.gif[/img] 

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=2E5B49456B8669E288256B410073B1BF|View this thread on the  forum...]]