VB4(16) & Sybase System 10 OpenRecordset problem 
Author Message
 VB4(16) & Sybase System 10 OpenRecordset problem


I am having problems with Sybase & VB4(16).  I have an Access database
with all of the Sybase tables attached to it.  From within vb I am
opening the access database and attaching the Sybase tables to it.  When
I open up WISQL, I see that I have only one connection open, which is
good.  A little bit further on in the program, I am opening a recordset
(dynaset type) to pull data from one of the attached tables.  The instant
after the openrecordset call, two connections are open on Sybase.  From
that point on, I open other recordset objects without creating other
connections.  I have made sure my recordset is closed after I am finished
with it, but the connection still remains open.  The connection only
closes once my global database is closed.

The recordset that is opened is in a function.  I am passing my global
database to this function in a ByRef variable.  I have referenced my
global database in the function with the same results.

Any help would be appreciated.  Please, send responses to:


Curt Pederson
Triad Data Inc, Madison WI

Sat, 21 Nov 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VB4/Sybase System 10

2. vb4 RDO, intersolv odbc, and Sybase system 10

3. VB4.0 & Sybase Sys 10 Connect stmt

4. Sybase system 10 param queries

5. VB, ODBC, Sybase System 10, and Dynamic (real) SQL

6. VB 4.0 and the 32-bit ODBC for Sybase System 10

7. INSTCAT.SQL and Sybase System 10

8. Drivers to access Sybase System 10

9. Sybase system 10 param queries w/ RDO

10. Sybase system 10 param queries w/ RDO

11. VB 4.0 and the 32-bit ODBC for Sybase System 10

12. Sybase system 10, ODBC, RDO, VB5


Powered by phpBB® Forum Software