Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-10 : 09:22:13
|
| Scott writes "The following RDO 1.0 code (VB) works with SQL 6.5, but in 7.0 it returns an error (shown below) on the OpenResultset call. sql$ = "{? = call sp_procname (?)}" Set HWPs = rdoConn.CreatePreparedStatement("", sql$) HWPs.rdoParameters(0).Direction = rdParamReturnValue HWPs.rdoParameters(1).Direction = rdParamInput HWPs.rdoParameters(1).Value = glbAssocInfo.PayID Set HWRs = HWPs.OpenResultset(rdOpenStatic) Set rdcHW.Resultset = HWRsThe error is: 37000[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declaredSomehow, SQL 7 is confused and perhaps the rdOpenStatic parameter is confusing it. This is important to us as we are trying to migrate to SQL 7 and this is standing in the way. If you cannot answer it or it is more of a VB issue, it would be great if you could direct me to any resources you are aware of.Is there anybody who has used RDO 1.0 with SQL Server 7. There is not much out on MSDN or other resources.Thank you for any help you can provide,Scott" |
|
|
|
|
|
Problem using RDO 1.0 with SQL 7