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.