Wiki Home

VFP - Solomon Ole Error


Namespace: VFP
I am writing a VF application that communicates with MS Solomon. When passing Paramaters to Solomon Object(VB)an Ole error is returned.

(0x80020008) (-2147352568) Bad variable type

Cause: The datatype of a PL/SQL value passed as a method parameter did not match the Microsoft Visual Basic data type of the method parameter, or a NULL value was passed as a method parameter.

Action: Ensure that any local variables used as method parameters are of the appropriate datatype and are set to a value other than NULL.

MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vxgrflanguageequivalentstypes.asp states the following about VB strings:
String variables are stored as sequences of unsigned 16-bit (2-byte) numbers ranging in value from 0 through 65535. Each number represents a single Unicode character. A string can contain up to approximately 2 billion (2 ^ 31) Unicode characters.

I think that this may be my problem. Has anyone gotten the error, and do you know how I might get around it?

kstout@winest.com
If it's expecting a Unicode string, then STRCONV( cExp, 5) will do it for you. Failing that, post code that reproduces the problem.-- Steven Black
Category Open Questions
( Topic last updated: 2002.10.07 09:25:39 PM )