WinXP - ADO - VB and SQL Error 
Author Message
 WinXP - ADO - VB and SQL Error

Hi

I made a VB program that works great on Win 95, 98 and 2000. When running
from a workstation using Win XP professional it causes and error when
reading a lot of records of a SQL 7 database.  The code is something like
this:

tB_products.close
tb_products.source = "select * from products"  'this table has about 10.000
records
tb_products.open

tb_products.movefirst
do
...
...

   if tb_products("type") = "x" then
     tB_prices.close
     tb_prices.source = "select * from prices where product = "  +
tb_PRoducts("Code")
     tb_prices.open
     ....
  end if

   if tb_products("type") = "y" then
     tB_stock.close
     tb_stock.source = "select * from stock where product = "  +
tb_PRoducts("Code")
     tb_stock.open
     ....
  end if

 tb_products.movenext
loop until tb_products.eof

Well, running inside VB on the XP workstation I can see that the error
(ConnectionOpen ou Write) happens on one of the the "table.open"  statement.

It occurs occasionally on any of the .open statement.

If I run the program in the same machine that the SQL is installed the error
does not happen. It only happens on a XP workstation.

Thanks for any help.



Mon, 19 Jul 2004 03:31:37 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. WINXP and e_fail error w/ VB and FoxPro Database

2. WINXP and e_fail error w/ VB and FoxPro Database

3. ADO/WinXP/Win98 Errors - strange! HELP please

4. Running VB application hitting SQL 6.5 on WinXP

5. Trapping SQL error in VB before ADO raises run-time error

6. WinXP, VB6, SQL Server 2000 ADO

7. VB,ADO,SQL [Microsoft][ODBC SQL Server Driver] Protocol error in TDS stream

8. sql server 2000 Installing error on winxp

9. SQL Server 2000 & WinXP Error

10. ADO ADO ADO ADO ADO VB examples / samples book wanted

11. Error when using AddNew method in ADO (using ADO 2.7 SP1 from VB 6 SP4)

12. VB/ADO/SQL 6.5: Protocol error in TDS stream


 
Powered by phpBB® Forum Software