Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Arrow Unanswered: ADO, SQL Server 2000 and VB5

    I am use ADO, SQL S.erver 2000 and aplication in VB 5
    When I execute recordset.open VB return error 6 overflow.

    Set rsSql = New ADODB.Recordset
    rsSql.ActiveConnection = oConn
    rsSql.CursorLocation = adUseClient
    rsSql.CursorType = adOpenDynamic
    rsSql.LockType = adLockPessimistic
    rsSql.Index = "ChaveAto"

    Sqlquery = "select id_ato from ato where chave_ato = " & "MP00002183200108240120010827PR"

    ' MsgBox (Sqlquery)

    rsSql.Open Sqlquery

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    if chave_ato is a char/varchar data type you might need to enclose MP00002183200108240120010827PR in quotes.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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