ADO Stored Procedure Add-IN

[Silvana Giorgis]

I recently attended the VBITS Seminar in Chicago, and I attended your presentation
on how to use this particular
wizard. I downloaded it successfully, but I got an error when I was trying
to register the DLL(or re-crate the DLL on VB6 as prject).
I looked into the sytem requirements and I realized that I works with SQL
SERVER 7.0.
Do you know if this wizard will also work with ORACLE, since I am developing
with this data base??

The error message is as follows:

Compile Error:
The binary Compability DLL or EXE contains a parameter type or return type
whose definition
can not be found.

Public Connect As Connect <--- Where the error is

Thank you,

Silvana

[Bill Vaughn]

I've never tried the addin with Oracle, but it might work. Check out the source
code to see how it's constructing the list of SPs. As far as the error, I
suspect that you're getting a COM conflict somewhere. Change the source to
say
Private Connect as ADODB.Connect
That might fix it.

bv

"Silvana Giorgis" <sgiorgis@hotmail.com> wrote:
>
>I recently attended the VBITS Seminar in Chicago, and I attended your presentation
>on how to use this particular
>wizard. I downloaded it successfully, but I got an error when I was trying
>to register the DLL(or re-crate the DLL on VB6 as prject).
>I looked into the sytem requirements and I realized that I works with SQL
>SERVER 7.0.
> Do you know if this wizard will also work with ORACLE, since I am developing
>with this data base??
>
>The error message is as follows:
>
>Compile Error:
>The binary Compability DLL or EXE contains a parameter type or return type
>whose definition
>can not be found.
>
>Public Connect As Connect <--- Where the error is
>
>Thank you,
>
>Silvana
>
>