Professional Web Applications Themes

ADO & SQL Server - Microsoft SQL / MS SQL Server

I have a Visual C++ program using ADO to load data into a SQL Server 7.0 database. I'm getting an error after loading about 5,000-10,000 records. The error code is 80004005. The message is "Unspecified error" and the description is "[DBNETLIB][ConnectionRead (recv()).] General network error. Check your network doentation.". I'm completely stumped!!...

  1. #1

    Default ADO & SQL Server

    I have a Visual C++ program using ADO to load data into a
    SQL Server 7.0 database. I'm getting an error after
    loading about 5,000-10,000 records. The error code is
    80004005. The message is "Unspecified error" and the
    description is "[DBNETLIB][ConnectionRead (recv()).]
    General network error. Check your network
    doentation.". I'm completely stumped!!

    Charlie Guest

  2. #2

    Default Re: ADO & SQL Server

    Charlie (com) writes: 

    One possible cause is that there is an execution error in the SQL Server
    process itself, which causes SQL Server to terminate the connection.
    Check the SQL Server log for stack dumps. Such crashes are usually
    to blame on bugs in SQL Server.

    --
    Erland Sommarskog, SQL Server MVP, se

    Books Online for SQL Server SP3 at
    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
    Erland Guest

  3. #3

    Default Re: ADO & SQL Server

    Charlie,

    Not sure why the error but you might want to think about using other methods
    to load that many rows. If you can get the data into a file you can use
    DTS, BCP or BULK INSERT to load them much faster than individual inserts
    thru ADO.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Charlie" <com> wrote in message
    news:044601c365cc$c38df4e0$gbl... 


    Andrew Guest

Similar Threads

  1. Replies: 2
    Last Post: March 30th, 04:02 AM
  2. Replies: 0
    Last Post: November 27th, 06:14 PM
  3. Replies: 2
    Last Post: September 12th, 10:44 PM
  4. Replies: 0
    Last Post: August 23rd, 05:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139