Deploying BLOB problem

williamIV

I am trying to deploy a pdf file to my SQL Server 2005 database.

The data config file is attached, wherein I set the type to blob and point to the file.

I ran a trace on the database and the query ends up looking like:

exec sp_prepexec @p1 output,N'@P0 int,@P1 ntext',N'INSERT INTO TBL_BINARYASSET(Pk_BinaryAssetId,BinaryAsset) VALUES (@P0,@P1)

where it says ntext instead of varbinary!

I am using the jdbc driver:

jdbc-driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
protocol-url = "jdbc:sqlserver"

Any ideas on how I can fix this?

Lal

hi,
I too have a similar req, could you please upload the dct and dataeploy.xml file here..so that i can also give a try on this,

Lal