SQL Server (ADO) Can't Insert Strings Longer Then 30 characters 
Author Message
 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



Sat, 11 Aug 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ADO SQL Server update of long strings

2. Insert Data Into Access Database From SQL Server ADO Insert

3. Inserting a long string into a sql text field

4. Inserting a long string into a sql text field

5. Printing character 29-30...?

6. SQL String of 922-926 characters fails using ADO and ODBC

7. Embedded NULL Character in a string -SQL Server

8. Display unprintable character (ASCII values 30 and 31)

9. Cannot get Chinese Characters from SQL server with ADO

10. RDC with dbgrid and SQL Server - can't insert first row

11. retrieve primary key after insert statement (using ADO / SQL Server 2000)

12. Inserting data from an ADO recordset into a SQL Server table

 

 
Powered by phpBB® Forum Software