Run time error 3633 - cannot load DLL '?????L?'

Posted on 2011-05-04
Last Modified: 2012-05-11
Hello experts,
I have a Windows 2000 vb6 and Crystal Reports XI development environment. I need to deploy to Windows XP (version 5.1 build 2600.xpsp_sp3_gdr.101209-1647 : Service pack 3).
I am using Visual Studio Installer process to create a Project.msi file that I run as administrator on the XP box and which installs the Project successfully.

I recieve the error(in title)  when I try to run the project - first thing in the project is to open database access using the code
strcn = "ODBC;DSN=LocalServer;UID=sa;PWD='pallas';DATABASE=Miners Live Database"
Set myworkspace = DBEngine.CreateWorkspace("ODBCWorkspace", "", "", dbUseODBC)
Set Dbgeneral = myworkspace.OpenConnection("", dbDriverNoPrompt, False, strcn)
Dbgeneral.QueryTimeout = 120   'Default 30 secs may not be enough

This code certainly woks for Windows 2000 environment.

Anybody help?

Question by:keith66miners
    LVL 23

    Assisted Solution


    Author Comment

    Yes I have seen this already - I have included the Msrdo20.dll (using the add file process) - when the build finished it had generated another task "warning that the M...msm file already contained that dll and advised to use that" (sorry about M...msm but I'm not at work). I didn't have time to try running the MSI file - will do so tomorrow.

    Accepted Solution

    I have tried using the Msrdo20.dll - that produced the same error. I then tried a new build and including the Msrdo20.msm as a (add a merger file) merge.
    This was successful! - able to link to DB without problems (as user Admin).

    However when I switched user to run as a User "testxp" I got the same 3633 error. The user "testxp" is set up on the xp box with admin permissions.

    So - I removed the project from the xp box, switched user to "testxp" ran the Project.msi process and then tried to run my Application. This produced "Run time error 3146 ODBC call failed".

    If I try to run as "admin" I hit a problem of "admin has no password setup"

    So I'm making progress.

    Any suggestions of where to next?
    LVL 59

    Expert Comment

    I've requested that this question be deleted for the following reason:

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Author Comment

    I'm sorry - I've been away.
    I do believe  "cookre" should recieve some points for his comment - so I probably should have acepted his answer.
    The question should not be deleted as I believe it would be helpful for anyone else meeting this problem.
    I will raise my followup as a separate question.

    Author Closing Comment

    The link helped to ensure I was on the right lines - although it didn't work as stated.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now