Problem using Sybase ASE driver from Delphi2007

[Per Bengtsson]

I am trying to use the Sybase ASE driver in Delphi 2007.
Previously, in Delphi 2005, we were using the driver from VISOCO Software.
But it is not supported for Delphi 2007.

If I try to pass an input string longer than one character to a
TSQLStoredProc, I get a "VendorError". If I pass a string with exactly one
character it works(!)
Passing integers as parameters works just fine.

I am trying it out directly from the IDE.

The installation of Sybase client software (12.5) on my computer should be
OK since everything worked just fine with the VISOCO Software driver in
Delphi 2005 on the same machine.
I have set the same connection attributes on my ASE TSQLConnection as I had
when using the VISOCO Software driver.

I have re-fetched the parameter list from the database but that doesn't help
(the parameter list is somewhat different from the one you get with the
VISOCO Software driver).

Something must be fundamentally wrong here... But what could it be?

/Per Bengtsson

[Per Bengtsson]

After a lot more trial & error I have basically given up on this...

Trying to use an ASEConnection for my TSQLConnection, I get three different
types of errors when calling a TSQLStoredProc:
- VendorError
- List index out of bounds
- The parameter xxx is of type UNKNOWN (regardless of the fact that I have
set the type)

Has anybody managed to use TSQLStoredProc with Sybase ASE from Delphi 2007??
If so, could you please instruct me on how to do it? It would be very
helpful.

- What parameters did you set on TSQLConnection?
- How did you configure the TStoredProc?
- Anything special to take into account when configuring the database
connection in the Sybase Client DSEDIT utility?
- Version of Windows/Sybase?

/Per Bengtsson