Results 1 to 11 of 11

Thread: incorrect syntax near '-'.

  1. Jul 12th, 2007, 03:38 AM #1
    jonathan_giuliano
    jonathan_giuliano is offline

    Thread Starter
    Member
    Join Date
    Jul 2007
    Posts
    41

    Unhappy incorrect syntax near '-'.

    Help me guys, my application I just wrote, shows an error message when it's run. It says


    Run-time Error '-2147217900(80040e14)'

    Line1: Incorrect syntax near '-'.


    I traced it, but I didn't find the character (I didn't write the character '-'). I ran my app on different computers, there's no problem with my app. I reformatted my computer and reinstalled all the programs, it didn't work. It still had that error...
    Can someone tell me what's wrong with my application (or computer)??

    Note: I'm using VB6 for the interface and SQLServer 2000 for the database.
    Reply With Quote Reply With Quote
  2. Jul 12th, 2007, 03:43 AM #2
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: incorrect syntax near '-'.

    Did you just copy the exe to the other computer? Installer Problems
    Last edited by randem; Aug 7th, 2007 at 11:53 PM.
    Reply With Quote Reply With Quote
  3. Aug 7th, 2007, 10:46 PM #3
    jonathan_giuliano
    jonathan_giuliano is offline

    Thread Starter
    Member
    Join Date
    Jul 2007
    Posts
    41

    Unhappy Re: incorrect syntax near '-'.

    yeah i copied the exe.
    i also ran the project on different computers, it's still the same..the error is still there
    Reply With Quote Reply With Quote
  4. Aug 7th, 2007, 11:42 PM #4
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: incorrect syntax near '-'.

    Of course it is. Di you read the link I posted to an article about that????

    You definitely have an SQL error...
    Reply With Quote Reply With Quote
  6. Aug 7th, 2007, 11:47 PM #5
    Paul M
    Paul M is offline
    Interweb adm/o/distrator Paul M's Avatar
    Join Date
    Nov 2006
    Location
    Australia, Melbourne
    Posts
    2,306

    Re: incorrect syntax near '-'.

    There appears to be a 404 on the link randem.
    Reply With Quote Reply With Quote
  7. Aug 7th, 2007, 11:53 PM #6
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: incorrect syntax near '-'.

    OK, fixed now... Thanks
    Reply With Quote Reply With Quote
  8. May 22nd, 2008, 01:30 AM #7
    jonathan_giuliano
    jonathan_giuliano is offline

    Thread Starter
    Member
    Join Date
    Jul 2007
    Posts
    41

    Re: incorrect syntax near '-'.

    Quote Originally Posted by randem
    Did you just copy the exe to the other computer? Installer Problems
    Where can I get the universal VBVM?? could you give me the link?

    Of course it is. Di you read the link I posted to an article about that????

    You definitely have an SQL error...

    But i also ran the vb project from diferrent computers using the same version of vb compiler and the same sql server version. in some computers show the same errror msg but some others don't

    so what now?
    Last edited by jonathan_giuliano; May 22nd, 2008 at 01:37 AM.
    Reply With Quote Reply With Quote
  9. May 22nd, 2008, 02:11 AM #8
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: incorrect syntax near '-'.

    If you do not package the dependancy files then you will get errors like you are getting. Not all computers will have all the supporting files needed.

    Thread Moved
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  11. May 22nd, 2008, 04:24 AM #9
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: incorrect syntax near '-'.

    Quote Originally Posted by jonathan_giuliano
    Where can I get the universal VBVM?? could you give me the link?
    The link was in the document that was linked...

    Quote Originally Posted by jonathan_giuliano
    so what now?
    READ!!!
    Reply With Quote Reply With Quote
  12. May 26th, 2008, 02:47 AM #10
    jonathan_giuliano
    jonathan_giuliano is offline

    Thread Starter
    Member
    Join Date
    Jul 2007
    Posts
    41

    Re: incorrect syntax near '-'.

    Quote Originally Posted by randem
    The link was in the document that was linked...

    READ!!!
    I didn't find the link to VBVM, what's the link text, again??:
    Reply With Quote Reply With Quote
  13. May 26th, 2008, 04:53 AM #11
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: incorrect syntax near '-'.

    There is no such thing as Visual Basic Virtual Machine if that is what you mean by VBVM.

    You were supposed to read about installation problems. That is what you have...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width