Execute query that lookup with view.

Question

1.00/5 (1 vote)

See more:

Hi guys please can you give me an advise on this.
I have a program in vb6 with sql server database and I got an error during running a query that look up in a view in sql server. But if I run it thru sql server console it runs well...

Any suggestions for those who encounter or has a opinion on these...thanks guys...

Posted 16-Apr-12 7:08am

jdandes

Add a Solution

Comments

Bala Selvanayagam 16-Apr-12 13:14pm

How long it takes to run the query and get the results in query analyser ?

My understanding is that it does not work in the VB6 environment but works when directly executed on the SQl server ?

Nelek 16-Apr-12 17:11pm

If the proposed issue of Timeout is not what gives the problem, please use the "improve question" to add a piece of the relevant code where the error occurs. People here will get it easier to help you if you give more information.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mehdi Gholam · Answer 1 · 2012-04-16T08:41:00

Solution 1

Your command could be timing out (default is 30 seconds) read the following link:
http://stackoverflow.com/questions/4327610/resolving-an-ado-timeout-issue-in-vb6[^]

Posted 16-Apr-12 8:41am

Mehdi Gholam