Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


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

 
Logged in as: Guest
arrSession:exec spGetSession 2,3,50738
 Active Users: There are 0 members and 0 guests.
 Users viewing this topic: none
 

 

 
  
  Printable Version
All Forums >> [Scripting] >> ASP >> Syntax error when INSERT statement executed automatically. (VBScript, ADODB, MSAccess )
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Page: [1]
Login
Message << Older Topic   Newer Topic >>
 Syntax error when INSERT statement executed automatical... - 8/14/2007 1:42:40 PM   
  oomaster

 

Posts: 3
Score: 0
Joined: 8/14/2007
Status: offline
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!
 
 
Post #: 1
 
 
 
  

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> ASP >> Syntax error when INSERT statement executed automatically. (VBScript, ADODB, MSAccess ) Page: [1]
Jump to:





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
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts