Classic ASP Discussion - SQL Server error ’80040e14’

Print Page | Close Window

SQL Server error ’80040e14’

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=16281
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server error ’80040e14’

Posted By: ub3rl337ch3ch
Subject: SQL Server error ’80040e14’
Date Posted: 21 August 2005 at 11:43pm

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'INNER'.

This error spits at me when i try to execute the following sql using adoCon.execute sql

sql = "UPDATE BRSched INNER JOIN (Invoice INNER JOIN BrProp ON Invoice.Propno = BrProp.PropNo) ON (BRSched.Propno = BrProp.fmPropNo) AND (BRSched.Version = BrProp.schedno) SET BRSched.Invno = invoice.invno WHERE (((BRSched.Invno)=0) AND ((BrProp.PropNo)='417') AND ((Invoice.PropType)='Broadacre')) "

The sql works in access with no issues, but completely refuses to run in my asp app. Any ideas?

btw: the access db i'm running it in is a front-end for the same mssql back-end as i'm using in my app.

Replies:

Posted By: wingking
Date Posted: 26 August 2005 at 3:15pm

well I am far from an SQL wiz but I get by on own. so I may be mistaken but I don't believe inner joins are valid in sql. access is so gone in my past I barely recall working with it.

however you can accomplish a join by doing where...

update * where tbl.field = tbl.field

I hope that helps.