Microsoft OLE DB Provider for ODBC Drivers error '

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Microsoft OLE DB Provider for ODBC Drivers error '

Author

Topic

pwint
Starting Member

7 Posts

Posted - 2005-04-07 : 00:38:11

Hi

I try to update the following syntax and i got the error of '80040e14'. How can i correct this,please? Thanks.

SQlstmt = "Update tmp_allmem " & _
" set title = '" & cTitle & "', firstname = '" & FName & "', lastname ='" & LName & "',headname='" & cHeadName & "', " & _
" designation ='" & cDesignation & "',sectionname='" & cSection & "',AITgrad='" & cAITgrad & "',sex='" & cSex & "', " & _
" Orgtype='" & cOrgType & "', Orgtypeothers='" & cOrgTypeOthers & "',office='" & cOffice & "',contactdetail='" & cContactDetail & "', " & _
" address1='" & cAddress1 & "',address2='" & cAddress2 & "',address3='" & cAddress3 & "',city1='" & cCity1 & "',city2='" & cCity2 & "', " & _
" Contact1='" & cContact1 & "',Contact2='" & cContact2 & "',Contact3='" & cContact3 & "', " & _
" city3='" & cCity3 & "',country1='" & cCountry1 & "',country2='" & cCountry2 & "',country3='" & cCountry3 & "',zip1='" & nPostalcode1 & "', " & _
" zip2='" & nPostalcode2 & "',zip3='" & nPostalcode3 & "',telephone1='" & nPhone1 & "',telephone2='" & nPhone2 & "',telephone3='" & nPhone3 & "', " & _
" fax1='" & nFax1 & "',fax2='" & nFax2 & "',fax3='" & nFax3 & "',email1='" & Email1 & "',email2='" & Email2 & "',email3='" & Email3 & "', " & _
" website='" & cWebsite & "',ap='" & cNetworkType1 & "',swm='" & cNetworkType2 & "',ws='" & cNetworkType3 & "',memtype='" & cMembership & "', " & _
" username='" & cUsername & "',password12='" & cPassword & "',secquestion='" & cSecurityQues & "',secanswer='" & cSecurityRes & "'," & _
" M1= '" & sM1 & "', T1= '" & sT1 & "', T2= '" & sT2 & "', T3= '" & sT3 & "', NW= '" & sNW & "', P1= '" & sP1 & "', D1= '" & sD1 & "', " & _
" ResourcePerson = '" & sResourcePerson & "', ProjectName= '" & sProjectName & "',SpeakerTopic = '" & sSpeakerTopic & "', TopicsSubject='" & sTopics & "', " & _
" Approve= " & sApprove & " where Username = " & cUser & ""

*************************************************************

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'aaaorg'.

/snpnetwork/RegupdatesqlM.asp, line 109

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-04-07 : 01:09:42

Your query does not have aaaorg. Post full query

Madhivanan

Failing to plan is Planning to fail

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-04-07 : 01:32:55

just an advice, create the sp for this, it's more readable, easier to troubleshoot, will probably be faster and your server more secured from sql injections

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources