1
Vote

Operand type clash: image is incompatible with geography

description

Hi
 
I have SQL 2008 Express R2 SP1 using SQLAzureMW v3.8.2.
 
When running the migration the code is generated fine, but when I execute the script against the SQL Azure server I get the error:
 
SQLState = 22005, NativeError = 206
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: image is incompatible with geography
BCP copy in failed
 
I have checked my DB is in Compatibility_Level 100, I have also checked the generated code shows the field as Geography not Image.
 
Anyone else had this problem and know a work around?
 
Many thanks
 
James

comments

ghuey wrote Apr 13, 2012 at 2:52 PM

Hi James,

Would it be possible for you to send me the create table statement (generated by SSMS)? I want to see if I can reproduce this issue and fix the problem. You can send it directly to me ghuey@microsoft.com.

Thanks,
George

JamesEinTech wrote Apr 17, 2012 at 2:27 PM

OK turns out my server had two copies of BCP, one version 8 (which SQLAzureMW was using) and one version 10.50.2500.

So I edited the config file of SQLAzureMW to use the newer version (found in C:\Program Files\Microsoft SQL Server\100\Tools\Binn).

This sorted the issue.

Many thanks George for your help!