Solved

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

Posted on 2007-12-03
4
502 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
ID: 20401025
Hello Webman04,

U can use image /varbinary(max)


Aneesh R
0
 
LVL 23

Expert Comment

by:adathelad
ID: 20401712
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
ID: 20403502
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
ID: 20415475
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

770 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