Solved

visual basic 6 on new server

Posted on 2013-01-10
4
335 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 143

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 143

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
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…

828 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