Sql query issue for VB and C++

Question

1.00/5 (1 vote)

See more:

i have query in sql vb6.0 which is shown below:

loCon.Execute "Exec('kill " & rsa("spid") & "')"

when i wrote same query in c++ it is giving me a issue as

DB_E_ERRORSINCOMMAND One or more errors occurred during processing of command

could you please let me know what might be the issue or whether i have to update the query for c++

What I have tried:

Exec('kill(51)')

Exec('kill(52)')

Posted 4-May-18 3:30am

Member 13655759

Updated 4-May-18 6:31am

Add a Solution

Comments

Maciej Los 4-May-18 17:38pm

What returns: rsa("spid")?

Member 13655759 7-May-18 1:54am

value like 51

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2018-05-04T06:33:00

Solution 2

Taken this is SQL Server, KILL command does not use parenthesis, Have a try with

SQL

Exec('kill 51')

Another this is that depending on the library you use, it may or may not require EXEC for the call. So if the problem still remains, try executing the command simply as

SQL

kill 51

Posted 4-May-18 6:33am

Wendelius

Comments

Maciej Los 4-May-18 17:50pm

5ed!

Member 13655759 7-May-18 1:55am

i tried its not working

Wendelius 7-May-18 11:23am

What happens, do you get an error message? If you do, what does it say?

Jochen Arndt · Answer 2 · 2018-05-04T03:51:00

Solution 1

The SQL commands are not identical:

SQL

-- VB
EXEC('kill id')
-- C++
EXEC('kill(id)')

Just use the same (correct) syntax as in your VB code by passing the id parameter separated with a space instead of enclosed by parentheses.

Posted 4-May-18 3:51am

Jochen Arndt

Comments

Maciej Los 4-May-18 17:49pm

Well, it's not a matter of VB or c++, it's SQL issue.
I my opinion, first statement is correct. A second one - is not.

Jochen Arndt 5-May-18 2:33am

That is what I tried to tell him by showing the used SQL commands together for comparison ("did you see your error now"?). I even told him to use the correct syntax without parentheses.

Member 13655759 7-May-18 1:55am

i tried its not working

Jochen Arndt 7-May-18 2:53am

What have you tried?
Are there any error messages?

Note also that the solutions are just examples. You have to pass a valid ID.

Depending on the used database and the db interface you might also try to get the full SQL error message. That will be more informative.

Sql query issue for VB and C++

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Sql query issue for VB and C++

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us