Results 1 to 8 of 8

Thread: MS SQL problem

  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unhappy Unanswered: MS SQL problem

    I have this problem, pls help:
    ____________________________________
    Description : CRASH ERROR
    oError:args :
    -> VALTYPE: L VALUE: T
    -> VALTYPE: U VALUE: NIL
    -> VALTYPE: C VALUE: select * from customer where num_cli = 'C 2497';
    -> VALTYPE: C VALUE: customer
    -> VALTYPE: U VALUE: NIL
    -> VALTYPE: L VALUE: F
    oError:canDefault : .T.
    oError:canRetry : .T.
    oError:canSubstitute: .F.
    oError:cargo : {NIL, 59, [01000][59][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).}
    oError:description : File can not be opened
    oError:filename :
    oError:genCode : 71
    oErrorperation : DbUseArea
    oErrorsCode : 0
    oError:severity : 2
    oError:subCode : 8999
    oError:subSystem : BASE
    oError:thread : 1
    oError:tries : 1
    ___________________________________

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What is this? I guess I forgot everything while being on vacation...

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    More information on the problem would be helpful to assess the issue, ensure no connection issues to SQL and on network too.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Posts
    4

    Informaton

    Originally posted by Satya
    More information on the problem would be helpful to assess the issue, ensure no connection issues to SQL and on network too.
    Is there possibility to that errors are up to network or up to MS SQL? What kind of information you need more? If is up MS SQL, where can be a problem?
    Thank you

    Kudovic

  5. #5
    Join Date
    Mar 2004
    Posts
    2

    Re: Informaton

    Originally posted by kudovic
    Is there possibility to that errors are up to network or up to MS SQL? What kind of information you need more? If is up MS SQL, where can be a problem?
    Thank you

    Kudovic
    You could give the details like what exactly was the operation you performed to receieve this error.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, when and where you get this issue.
    That connection error refers to the netlib protocol used to connect to SQL Server and if you are using named pipes, try changing to TCP/IP
    protocol to see if that makes a difference.

    Also, check to see if you have firewall enabled or any issues on network by referring to Event viewer.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Mar 2004
    Posts
    4
    Originally posted by Satya
    More information on the problem would be helpful to assess the issue, ensure no connection issues to SQL and on network too.
    There is no rules when is shown on the screen. Usually comes after processing datas.

    Thank you...

    Omar

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Are you using any third party application while processing data updation.

    Connect from query analyzer and run simple query to ensure no issues on SQL part.

    Try to execute similar query from QA .
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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