• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2250
  • Last Modified:

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

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
here:-
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?
Thanks
Keith

   
0
keith66miners
Asked:
keith66miners
  • 4
2 Solutions
 
cookreCommented:
0
 
keith66minersAuthor Commented:
cookre,
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.
Keith  
0
 
keith66minersAuthor Commented:
cookre,
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?
Keith
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LeeTutorretiredCommented:
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.
0
 
keith66minersAuthor Commented:
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.
Thanks
Keith
0
 
keith66minersAuthor Commented:
The link helped to ensure I was on the right lines - although it didn't work as stated.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now