| Re: database access using JAVA or COM [message #49765 is a reply to message #49758] |
Tue, 15 August 2006 06:33   |
![Paul[2] is currently offline](theme/default/images/xoffline.png.pagespeed.ic.XRkd1fkXye.png "Paul[2] is currently offline")
Paul[2]
Messages: 13
Registered: January 2006
|
Junior Member |
|
|
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
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
