PB2019R3 BUILD 2728
Getting a couple of sql server errors using 64 bit PB and ODBC. 32bit PB no problems. I didn't get this with PB 2017R3 64 bit.
The first one is caused by running a datawindow with a string argument:
Select Error: SQLSTATE = 22005 [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
WHERE tab_cd = :reportcode
getting rid of the argment in the sql 'fixes' the problem:
WHERE tab_cd = 'BALSH'
the 2nd error:
Select Error: SQLSTATE = S1C00
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
have not tracked this one down yet.
these are set in my connection string. this is regular sql (not stored procedure, stored procedures work fine)
CallEscape='No'
StripParmNames='Yes'
anyone have any ideas?
When we started to use the 19c client, I've seen some weird errors (that didn't 'always' happen. Me too I discoverd that setting Disablebind=1 solves all of these problems. Something seems off.
regards