Simple question about odbc driver for informix 
Author Message
 Simple question about odbc driver for informix

Could somebody tell me what version of odbc driver I need to
CommandTimeout property work fine in Ado object.
For example in the nexr code:

  cnnString = "DSN=xxx;user=xxx;PWD=xxx"
  Set cnn = Server.CreateObject("ADODB.Connection")

  cnn.Open cnnString
  cnn.CommandTimeout = 1
  startDate = Now
  Set rs = cnn.Execute("SELECT * FROM mytable")

  Do While Not rs.EOF
    Response.Write rs("name")
    Response.Write "<BR>"
    rs.MoveNext
  Loop
  Response.Write "<br>"
  Response.Write "delay: " & DateDiff("s", startDate, Now)
  rs.Close
  cnn.Close
  Set rs = Nothing
  Set cnn = Nothing

In the command object don't work fine too,because the page is load and
I don`t want this.I'm using Datadirect Infomix 4.0 and INFORMIX 3.80
32 BIT.
Thanks in advance



Sat, 05 Jun 2004 22:32:51 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. INFORMIX ODBC error , [State=S1000][Error=-406][INTERSOLV][ODBC Informix driver][Informix]Unable

2. Informix ODBC Drivers vs Merant ODBC Drivers

3. Errore:-2147467259 - [Informix][Odbc Informix Driver][Informix]

4. informix OLE DB drivers VS ODBC driver Please Help

5. [ODBC Informix driver][Informix]Unable to load locale categories

6. Errore:-2147467259 - [Informix][Odbc Informix Driver][Informi

7. Multiple Open Connections to Informix 7 and Intersolv's Informix 7 ODBC Driver

8. Informix odbc driver and unix odbc

9. OLEDB for ODBC and Informix ODBC driver error

10. SQL7, SIMPLE SIMPLE SIMPLE question

11. Implementing Simple Read-Only ODBC Driver.

12. Looking for old ODBC driver & ODBC question


 
Powered by phpBB® Forum Software