MDAC problems with SQL Server 2000
Dave Quaid (Ireland)
MSDE/SLQ 7.0. Perhaps this problem is occuring with your SQL 2000 server
too. Have you tried MDAC 2.5 with your WISE install?
--
eScape Systems - developing Outlook Software
http://www.escapesys.com
*****************************************************************
Visit our new DOT NET ZONE for all that's hot!
<http://www.vbug.co.uk>
****************************************************************
"Peter Dragun" <pdr...@home.com> wrote in message
news:u86L9qtHBHA.1356@tkmsftngp02...
> 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
>
>
>
>