Re: ODBC Time Out Expired


"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

  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... remote connection. ... should I just check named pipes only or both TCP/IP and ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ...
    (microsoft.public.sqlserver.connect)
  • Re: Using SQL Server Express on Shared PC
    ... you don't need to install SSMS or VS on the client system. ... using ODBC you're making the job of getting connected more difficult. ... ODBC requires either a REGISTERED DSN, a file-based DSN or a "DSN-less" connection. ... You also need to configure the Network-shared SQL Server service to permit access by whatever credentials you have chosen. ...
    (microsoft.public.sqlserver.connect)
  • Re: Performance of ODBC
    ... ODBC / MDB is a waste of time. ... Usiing Access front-end to connection a back end through ... the database via ODBC with the Jet database engine. ... that Access is the front end, and the SQL server is the back end. ...
    (microsoft.public.access.adp.sqlserver)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)