|
lu lu -> ODBC Drivers error '8007000e' (3/31/2005 16:28:34)
|
Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
[Microsoft][ODBC Microsoft Access Driver] Too many fields defined.
I'm trying to update (mdb 2003 via asp) 184 fields in the table and i got this message:
Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
[Microsoft][ODBC Microsoft Access Driver] Too many fields defined.
this is the response.write sql:
(i purposly have the sql statement fit the window w/o hor. scrolling - otherwise its all on 1 line)
UPDATE users SET today_month='12', today_day='12', today_year='12',
reference_code='12', fname='12', init='1', lname='12', dob_month='12', dob_day='12',
dob_year='12', blood_type='12', medical1='12', medical2='12', medical3='12', medical4='12',
medical5='12', med1='12', med1_dos='12', med1_freq='12', med2='12', med2_dos='12',
med2_freq='12', med3='12', med3_dos='12', med3_freq='12', med4='12', med4_dos='12',
med4_freq='12', med5='12', med5_dos='12', med5_freq='12', allergy1='12', allergy2='12',
allergy3='12', allergy4='12', implants1='12', implants2='12', health_insur='12',
health_insur_area='12', health_insur_tel='12', group_no='12', id_no='12', emer_con='12',
emer_con_area='12', emer_con_tel='12', address='12', city='12', state='12', zip='12',
area='12', phone='12', ss='12', email='12', contacts='Yes', dentures='Yes', physician='12',
physician_area='12', physician_phone='12', specialist='12', specialty='12',
specialist_area='12', specialist_phone='12', specialist2='12', specialty2='12',
specialist_area2='12', specialist_phone2='12', heart_disease='Yes', diabetes='Yes',
kidney='Yes', smoke='Yes', disability='Yes', condition='12', aids='Yes', ekg='Yes', doctor='12',
doc_area='12', doc_phone='12', a1='Yes', a2='Yes', a3='Yes', a4='Yes', a5='Yes', a6='Yes',
a7='Yes', a8='Yes', a9='Yes', a10='Yes', a11='Yes', a12='Yes', a13='Yes', a14='Yes',
a15='Yes', a16='Yes', a17='Yes', a18='Yes', a19='Yes', a20='Yes', b1='Yes', b2='Yes',
b3='Yes', b4='Yes', b5='Yes', b6='Yes', b7='Yes', b8='Yes', b9='Yes', b10='Yes', b11='Yes',
b12='Yes', b13='Yes', b14='Yes', b15='Yes', b16='Yes', b17='Yes', b18='Yes', b19='Yes',
c1='Yes', c2='Yes', c3='Yes', c4='Yes', c5='Yes', c6='Yes', c7='Yes', c8='Yes', c9='Yes',
c10='Yes', c11='Yes', c12='Yes' WHERE ((userName = 'test') AND (passWord = 'test'))
Now this is not all 184 fields to be updated, but this is the part where it breaks. If i get rid of
where c12='Yes' in the sql, then it updates, but as soon as i try to add another field to the sql statement, this error appears. Is there a setting in the mdb itself to allow for max updating of table columns? Any ideas? would i have teh same issue with a sql db?
thanks
PS / i'm connecting to the db like so (not sure it it matters/or is a problem using the driver that i am:
set cvvDB = Server.CreateObject("ADODB.Connection")
cvvDB.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\db_path\db.mdb"
sql88 = "update statement"
Set rs88 = cvvDB.Execute(sql88)
|
|
|
|
