Error message (ODBC)

[Sam Roach]

ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

I'm getting this error when trying to insert into a table that is linked
from Access to a DBF file.  From within Access I can insert data fine, but
from cold fusion I get the error.  Has anyone ran in to this before? 

It works as is on my local computer, I only get the error when I move the
files to another server.  I'm think it might have something to do with the
way CF sets up the ODBC, but I can seem to find anything deferent between my
local computer and the server.

Any advice or guesses welcome.

thanks,

-- Sam



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Error Message: ODBC Error Code = 55019

[James Taavon]

This is a multi-part message in MIME format.
--924745534C59F24D8DA17653
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have never seen this error before, can anybody tell me what it means?
Thanks in advance. NEWREQ is the name of a table. Below is the code it
is referring to.



insert into oimdbadm.newreq (time, date, agency, reqtype, requester,
req_email, phone, due_date, title, descrip, attachment, id, assigned)
values  ('#time#', '#date#', '#form.agency#', '#form.reqtype#',
'#form.requester#', '#form.req_email#', '#form.phone#',
'#form.due_date#', '#form.title#', '#form.descrip#',
'#form.attachment#', '#form.id#', '#form.assigned#')


---

ODBC Error Code = 55019 ()


[IBM][CLI Driver][AS] SQL7008N REXX variable "NEWREQ " contains
inconsistent data. SQLSTATE=55019 



The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (99:1) to (99:49).
--924745534C59F24D8DA17653
Content-Type: text/x-vcard; charset=us-ascii;
 name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
 filename="jtaavon.vcf"

begin:vcard 
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201;
fn:James Taavon
end:vcard

--924745534C59F24D8DA17653--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.