
SQL Server (ADO) Can't Insert Strings Longer Then 30 characters
I have one field in my table defined as varchar(50)
But when I do this:
adoCon.Execute "exec sp_mysp '1234567891234567891234567891234'
table is not updated unless I remove one charecter from parameter (31 -1)
Parameter in sp_mysp also defined as varchar(50)
and if I run this proc directly in SQL Enterprise Manager it works fine.
I am using provider for ODBC and it happens only on one particular server
(no problems on others)
It seems like ODBC driver on that server just refuses to pass string longer
then 30 char.
Please help, thank's