SQL Server equivalent of OLE Object

[yu217171]

Hi everyone,

What's the SQL Server equivalent of the OLE Object datatype in Microsoft Access? I tried Binary, VarBinary and Image. All three of those datatypes give me a type mismatch when I try to insert an image into SQL Server.

The insert works when I insert into a MS Access DB with the OLE Object datatype but fails (type mismatch) when I try inserting to SQL Server 2000.

Keith

 

[cmmrfrds]

There is also a text or ntext data type in sql server. How are you inserting the object - need more information.

 

[yu217171]

Hi cmmrfrds,

I got it to work. My program was returning a type mismatch but I later found out that it was a foreign key constraint violation.

Thanks again,

Keith