Re: ODBC Time Out Expired

Hi Travis,
you may try to increase the value of the CommandTimeout property of the ADO
connection (or Command) object you use to execute your query.
Or set it to 0, like you did for the ConnectionTimeout property.
--
Alberto Covili


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> ha scritto nel messaggio
news:784B63E7-F666-4025-9572-BAC9B63C6AE8@xxxxxxxxxxxxxxxx
> Hi Mike ,
>
> Thanks for your advise. I already try out Use the SQL Server OLEDB
> Provider
> before I use ODBC. I still get the same issue. I am not sure
> what is wrongs actually ?
>
> "MikeD" wrote:
>
>>
>> "Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:E188FD1D-4E23-481B-A02B-FEE5AA026055@xxxxxxxxxxxxxxxx
>> > Hi ,
>> >
>> > I am using vb6 to connect to SQL Server 2000 through ODBC. When
>> > execute
>> > the query in VB , I always get an error say that "Time Out Expired" ...
>> >
>> > In SQL Server I already set query timeout = 0 , but I don't know how
>> > to
>> > set for ODBC driver. Please help if someone know the vb coding or any
>> > way
>> > to
>> > set it ?
>>
>>
>> Are you using ADO? I'll assume the answer is yes.
>>
>> First, if I were you, I'd drop ODBC. Use the SQL Server OLEDB Provider
>> instead. Second, you can set the connection timeout by specifying a
>> value
>> for the ConnectionTimeout property of ADO's Connection object.
>>
>> --
>> Mike
>> Microsoft MVP Visual Basic
>>
>>
>>
>>


.

Relevant Pages

  • [Full-Disclosure] Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
    (Full-Disclosure)
  • Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit we are ... Connection closed by foreign host. ... think what we want to execute. ...
    (Bugtraq)
  • Re: ADODB Command memory leak
    ... _ConnectionPtr conn = NULL; ... // Execute statement. ... > My logic is such that the connection to the database is not maintained ... Create/Append command parameters ...
    (microsoft.public.data.ado)
  • Re: Script Controlled Dynamic Task Execution
    ... My package had three connections to three ... and each had a transformation for itself. ... After posting, I just created three packages for each connection, and my ... >> need to execute one transformation on a text file, ...
    (microsoft.public.sqlserver.dts)
  • Re: Error 80040e14 (ADO -2147217900) Die Datenbank-ID-X konnte nicht gefunden werden
    ... Wenn ich die Execute Methode nutze wieviele "Wordload ... Du darfst durchaus mehr Verbindungen haben, ... > Problem habe was was soll ich den beim Connection setzen. ... > Danach wird auf der bestehenden Connection nur noch mit Recordsets und ...
    (microsoft.public.de.sqlserver)