Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Bcp problem

Author  Topic 

sop
Starting Member

1 Post

Posted - 2003-06-25 : 04:44:17
Hi friends. I have migrated SQL Server 6.5 data on SQL Server 2000 but I have a problem with a table with a text column. BCP utility seems to function but I have no access (with a PowerBuilder application) to documents in this column. Is it a bcp problem ? How can i do ?
SOP

X002548
Not Just a Number

15586 Posts

Posted - 2003-06-30 : 19:54:27
You're not giving us much to go on.

Is there data in the column?

Are you using dynamic SQL

Do you know about READTEXT, UPDATETEXT?

Do you know what a pointer value is?

What's the largest value in your column?

Can you use varchar(8000)?

How did you do your conversion from 6.5 to 2000?

What is the color of the sky at Night?

How many angels can dance on the head of a pin

Boy do I have to go home....

the smoke you are smelling is the short circuit upstairs...

Let us know..

Text columns are painful at best

Brett

8-)
Go to Top of Page
   

- Advertisement -