Monday, March 19, 2012

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
oError:operation : DbUseArea
oError:osCode : 0
oError:severity : 2
oError:subCode : 8999
oError:subSystem : BASE
oError:thread : 1
oError:tries : 1
___________________________________What is this? I guess I forgot everything while being on vacation...|||More information on the problem would be helpful to assess the issue, ensure no connection issues to SQL and on network too.|||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|||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.|||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.|||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|||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 .

No comments:

Post a Comment