ADO Stored Procedure Add-IN


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO Stored Procedure Add-IN

  1. #1
    Silvana Giorgis Guest

    ADO Stored Procedure Add-IN


    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


    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: ADO Stored Procedure Add-IN


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


    Share on Google+

Similar Threads

  1. Replies: 4
    Last Post: 04-22-2001, 10:35 PM
  2. Replies: 0
    Last Post: 04-08-2001, 09:41 PM
  3. Replies: 0
    Last Post: 12-07-2000, 09:18 AM
  4. executing a stored procedure
    By Eric B in forum VB Classic
    Replies: 2
    Last Post: 10-09-2000, 11:51 AM
  5. Stored Procedure Parameter
    By John Hadzima in forum Database
    Replies: 2
    Last Post: 06-29-2000, 10:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center