Solved

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

Posted on 2007-12-03
4
475 Views
Last Modified: 2012-05-05
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?
0
Comment
Question by:Webman04
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
Comment Utility
Hello Webman04,

U can use image /varbinary(max)


Aneesh R
0
 
LVL 23

Expert Comment

by:adathelad
Comment Utility
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
0
 

Author Comment

by:Webman04
Comment Utility
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
0
 

Author Comment

by:Webman04
Comment Utility
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?
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now