Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data greater than 256 chars truncated

Status
Not open for further replies.
NCB

NCB

Programmer
Nov 27, 2001
7
US
I am using PB6.5 and SQL Server 2K SP2. When retrieving from a column with data greater than 256 chars, the data is truncated. It only returns the first 256 char. I am connecting using the PB SQL Server native driver. When I use ODBC, it is not a problem, but using ODBC is not an option. Is there a new native driver to connect to SQL Server 2K?
 
Sort by date Sort by votes
It's my understanding that in SQL2k if you use the native drivers you cannot use any of the advanced features which have been added since SQL6.5. This means a limit of 255.

[sadeyes]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

responderpb
  • Locked
  • Question
how send data post
Replies
0
Views
73
responderpb
responderpb
GUILLY
  • Locked
  • Question
datawindow
Replies
4
Views
238
GUILLY
GUILLY
zulmach
  • Locked
  • Helpful tip
Tile menu style using datawindow object
Replies
0
Views
125
zulmach
zulmach
tongw
  • Locked
  • Question
how to extract data combine with the parent datawindow and child datawindow?
Replies
2
Views
117
pbgonzo
pbgonzo
RubensLott
  • Locked
  • Question
Search a word in a line result of a filtered field from a DataWindow
Replies
1
Views
103
RubensLott
RubensLott

Part and Inventory Search

Sponsor

Back
Top