Forum Moderators: open

Message Too Old, No Replies

problem with my access database

problem with my access database

         

KamalR

8:37 am on Aug 28, 2008 (gmt 0)

10+ Year Member



Hi guys&girls,

I have the following problem i can't figure out.

My website (ASP) lets people (after they logon) change there own information.

when they change something en want to save it the get the following error message.
_________________________________
insert into UpdBestuur (v1, v2, v3, v4, v5, v6, v7, v8, v9, v10, v11, v12, Updated,Done) values ('500011','50143','Stichting Koraal Groep, Saltho Onderwijs','Postbus 395','5280 AJ','BOXTEL','0411-616050','0411-689713','info@something.nl','Nieuwsbrief Bond KBO','www.something.nl','0','1219881600','N')

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

[Microsoft][ODBC Microsoft Access Driver] ODBC--call failed.

/kbo/BestuurUpd.asp, line 54
__________________________________

It saves the changes in a Access (2000) database with linked tables to a sql2005 database.

recently we changed MS SQL2000 to MS SQL2005.

I have searched the internet for information. but can find anything to point me in the right direction.

I hope someone can help me out.

Many thanks for your time.

Kamal

If more information is needed let me know.

Webserver= Win2003R2, IIS6.0, MS Access 2003, Jet4.0 is update.
SQLserver= Win2003R2, SQL2005

[edited by: KamalR at 8:40 am (utc) on Aug. 28, 2008]

mattur

2:47 pm on Aug 28, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Have you checked your SQL query works when run locally through Access or SQL Server Query Analyser?

I'd also suggest eliminating Access in the chain - there's no need to go:

ASP -> OLEDB/ODBC -> Access -> ODBC -> SQL Server

when you can just go direct to SQL Server:

ASP -> OLEDB -> SQL Server

HTH.