Solved

visual basic 6 on new server

Posted on 2013-01-10
4
334 Views
Last Modified: 2013-01-14
I am maintaining a vb6 application that needs to be move to a new windows server 2003
The new server will not have vb6 install since we do not have the installation cds.
The exe is copy over from my workstation to the C drive on the new server.
The vb6 fails to run and by using msgbox fails at this line
Set cnnJE = New ADODB.Connection
I believe all the references from the old workstation was copy over to the new server.
I could make changes to the vb code on the old workstation where it works and
move it to the new server where it does not work.  Do I need anything else to get the
vb6.exe to run ?
0
Comment
Question by:phiadmin
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38766297
you will need to run the ADODB (mdac) setup.
http://msdn.microsoft.com/en-us/library/ms810805.aspx
0
 

Author Comment

by:phiadmin
ID: 38767775
the above website had a lot of useful information but where do I get the download to run the ADODB (mdac) set on the window 2003 server ? thanks
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 175 total points
ID: 38768044
search for mdac download.
the latest version (2.8 SP1):
http://www.microsoft.com/en-us/download/details.aspx?id=5793
0
 
LVL 15

Accepted Solution

by:
eemit earned 175 total points
ID: 38773135
If it is a 64-bit edition, consider that a 64-bit Windows has:
- two different versions of the system directory:
      System32 - Windows System folder for 64-bit files
      SysWOW64 - Windows System folder for 32-bit files
- two versions of the regsvr32.exe file:
      The 64-bit version is %systemroot%\System32\regsvr32.exe
      The 32-bit version is %systemroot%\SysWoW64\regsvr32.exe
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

770 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