Syntax error when INSERT statement executed automatically. (VBScript, ADODB, MSAccess )

Author Message
oomaster

  • Total Posts : 3
  • Scores: 0
  • Reward points : 0
  • Joined: 8/14/2007
  • Status: offline
Syntax error when INSERT statement executed automatically. (VBScript, ADODB, MSAccess ) Tuesday, August 14, 2007 2:42 PM (permalink)
0

Hi,

I have this interesting problem.

I'm trying to execute a simple INSERT statement into MSAccess via ADODB with VBScript. I do not understand why IIS is giving me a Syntax error.

When I get the script to print the generated statement and execute it manually into MSAccses, it works perfectly fine. I'm stuck here.

Hope anyone of you could be of great help.

Thanks!


 
#1

    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2012 ASPPlayground.NET Forum Version 3.9