vb4 RDO, intersolv odbc, and Sybase system 10 
Author Message
 vb4 RDO, intersolv odbc, and Sybase system 10

Hi I'm having trouble getting the input parameters working RDO in  the
following combination:

NT 3.51, vb4-32bit, Sybase System10 and Intersolv's odbc for NT 2.01

Here's the code:

Set Ps = gRDOCon.CreatePreparedStatement("GPICK", "{ ? = call
GetPickListByName (?,?,?,?) }")

Ps.rdoParameters(1).Direction = rdParamInput
Ps.rdoParameters(1) = PickListName

Ps.rdoParameters(2).Direction = rdParamInput
Ps.rdoParameters(2) = ListType

Ps.rdoParameters(3).Direction = rdParamInput
Ps.rdoParameters(3) = UserID

Ps.rdoParameters(4).Direction = rdParamInput
Ps.rdoParameters(4) = GroupID

Set rs = Ps.OpenResultset(rdOpenForwardOnly, rdConcurReadOnly)

Here's the error:

Run-time error 40044

incorrect type for assigning to rdoParameter.Value

This code works just fine when I change the data source to point at my
microsoft 6.0 sql-server and use ms 32bit odbc 2.5 driver.

The following  code does work with System 10 and intersolv's odbc
driver:

sSQL = "exec GetPickListByName '" & PickListName & "','" & ListType &
"'," & UserID & "," & GroupID
Set Ps = gRDOCon.CreatePreparedStatement("MYPS1", "")
Ps.SQL = sSQL

Set rs = Ps.OpenResultset(, rdConcurReadOnly)

It calls the same stored proc.

What's going on here?
I would like to be able to use the input and output parameters that
come with vb4 and RDO against Sybase system 10.

thanks,

ron keen
IDX systems corp.



Mon, 09 Mar 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. win95, vb4 pro 32bit, sybase 10, intersolv odbc, addchunk (image blobs)

2. Sybase system 10, ODBC, RDO, VB5

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

4. Sybase system 10 param queries w/ RDO

5. Sybase system 10 param queries w/ RDO

6. VB, ODBC, Sybase System 10, and Dynamic (real) SQL

7. VB 4.0 and the 32-bit ODBC for Sybase System 10

8. VB 4.0 and the 32-bit ODBC for Sybase System 10

9. VB4(16) & Sybase System 10 OpenRecordset problem

10. VB4/Sybase System 10

11. Sybase system 10 param queries

12. INSTCAT.SQL and Sybase System 10

 

 
Powered by phpBB® Forum Software