asked on

Field Type for images in SQL using ASP Upload program and Insert with Dreamweaver CS3

Hi, what type of Data Type do I use for an image in SQL Server 2005 if I am uploading it to the database with Pure ASP upload?

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

adathelad

Just to add that in SQL 2005, it's preferred to use VARBINARY(MAX) over IMAGE
as per:
http://msdn2.microsoft.com/en-us/library/ms178158.aspx
http://www.teratrax.com/articles/varchar_max.html

Webman04

ASKER

Hi, when I add the insert record server behavior it gives me the following options for a text or numeric. What do I use? I am currently using the Varbinary in the SQL database image data type and text for the insert record behavior but I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: text is incompatible with varbinary

/sqlinserttest.asp, line 59

Webman04

ASKER

Hi, maybe I'm not being clear enough. All I am trying to do it make a dreamweaver insert record form wiht a filefield for an image, upload the image and store the location in a MS SQL database so I can then place it on pages and use it where I want. I am using Pure ASP upload from DMXzone.com Dreamweaver CS3, ASP and MS SQL 2000. I tried doing this the same why I aways do with an Access database but my normal method won't work on a SQL database so can anyone help me with this? I would think this is a very basic thing for anyone that uses SQL Server on a regular basis?