locked
OraOLEDB error '80040e4b' RRS feed

  • Question

  • User1216627406 posted

    Greetings experts,

    My partner that handles classic ASP (yes, we still use it) but he is on vacation for a month and I am backing her up.

    I have not used classic ASP in more than 10 years.

    Yesterday, one of our users tried to search for her parcel on the website and ran into the following error:

    The system cannot find message text for message number 0x80040e4b in the message file for OraOLEDB
    D:\config/FunctionSubTyler1.inc, line 62

    Here is the function where the error is coming from:

    Function check_null_var(var)
        If IsNull(var) Then
            check_null_var = ""
        Else
            check_null_var = var
        End If
    End Function

    and the offending line (line 62) is on this line:

        Else
            check_null_var = var

    Any ideas why this is causing the problem?

    Thanks in advance for your help

    Saturday, November 3, 2018 8:01 PM

All replies

  • User-72702933 posted

    Hi simflex,

    Please make sure you have installed the correct version of Oracle Provider for OLEDB with Oracle Client on your machine, then please choose the appropriate runtime mode (depends on your version of driver) to execute the package.

    Best Regards,

    Brando

    Monday, November 5, 2018 5:18 AM
  • User1216627406 posted

    Thanks Brando.

    I saw that same post some place but not sure if that is the solution.


    Why?

    Only one parcel out of thousands is having this problem.

    So, if that suggested solution is the problem, I am sure it would have affected more than just that parcel ID.

    Monday, November 5, 2018 9:22 PM
  • User-72702933 posted

    Hi simflex,

    As you say, this issue is sometime occured.

    In my opinion, this issue is mainly related with the oraoledb library.

    I suggest you could try to post this issue on the oracle forum.

    https://community.oracle.com/community/groundbreakers/database/developer-tools/sql_and_pl_sql 

    Best Regards,

    Brando

    Friday, November 9, 2018 5:20 AM
  • User1012912168 posted

    My two cents: VBScript uses different ways to assign values to variables, so the function is defective by design. You may try to update it to something like:

    Function check_null_var(ByRef var)
    	If IsNull(var) or IsEmpty(var) Then
    		check_null_var = ""
    	Else
    		If IsObject(var) Then
    			set check_null_var = var
    		Else
    			check_null_var = var
    		End If
    	End If
    End Function


    Monday, November 12, 2018 12:42 PM