this is annoying

[oakpark5]

i keep getting the error:

Server: Msg 206, Level 16, State 2, Line 1
Operand type clash: image is incompatible with char

I dont have any images in either table so I dont understand why it is doing this. If anyone could possibly explain why this might be happening i would appreeciate it greatly.

Software Engineer
Team Lead
damn bill gates, he has everything

 

[SQLSister]

What are you doing when you get the error?

Questions about posting. See faq183-874

 

[oakpark5]

use kretekrdb
go
INSERT INTO customers
select * from openquery(K_AR,'select * from arcust01')

I'm writing from a FoxPro table to a SQL table..

Software Engineer
Team Lead
damn bill gates, he has everything

 

[SQLSister]

I would suggest that you specify the columns in your update and in the select that is being pulled from fox pro. Probably the columns are in a different order and one has the wrong data type for the column you are trying to insert it into. Select * is almost always dangerous to use in an insert.

Questions about posting. See faq183-874