SQL 6.5 & NT 3.51 VB Problem (GPF) 
Author Message
 SQL 6.5 & NT 3.51 VB Problem (GPF)

I have a problem under NT3.51 Service pack 4 connecting to SQL 6.5 Via
ODBC using VB3.

We have tried the ODBC drivers from boith SQL server 6.0 and 6.5.

In total we are inserting or updating approx 120K records.

I a populating a number of tables with data taken from a flat file.
If there is a commit after 500 records (inserts) and the ODBC connection
is maintained throughout I get a GP Fault, this looks a bit like some
corruption has come in from somewhere. The GPF message has strange
characters in it (they look like NULLS as they are not displayed as
ascii, i.e. they appear a blocks in the dialog). Going for the usual
close ignore the sittuation persists eventually ending in the Win16
envorionment for NT eventually blowing up taking all 16-bit apps with
it.

I have a work around which involves disconnecting then re-connecting to
the data source after each transaction has been commited. This incurs a
performance overhead.

Does anybody out there have similar problems or know of any relevant
service pack, patches updated drivers etc.

Any help gratefully recieved, thanks in advance
--
Dave Allen



Fri, 29 Jan 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. LONDON - VB 5.0/Sql-Server 6.5/ NT 4 - Developers - Derivatives Trading Systems

2. LONDON - VB 5.0/Sql-Server 6.5/ NT 4.0 - Developers - Derivatives Trading Systems

3. NT 3.51 -> NT 4.0 problem

4. VB 5 and SQL Server 6.5 and Windows NT 4.0

5. NT 3.51 and VB 3.0 Compile Problems

6. Timer release problem under NT 3.51 / VB 3.0

7. pdssql.dll missing & SQL 6.5 / RDO problems

8. pdssql.dll missing & SQL 6.5 / RDO problems

9. ADO CONTROL & SQL 6.5 PROBLEM

10. VB: Determine NT 4.0 and NT 3.51

11. VB 6.0 & SQl server 6.5

12. VB & SQL Server 6.5 Contract

 

 
Powered by phpBB® Forum Software