Solved

visual basic 6 on new server

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

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

932 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

14 Experts available now in Live!

Get 1:1 Help Now