Global Variable Missing!

[Crazyec]

Hi Professionals, I have a problem in my VB Program. I have create a VB 6 program which have created some Global Variable at the start of the program(Module). One of the global variable is to storage the Language that User would like to use (They can select the language in the login form). After login, my program will get the language ID from the global variable and pass that to the Stored Procedure in the MS SQL Server 2000. It works fine in every client (This is a Client/Server Application which Client Side has around 5 users). But today, one of the user cannot use the program since it said that it cannot pass the language ID to the Stored Procedure.(It said that there are missing parameters for the stored procedure).
Is there anyone face this before? What happen at all?
Is there any solution for this problem?

Actually, I have tried to enlarge the virtual memeory and have done the defragmentation. But these are not help (I think the virtual memory is not enough for store too much variables)

 

[Inwoner]

It sounds like the SQL statement passed to your Stored procedure is missing a parameter.

Q1: The LanguageID, what is the type of this global
Q2: Have you monitored your database to see what is the exact statement that come through.

Try to use the DBCC INPUTBUFFER statement to determine what the exact SQL call was.

 

[Crazyec]

Yes, I'm not sure why it missing.
Q1: I need to check tomorrow, should be integer.
Q2: Haven't. Can you tell more about how to use the DBCC INPUTBUFFER statement to determine what the exact SQL call was??

Thank you so much.

 

[Inwoner]

Refer to SQL books online.

 

[johnwm]

It's available free:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Crazyec]

Thank you. Known from the user, the user can login to my program again. I think the Computer has something wrong.