ODBC and stored procedures (OpenInsight 32-bit Specific)
At 18 SEP 2003 11:50:33PM Bob Watson wrote:
I know you can execute am SQL query using the ODBC driver, but can you execute, for example in VB, an OI stored procedure and return a recordset?
Bob Watson
At 19 SEP 2003 03:04AM Donald Bakke wrote:
Bob,
I know you can execute am SQL query using the ODBC driver, but can you execute, for example in VB, an OI stored procedure and return a recordset?
ODBC is not my expertise but I'm pretty sure the answer is no. By it's nature it is purely a database query technology.
However, if you are using VB then you can use other means for talking to OEngine and even call stored procedures. Perhaps the easiest approach would be to use the XREV.DLL COM object. I believe there are already some posts about how this can be done.
dbakke@srpcs.com
At 19 SEP 2003 03:14AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
All depends what you mean by a recordset Bob…
I imagine, much like the ODBC driver, that an ADO recordset is accessed via a defined API and returns data rows and meta information in a specified format, rather than just returning a big delimited string. If so this represents quite a lot of work :)
Of course, returning raw data is certainly possible and much easier these days using components like XRev.DLL or RevCAPI.DLL, and such methods have been discussed on this site elsewhere.
World leaders in all things RevSoft
At 19 SEP 2003 04:13AM dsig@sigafoos.org wrote:
The XREV.Dll and some code on OI end seems to work pretty well
This link SQl from Rbasic talks about use from rbasic ..
If you have any problems .. feel free to contact me .. PHP to OI through this *appears* to work pretty well ..
dsig@sigafoos.org
At 19 SEP 2003 07:10AM Bob Watson wrote:
Thank you for replies gentlemen - xrev.dll it is - as you say there are plenty of examples on this site.
Bob Watson