[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

Trying to identify if error is coming from VB6 or SQL

This is inherited code which I am trying to debug. I encounter the error seen in the screen shot. As a starter could someone tell me if the error format looks like it's coming from VB6 or SQL. My guess is SQL but I'd like to verify.
Have you ever encountered this error?
2799-error.JPG
0
tesla764
Asked:
tesla764
3 Solutions
 
Paul JacksonSoftware EngineerCommented:
Definitely a SQL Syntax error in the sql query being used.
0
 
David ToddSenior DBACommented:
Hi,

Can you post the query?

Regards
  David
0
 
Carl TawnSystems and Integration DeveloperCommented:
The error is from the SQL parser, and will have been thrown by the SQL Server. However, the code that gets sent to the SQL server could still have been generated at the VB end.
0
 
tesla764Author Commented:
I can't post they code. That's what I am trying to figure out. Where it's coming from.
Thanks Everybody.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now