Solved

MouseWheel DLL in Citrix Environment

Posted on 2008-10-22
5
607 Views
Last Modified: 2013-11-26
I have a database that I developed in Access 2003 and is set up as a front end/back end.  I used the microsoft knowledge base article 278379 to solve the issue of users scrolling through records by using the mousewheel.  I created the new dll file in VB6 and both the file and database work as expected with no issues.  Recently our office changed the servers on our network and now the users can scroll though the records again.  What do we need to do to get the mousewheel dll file working again?  Our network guys are saying this is a problem with my database but i know its not.  It still works fine when logged on to an old server, so the only thing that has changed is that the users are logging on to the new servers but now the mousewheel scrolling is enabled.  I think the new servers dont recognize the dll file but I dont know what causes that problem as I am not familiar with networkng.
0
Comment
Question by:yoducati
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:ET0000
ID: 22780329
You can investigate this without being a networking expert, but might need some help from the Citrix folks at your site. If you can connect to Citrix with a terminal session and get a desktop, you can use tools like Process Monitor (part of the SysInternals tools now provided free by Microsoft) to see what DLLs a process has loaded. If you don't get a desktop (your application launches "seamless" and appears as an application window on your local desktop), then you may need to have them set things up so you can run Process Monitor or another tool to monitor your DLLs

I suspect you will find that your DLL is not being loaded, either because it isn't available from the new server or because the environment/pathing isn't letting the application find it. In that case, you just need to find the right spot to put your DLL so it gets loaded and used.
0
 

Author Comment

by:yoducati
ID: 22780842
Ok we connect to citrix with a terminal session to get to our desktop so can you tell me where to look for the Process Monitor and how to implement it?  Once I find it do I turn that on and then try to run my database?
0
 
LVL 13

Accepted Solution

by:
ET0000 earned 500 total points
ID: 22781141
This is the SysInternals page on Microsoft's website with all their tools:
   http://technet.microsoft.com/en-us/sysinternals/bb545046.aspx

Process Monitor is here:
   http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Download it, run it on the Citrix machine, run your program, find your program in the list, bring up Properties for that program, go to the Process tab, and check your modules (DLLs) in the list at the bottom. That will show all the DLLs loaded, including the directory from which each was loaded.

You can resize the Properties dialog so more DLLs show in the list.
0
 

Author Comment

by:yoducati
ID: 22789932
Thanks for the help.  For some reason the new servers did not recognize the DLL file even though the path to it was identical, until I logged on to each sever and manually deleted the reference and browsed to it from within VBA and reselected it.  Once I did that on each server it took care of the problem.
0
 

Author Closing Comment

by:yoducati
ID: 31508842
Havent had a chance to download and use the software you suggested but Im working on getting it installed on our secure servers to make use of it in the future should something like this happen again.  im sure it will make it easier to diagnose the issues.  Thanks again for the help!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Several part series to implement Internet Explorer 11 Enterprise Mode
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

914 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

15 Experts available now in Live!

Get 1:1 Help Now