다음을 통해 공유

How to run 32-bit UDL file on a 64-bit Operating System

  • 아티클

Once we create an UDL File and run it on 64 Bit OS, it will list down all the 64 bit OLE DB providers installed on the machine.

The reason behind for this is simple. When you double click on a UDL file on a 64 bit machine, it’ll enumerate only the 64 bit OLE DB Providers and if we have the 32 bit Ole DB providers installed, we will not be able to find that in the enumerated list.

Create a udl file with the name test.udl under the path, C:\. 

When we have created a UDL file on a 64 bit machine and try to open it, the following 

"C:\Program Files\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl

Command will be called through C:\windows\system32\rundll32.exe.

Here both Oledb32.dll and rundll32.exe are 64 bit and will not enumerate the 32bit Dlls.

 

Then how to run the UDL which lists down the 32bit Dlls?  

We can find the 32bit version of Oledb32.dll under the path: C:\Program Files (x86)\Common Files\System\Ole DB

and 32 bit version of rundll32.exe under the path: C:\WINDOWS\SysWOW64.

 

We’ll need to execute the command below from a command line or Start/Run :

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl

Check the paths of rundll32.exe and oledb32.dll while running this command! 

Here you have your 32 bit OLE DB Providers.

Comments

  • Anonymous
    November 19, 2009
    Thank you very much for providing us with this information..

  • Anonymous
    February 21, 2010
    Thanks for your Valuable information

  • Anonymous
    June 08, 2010
    Another way to do something similar.Start->Run-> Type..c:windowssyswow64cmd.exe C:test.udl

  • Anonymous
    August 28, 2010
    Chaitanya MUITO OBRIGADO...VC CONSEGUIU O QUE MUITOS NÃO CONSEGUEM...PERFEITO ....ASSRodrigo From Brasil At São Paulo

  • Anonymous
    September 15, 2010
    Yes, this works, but when I run my website which will use the provider, it still has error.  How to make this commond which to run the oledb32.dll for 32bits machine valid forever?  I already enabled 32-bits applications for my website.

  • Anonymous
    September 15, 2010
    You will have to check if the IIS is configured to run 32bit applications.For IIS 6.0 refer: support.microsoft.com/.../894435For IIS 7.0 refer : blogs.msdn.com/.../iis7-running-32-bit-and-64-bit-asp-net-versions-at-the-same-time-on-different-worker-processes.aspx

  • Anonymous
    October 22, 2011
    How can i use that into my VBA code running in Access2007 32bit in win200864bit . I'm trying to connect to oracle. I have created the udl file and connection is ok with your solution. But what i have to do in my vba code?

  • Anonymous
    October 22, 2011
    I have Access2007 32bit running in Win2008 64bit and I'm trying to connect to oracle database. I have created udl file and I run it as you describe and connection is succesful. How can I use it in my vba code and connect to my oracle database?

  • Anonymous
    October 23, 2011
    Check msdn.microsoft.com/.../aa139932(office.10).aspx

  • Anonymous
    February 21, 2012
    The comment has been removed

  • Anonymous
    February 21, 2012
    @Prabhat : Thanks for sharing your experience. This helps other users too.

  • Anonymous
    March 14, 2012
    I need some Clarification to run this command..How to activate the udl file in silent mode since when i run this command udl file gets opened.When i connect the database through program (AutoCAD Lisp Files), it's pointing 64 bit udl instead of 32 bit. How can we activate the udl file permanently.. Please Help..Thanks in Advance :)

  • Anonymous
    March 15, 2012
    For 64-bit machines, always launch the UDL file from the syswow64 folder to have the 32-bit udl file.We launch the UDL file to give the end users the flexibility to specify the database, and the connection credentials. Based on the credentials selected they can test the connection. But if you want to ignore udl file getting launched, then probably you know the credentials already, and specify the connection string.

  • Anonymous
    June 13, 2013
    Thank you very much, you helped me a lot!

  • Anonymous
    December 31, 2013
    The comment has been removed

  • Anonymous
    May 21, 2014
    Nice, it worked for me.. Thanks

  • Anonymous
    July 06, 2014
    Thanku :D

  • Anonymous
    July 22, 2014
    Thank you!

  • Anonymous
    October 03, 2014
    32 bit sql connection dll file

  • Anonymous
    February 09, 2015
    Thanks for the Help

  • Anonymous
    April 28, 2015
    Thank you so much!  I hunted for hours yesterday trying to find a solution.  This worked perfectly.