I try to keep my mdac up to date. The problem is that it can be wrapped in a lot of other programs. Microsoft is famous for this. If you load excel, access, sql, or a host of other Microsoft products, you can end up with a hodgepodge of mdac files that will have different version numbers. All these programs will try to update your mdac with what happens to be wrapped in the software. In order for you to update, Microsoft has a mdac checker available for download which checks for inconsistincies in the files. It also gives recommended fixes. I always found it daunting to use this tool and have always updated with trepidation as it gives a bunch of warnings, etc. but I have never had any problems updating. I don't remember the exact URL, but if you go to their site and search, I am sure you can find it. Be aware that some versions only work with certain platforms and softwares. If you are using SQL 7, you can only upgrade mdac to a certain level. If you use database clusters, the upgrade level is different. NT -- diifferent -- XP different --etc etc etc etc

Make sure you read ALL the documentation, and trust me... Microsoft being what it is, there is a LOT of documentation!

p.s., I have never been able to get the tool to give my servers a clean bill of health when it comes to mdac. BUT I have never had any problems either.



which file did you do it on? I just did a search and found a bunch of diff
files containing "mdac" with various extensions like inf, cat, ini, dat, pnf
and some others

----- Original Message -----
From: "Ben Johansen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 11:27 AM
Subject: RE: Witango-Talk: Witango 5 / SQL Server 7


 I did a search for files named "mdac" and then did a right-click and
 selected properties and then version

 Ben

 -----Original Message-----
 From: Alan Wolfe [mailto:[EMAIL PROTECTED]
 Sent: Monday, October 18, 2004 9:26 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Witango-Talk: Witango 5 / SQL Server 7

 Is there a way to check your MDAC version?

 ----- Original Message -----
 From: "Robert Shubert" <[EMAIL PROTECTED]>
 To: <[EMAIL PROTECTED]>
 Sent: Friday, October 15, 2004 9:20 PM
 Subject: RE: Witango-Talk: Witango 5 / SQL Server 7


> The MDAC services does contain libraries which I believe are 'leaned' on > by the Witango ODBC system. I believe it could be beneficial to any > system using MS's ODBC system, regardless of driver. However, the most > benefit is going to be seen with MS SQL. > > Also, a note of warning to everyone reading this. Updating your ODBC > drivers in weird ways, getting too far out of sync with other resources > of the OS, could cause instability and other problems. The MDAC 2.8 and > 2.7 literature talks about OS versions, etc. Be aware of the > ramifications, and be ready to rollback. > > Robert > > -----Original Message----- > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > Sent: Friday, October 15, 2004 10:01 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Witango-Talk: Witango 5 / SQL Server 7 > > Gotta ask a dumb question. Would installing MDAC 2.8 help other db's > like > R:Base or does this just affect MS SQL? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > > -----Original Message----- > From: Jason Pamental [mailto:[EMAIL PROTECTED] > Sent: Friday, October 15, 2004 7:51 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 > > > Well, it's not scientific by any means, but (knocking on wood) since I > installed the MDAC 2.8 updater I haven't had the service hang (8 hours > so far). I'll keep you all posted on how it does over the next few > days. > > Thanks for the tip Bob! > > Jason > > On Oct 15, 2004, at 6:50 PM, MC Tay wrote: > > > We are also experiencing similar behavior with WiTango 5.5 and Oracle
> >
 > > 9i on Window 2003. The WiTango support does not have any answer to
 > > this at all and we are still trying to figure it out on our own.
 > > WiTango thread remains at 19 constantly. Our Oracle thread continues
 > > to grow slowly over time from 13 to 29 and above and that's when
 > > WiTango service died. We have to Stop and Restart the service almost
 > > everyday...pain in the butt. It also took a long time for it to stop
 > > when this happened. We think WiTango is not releasing something at the
 >
 > > end of datasource connection or even when it expires. We need help too
 >
 > > on this.
 > >
 > > MC
 > >
 > > At 10:15 AM 10/15/04 -0400, you wrote:
 > >> Hey everyone-
 > >>
 > >> Anyone out there using Witango 5 connecting to SQL Server 7? One of
 > >> our clients' environment is Windows 2000/SQL Server 7/IIS/Witango 5,
 >
 > >> and we're still having odd issues with threads getting stuck
 > >> seemingly on queries (different ones, not always the same) and then
 > >> hanging the Witango service. Since it's lots of different files, even
 >
 > >> ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC
 > >> issue. Anyone out there using this combination (ODBC Driver verison
 > >> 3.70.x)? Windows and SQL Server both have the latest service packs
 > >> (issue was there before and after those updates to SP4 on both).
 > >>
 > >> Thanks,
 > >>
 > >> Jason
 > >>
 > >>
 > >>
 > ______________________________________________________________________
 > >> __
 > >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 > >
 > >
 > >
 > _______________________________________________________________________
 > > _
 > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 > >
 > >
 > --
 > ____________________________________________________________________
 >
 > Jason Pamental, President
 >
 >    [EMAIL PROTECTED]
 >
 > Bathysphere Digital Media Services, Inc.
 > http://bathyspheredms.com
 > ____________________________________________________________________
 >
 > Tel: 401.490.6830      Fax: 401.490.6831
 > ________________________________________
 >
 >
 > A North American Distributor for Witango (http://www.witango.us)
 >
 > Rapid Web Application Development - XML Execution Engine
 >
 >
 >
 > ________________________________________________________________________
 > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 > ________________________________________________________________________
 > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 >
 > ________________________________________________________________________
 > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 ________________________________________________________________________
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to