June 25, 2003 at 3:07 am
Hi. I have migrated a SQL Server 6.5 to SQL Server 2000 but I have a problem with a text column in a table; my application written in PowerBuilder gives me an error during retrieve of text column in the new database (SQL Server 2000). IS it a bcp problem ? How can i do to transfer correctly values of this column ?
sop
June 25, 2003 at 4:12 am
Not that I know a lot about Powerbuilder, but what is the error you are getting?
June 25, 2003 at 4:26 am
I don'to know...but word documents saved in this column can not be opened; the error is "format not valid"; if i create a new doc (in word) and save it in the column (SQL 2000) there is no problem. The problem is only with imported rows with bcp in.
June 25, 2003 at 11:20 am
Do you have the original DB or a backup somewhere? If so try installing to another server and do an import using the IMPORT/EXPORT wizard. Sounds like something in your BCP broke the data incorrectly.
June 26, 2003 at 4:24 am
But the IMPORT/EXPORT wizard is on SQL 2000 ? there is not a IMPORT/EXPORT wizard in SQL 6.5, is it true ?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply