Operand type clash: image is incompatible with geography


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


ghuey wrote Apr 13, 2012 at 3: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.


JamesEinTech wrote Apr 17, 2012 at 3: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!

wrote Feb 22, 2013 at 12:59 AM