Textcopy - image data types

[Vivianez]

I´m using the command line "textcopy" to store images in a table. But the textcopy returns:
Text or image pointer and timestamp retrieval failed.

What is wrong?

 

[NoCoolHandle]

wanna share the syntax?

My crysal ball is on the blink

Rob

 

[Vivianez]

I created a table named teste in Northwind database.
id Char(10)
photo image

textcopy /S sqlserver /U nome /P pass /D northwind /T teste /C photo /W where id = '1' /F c:\file.bmp \I \Z

It returns:
Error:Text or image pointer and timestamp retrieval failed.

 

[NoCoolHandle]

My belief is it is the spaces afetr the swithches that is killing you.
I think you also need quotes around the where and the file swithes..



the command should look more like

textcopy /Ssqlserver /Unome /Ppass /Dnorthwind /Tteste /Cphoto /W"where id = '1'" /F"c:\file.bmp" \I \Z

Good Luck

Rob

 

[Vivianez]

I've tried without the spaces and the same message...
Another clue?

 

[Vivianez]

Solution found....
You should insert something into text/image column before copy text/image into it. I mean, this value should not be null. You should write (for example):

INSERT INTO [dbo].[images] VALUES ('1', 0x0, null)

instead of:

INSERT INTO [dbo].[images] VALUES ('1', null, null)

Otherwise, you will get the following error message:

ERROR: Text or image pointer and timestamp retrieval failed.