MS SQLServer dblib problems reading text fields 
Author Message
 MS SQLServer dblib problems reading text fields
I have a problem reading large text fields from a Microsoft SQL server
through the C Library interface. It seems that the library will not read
more than 4Kb at a time using the dbreadtext() function. The dbsetopts()
function with option=DBTEXTSIZE and param=5Kb does not seem to make any
difference. We have the textsize option in TransactSQL set to 10Kb.
We have been able to save text blocks larger than 4Kb, but retrieving is
not working at all.

Please help!




Sat, 30 Dec 1995 03:54:27 GMT
 MS SQLServer dblib problems reading text fields


Quote:
>I have a problem reading large text fields from a Microsoft SQL server
>through the C Library interface. It seems that the library will not read
>more than 4Kb at a time using the dbreadtext() function. The dbsetopts()
>function with option=DBTEXTSIZE and param=5Kb does not seem to make any
>difference. We have the textsize option in TransactSQL set to 10Kb.
>We have been able to save text blocks larger than 4Kb, but retrieving is
>not working at all.

Your problem is most likely not DBTEXTSIZE but DBTEXTLIMIT, MS manual fails
to mention that the default value for DBTEXTLIMIT for DOS and Windows (and
presumably OS/2 as well) is 4KB (for all other Sybase platforms I am aware
of the default for DBTEXTLIMIT is 0, ie. unlimited).

Quote:

>Please help!



Regards
David Shanahan.


Sun, 31 Dec 1995 10:03:25 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. upgrade problems to ms-sqlserver 7.0 to ms-sqlserver 2000

2. Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

3. Using MS Access to read text from an Informix BLOB field

4. MS SQLserver 7.0 Create Full-text search Catalog problem

5. MS SQLserver 7.0 Create Full-text search Catalog problem

6. MS SQLserver 7.0 Create Full-text search Catalog problem

7. MS SQLserver 7.0 Create Full-text search Catalog problem

8. Problem with updating from TEXT field into TEXT field

9. SQL Query problem concat text field from mulitple rows into one text field

10. How to read text file into a text field

11. Upgrade ms sqlserver 7.0 to sqlserver 2000 problems

12. Reading text files in sqlserver stored procedures


 
Powered by phpBB® Forum Software