VB5.0, RDO and Sybase 11

VB5.0, RDO and Sybase 11

Post by Ryan L McFa » Fri, 01 Aug 1997 04:00:00



Hi:

I am attempting to use RDO to access a Sybase XI server from within a VB5.0
application.

I'm trying to call stored procedures, and so matter what I try, I always
get an error message (sorry, not sitting at that computer right now) when I
try to set the direction (rdcParamInput, rdcParamOutput, etc.) for the
parameters.  If I don't set the direction and just set the values, I get
the error message for the values:

I'm doing something like:
  SQL$ = "{ ? = call sp_password (?, ?) "
  Set MyQuery = conn.createQuery ("PWQuery", SQL$)

  MyQuery.rdoParameters(0).Direction = rdcParamReturnValue
  ...

And the error message I get basically tells me that rdoParameters(0) is not a
valid object.

Is this because the Sybase server doesn't support this?  If I do normal
select statements, my code runs fine.

Any help would be appreciated.  If you can, please send me an email as well
as posting a follow-up.

Thanks,
Ryan

--
/**************************************************************
 *  Ryan McFall                                               *
 *  Dept. of Computer Science                                 *
 *  Michigan State University                                 *

 *************************************************************/

 
 
 

VB5.0, RDO and Sybase 11

Post by Ko Lam N » Sat, 02 Aug 1997 04:00:00


We had the same problem using VB 4.0.  Sybase sent us a fix and this
problem was fixed.  We're getting other problems (see posting on error
-40044) which I'm not sure may be related but we're tackling that one
separately.  What is important though is that we got VB to retrieve/update
data from Sybase 11 via stored procedure.

Here is the fix they sent us.  It is a system stored procedure which must
be compiled in your master db.

begin 600 RDOFix.zip
<encoded_portion_removed>
end

 
 
 

1. VB5.0, RDO and Sybase 11

Hi:

I am attempting to use RDO to access a Sybase XI server from within a VB5.0
application.

I'm trying to call stored procedures, and so matter what I try, I always
get an error message (sorry, not sitting at that computer right now) when I
try to set the direction (rdcParamInput, rdcParamOutput, etc.) for the
parameters.  If I don't set the direction and just set the values, I get
the error message for the values:

I'm doing something like:
  SQL$ = "{ ? = call sp_password (?, ?) "
  Set MyQuery = conn.createQuery ("PWQuery", SQL$)

  MyQuery.rdoParameters(0).Direction = rdcParamReturnValue
  ...

And the error message I get basically tells me that rdoParameters(0) is not a
valid object.

Is this because the Sybase server doesn't support this?  If I do normal
select statements, my code runs fine.

Any help would be appreciated.  If you can, please send me an email as well
as posting a follow-up.

Thanks,
Ryan

--
/**************************************************************
 *  Ryan McFall                                               *
 *  Dept. of Computer Science                                 *
 *  Michigan State University                                 *

 *************************************************************/

2. Using BLOBs

3. VB 4.0/5.0 RDO and Sybase SQL Server System 11/Intersolv ODBC 3.0

4. Limit INSERT

5. migrate Sybase 11.0.1 and Sybase 11.5.1 to MS sql 6.5/7.0

6. Stored Procedure Templates

7. Upgrade from Sybase SQL Server 11.0.1 to Sybase ASE 11.9.2

8. Help me with my .idc access problem that is intranet related

9. VB5 to Sybase 11.0.2?

10. VB5 and Sybase System 11

11. ODBC Error X Image data type X VB5.0 ODBCDirect X Sybase System 11

12. VB5 and Sybase System 11 (ODBC)

13. ODBC Error X Image data type X VB5.0 ODBCDirect X Sybase System 11