Solved

visual basic 6 on new server

Posted on 2013-01-10
4
338 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SendBlaster Pro 4 - Bulk Email Sending Software

SendBlaster 4 Pro - Best Bulk Emailing Sending Software
Automatic Subscribe / Unsubscribe Processing
Great for Newsletters & Mass Mailings
Optional HTML & Text Composition
Integration with Google Features
Built in Spam Score Checking
Free Professional Templates - Feature Packed!

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

739 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