Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
Rick Towler wrote: > Has anyone made any database connectivity tools publicly available? I > know that Mike Wallace has done a lot of work with the IDL-Java bridge > and JDBC but I don't think he has released anything. I have worked with > the ADODB COM object and plan to experiment with it in IDL this > afternoon but ideally someone will have already done this :) An update: IDLcomIDispatch seems to still suffer from partialimplementationitus. Certain methods work and certain properties are accessible, but other properties and methods don't work and fail with unspecified errors. cstring='Provider=OraOLEDB.Oracle;Data Source=somedb;User ' + $ 'Id=user;Password=pass' db = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_Connection') db -> SetProperty, ConnectionString=cstring db -> Open db -> GetProperty, Provider=p, State=s print, p OraOLEDB.Oracle.1 print, s 1 So far so good. I was thinking I was home free... rs = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_RecordSet') sql = 'Select * from ship' rs -> Open, sql, db % IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::OPEN: Unable to call method OPEN. <unknown system error> Humm. Here's the interface definition: [id(0x000003fe), helpcontext(0x0012c8d7)] void Open( [in, optional] VARIANT Source, [in, optional] VARIANT ActiveConnection, [in, optional, defaultvalue(-1)] CursorTypeEnum CursorType, [in, optional, defaultvalue(-1)] LockTypeEnum LockType, [in, optional, defaultvalue(-1)] long Options); O.K. How about something simpler: rs -> GetProperty, Status=s % IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::GETPROPERTY: Unable to access property STATUS. <unknown system error> The interface definition: [id(0x00000405), propget, helpcontext(0x0012c949)] long Status(); Doesn't get much simpler than that. After writing a couple of wildly successful functions using COM+ADODB in MATLAB, I am left a bit underwhelmed with IDL's poor support for COM. I've been waiting for a working implementation of IDLcomIDispatch ever since it's release in 5.5. I must be the only one... :( -Rick
Rick Towler wrote: > Rick Towler wrote: >> Has anyone made any database connectivity tools publicly available? I >> know that Mike Wallace has done a lot of work with the IDL-Java bridge >> and JDBC but I don't think he has released anything. I have worked with >> the ADODB COM object and plan to experiment with it in IDL this >> afternoon but ideally someone will have already done this :) > > > An update: > > IDLcomIDispatch seems to still suffer from partialimplementationitus. > Certain methods work and certain properties are accessible, but other > properties and methods don't work and fail with unspecified errors. > > > cstring='Provider=OraOLEDB.Oracle;Data Source=somedb;User ' + $ > 'Id=user;Password=pass' > db = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_Connection') > db -> SetProperty, ConnectionString=cstring > db -> Open > db -> GetProperty, Provider=p, State=s > > print, p > OraOLEDB.Oracle.1 > print, s > 1 > > So far so good. I was thinking I was home free... > > rs = OBJ_NEW('IDLcomIDispatch$PROGID$ADODB_RecordSet') > sql = 'Select * from ship' > rs -> Open, sql, db > > % IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::OPEN: Unable to call method OPEN. > <unknown system error> > > Humm. Here's the interface definition: > > [id(0x000003fe), helpcontext(0x0012c8d7)] > void Open( > [in, optional] VARIANT Source, > [in, optional] VARIANT ActiveConnection, > [in, optional, defaultvalue(-1)] CursorTypeEnum CursorType, > [in, optional, defaultvalue(-1)] LockTypeEnum LockType, > [in, optional, defaultvalue(-1)] long Options); > > > O.K. How about something simpler: > > rs -> GetProperty, Status=s > > % IDLCOMIDISPATCH$PROGID$ADODB_RECORDSET::GETPROPERTY: Unable to access > property STATUS. > <unknown system error> > > The interface definition: > > [id(0x00000405), propget, helpcontext(0x0012c949)] > long Status(); > > > Doesn't get much simpler than that. > > > After writing a couple of wildly successful functions using COM+ADODB in > MATLAB, I am left a bit underwhelmed with IDL's poor support for COM. > I've been waiting for a working implementation of IDLcomIDispatch ever > since it's release in 5.5. I must be the only one... :( > > -Rick Hi Rick, Is the ADODB a .exe, .dll or .ocx component? My guess is it's an Application Object stored in a .exe. If so, I have a solution for you (that will be included in the 6.4 distribution). GIve me a call and I'll tell you more - 303-402-4679. Thanks, -Paul
Rick Towler wrote: > Has anyone made any database connectivity tools publicly available? I > know that Mike Wallace has done a lot of work with the IDL-Java bridge > and JDBC but I don't think he has released anything. I have worked with > the ADODB COM object and plan to experiment with it in IDL this > afternoon but ideally someone will have already done this :) Yes, I have played around with it quite a bit, but unfortunately I'm in a situation where it's difficult for me to release code (too much red tape and hassle). As far as COM goes, you're on your own. I've only worked with the Java side. -Mike
Hello, I will be releasing such a tool at the ADASS conference (http://www.adass.org/) next month. Here is the abstract that I have submitted for a poster: "We have developped a Java middleware to access relational databases from IDL (Interactive Data Language by RSI, now ITT). Our middleware combines the new Java-Bridge feature available in IDL from version 6.0 with the proven JDBC interface, drivers for which are available for all relational databases from PostgreSQL and MySQL to Oracle and Sybase etc. DataJiver simplifies access to these databases by providing the developers with IDLs object that can dynamically map to the result set from SQL statements, thus facilitating the developments of business objects capable of hibernation." In the meantime if you are interested to test the package, please drop me an email. --- Renaud Savalle <rs.usenet@gmail.com> Research Engineer, CNRS, France Mike Wallace wrote: > Rick Towler wrote: >> Has anyone made any database connectivity tools publicly available? I >> know that Mike Wallace has done a lot of work with the IDL-Java bridge >> and JDBC but I don't think he has released anything. I have worked with >> the ADODB COM object and plan to experiment with it in IDL this >> afternoon but ideally someone will have already done this :) > > > Yes, I have played around with it quite a bit, but unfortunately I'm in > a situation where it's difficult for me to release code (too much red > tape and hassle). As far as COM goes, you're on your own. I've only > worked with the Java side. > > -Mike