🚀 go-pugleaf

I am currently writing an application in C++ Builder 5 Pro using ADOExpress,
with all service packs installed which connects to an MS SQL 2000 Database.
The entire application has been developmented in Windows 2000 pro OS.  With
this application the user can create his/her own connection string because
we have two servers using the same database - one is for development, and we
have a live server.  The development server is connected internally where
the live is outsourced, so we have to connect via the internet.  The
application connects to both development, and live servers with no problem.

I am at a point of testing a workable beta.  I used Wise InstallBuilder 8.14
to package my application.  I also attached MDAC 2.6 drivers to the install.
I deployed the the application to my Windows ME box.  Wise installed MDAC
2.6, and then installed by application properly.  I created a connection
string to connect to my development server, which again is internal, and I
connected with out a problem.  However when I created the connection string
for the live server, I keep on getting the same error, using the data source
wizard, [DBNETLIB][ConnectionOpen (Connect) ), ].SQL Server does not exist
or access denied.

I teh proceeded to another computer inside my network, a Windows 98 box,
when installed wise skipped the  MDAC driver installation - I had installed
other applications using MDAC before using Wise InstallBuilder 8.12, so that
came to no surprise - after the installation finished I ran the application,
and tested my live server.  It connected with no problem.

I went back to my windows me machine, and installed MDAC 2.6 SP 1, still
with no luck I could not connect to my live server.

I used a program called ComCheck to tell me what versions of MDAC I had on
each machine:
Windows ME - 2.6 Sp1
Windows 98 - 2.6
Windows 2000 pro - 2.6
Windows 2000 server - 2.6 (development server)

I called up a friend to help out.  He downloaded the application on his
Windows 98 computer, ran it, and it installed MDAC 2.6 and the application.
He created the development connection string, and it worked.  He then
created the live server connection string, and connected failed.

So I installed MDAC 2.6 SP1 on the windows 98 machine, and I was able to
connect to both servers.

I installed SQL Server 2000 sp1 on my windows 2000 server, and still nothing
has changed.

Is this the right area for this problem - I have no clue, maybe I should
post a message on Wise's message group, but I will see if anyone here has
ran into this problem,and maybe has a solution.

Thank you,
Peter Dragun