VB ODBC <--> RDB Connection Issues 
Author Message
 VB ODBC <--> RDB Connection Issues

I am on a project where we are accessing enterprise data that resides on a VAX
rdb with VB through ODBC.  We are having a problem with the server processes
eating up CPU time.  This is unacceptable because the database is used for
other critical applications.  The trouble is, we cant figure out what is
causing our process to take up so much CPU.  When a connection is made, the
process runs normally, but as time goes by it demands more and more processing
time.  It seems as though we are not closing threads in the processes, but
VB's close method doesnt seem to do anything, and VB claims that it cleans up
open connections when you exit the app.  

Any suggestions or opinions would be greatly apreciated.



Sun, 21 Sep 1997 03:00:00 GMT  
 VB ODBC <--> RDB Connection Issues

Quote:

>I am on a project where we are accessing enterprise data that resides on a VAX
>rdb with VB through ODBC.  We are having a problem with the server processes
>eating up CPU time.  This is unacceptable because the database is used for
>other critical applications.  The trouble is, we cant figure out what is
>causing our process to take up so much CPU.  When a connection is made, the
>process runs normally, but as time goes by it demands more and more processing
>time.  It seems as though we are not closing threads in the processes, but
>VB's close method doesnt seem to do anything, and VB claims that it cleans up
>open connections when you exit the app.  
>Any suggestions or opinions would be greatly apreciated.

You might want to post this to the comp.databases.rdb group as I believe it is
a SQL Services problem (Rdb's Server Process).  I believe they have discussed
this at one time or another.  DSN Link, if you have a current Digital Service
Agreement, is another alternative.  

D.M.(Mike) Mattix

Organization: Ag Group of Monsanto
              Luling, LA 70070



Fri, 26 Sep 1997 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB5<->RDO2<->ODBC<->ORACLE Procedure Problem

2. <<<<<<<<ComboBox>>>>>>>>>>>>

3. HELP >>>>>>WIN API <<<<<<<<<<

4. ODBC Connection Strings for LDAP<->ODBC in Visual Basic for MS Access

5. <<FANZINE : Issue 8 Request>>

6. AS400<-->ODBC<-->Access

7. VB30 <-<ODBC>-> Access 2.0

8. help me out please!!!!<<<<<<<<<<<<<<<<<<<<<<<thanks>>>>>>>>>>>>>>>>>>>>>>>>

9. <><><>HELP<><><> PCMCIA Motorola Montana 33.6

10. <<<<HELP- OLE container Control>>>>>>>>>

11. ODBC connection to <name> failed

12. <<<Cneck Box>>>

 

 
Powered by phpBB® Forum Software