Solved

Trying to identify if error is coming from VB6 or SQL

Posted on 2014-03-03
4
244 Views
Last Modified: 2014-03-04
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
Comment
Question by:tesla764
4 Comments
 
LVL 29

Assisted Solution

by:Paul Jackson
Paul Jackson earned 200 total points
ID: 39901906
Definitely a SQL Syntax error in the sql query being used.
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 100 total points
ID: 39901918
Hi,

Can you post the query?

Regards
  David
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 200 total points
ID: 39902676
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
 

Author Closing Comment

by:tesla764
ID: 39903075
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now