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. Locking server using SELECT INTO in sp

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

4. creating a cube using an already design Star Schema

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

6. simple question regarding the building of psql

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

8. How to get number of records in a SetRange ?

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