We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

OraOLEDB error '80040e4b' RSS

4 replies

Last post Nov 12, 2018 12:42 PM by nagaozen

  • OraOLEDB error '80040e4b'

    Nov 03, 2018 08:01 PM|simflex|LINK

    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

  • Re: OraOLEDB error '80040e4b'

    Nov 05, 2018 05:18 AM|Brando Zhang|LINK

    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

  • Re: OraOLEDB error '80040e4b'

    Nov 05, 2018 09:22 PM|simflex|LINK

    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.

  • Re: OraOLEDB error '80040e4b'

    Nov 09, 2018 05:20 AM|Brando Zhang|LINK

    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

  • Re: OraOLEDB error '80040e4b'

    Nov 12, 2018 12:42 PM|nagaozen|LINK

    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