Provider cannot derive parameter info error with Data Environment 
Author Message
 Provider cannot derive parameter info error with Data Environment

Hi!

I'm working with VB6 and Sybase ASE 11.9.2 using Sybase ASE OLE DB
Provider version 02.10.0000.
I've created a Command inside Data Environment with the next SQL
Statement:

INSERT INTO TableName (Field1, Field2, Field3, Field4, Field5)
VALUES (?, ?, ?, ?, ?)

I've also set the Parameter Properties (Name, Data Type, Size, etc.)
in the Command's Properties Tab.  But when I try to Run the Command I
receive this error:  "Provider cannot deriver parameter information
and SetParameterInfo has not been called."

If I create and execute the same Command for Microsoft Jet 4.0 OLE DB
Provider, it works fine.

Does anybody know how to avoid that error message?  
I would appreciate any help.  Thank you very much!



Wed, 03 Mar 2004 07:32:34 GMT  
 Provider cannot derive parameter info error with Data Environment
Based on my experience, this could be a by design feature of the Subase ASE
OLE DB Provider version 02.10.0000. The provider does not return the
parameters collection back to dataenvironment; hence you get the error.

I suggest you contact the manufacturer of Sybase and ask whether they have
other solution, for example, a higher version of the provider that supports
this function.

NOTE: I'm a Microsoft Employee, and I've been "encouraged" to include the
following information from our lawyers: this posting is provided "As Is"
with no warranties, and confers no rights. That means there is no warranty
of merchantability or fitness for a particular purpose, and no warranty of
non-infringement. See full details on terms of use.



Fri, 05 Mar 2004 10:33:12 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Provider cannot derive parameter info error with Data Environment

2. The provider cannot derive parameter info and SetParameterInfo has

3. Cannot set Data Environment Parameter prefix/suffix

4. Cannot set Data Environment Parameter prefix/suffix

5. Data error event hit err: Provider cannot be found

6. help Data environment parameter error

7. Provider cannot be found error (3706 Object error)

8. Provider cannot be found error (3706 Object error)

9. Showing parameters pass to data environment in data report header

10. Showing parameters pass to data environment in data report header

11. Editing data in a parameter query in Data Environment

12. Showing parameters pass to data environment in data report header

 

 
Powered by phpBB® Forum Software