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!

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.

I have used same thing for Oracle using Microsoft OLEDB Provider and got the
same error, while using Jet 4.0 OLEDB Provider with Access 2000 Database
works fine.

Best Regards,

Luqman