Djabarov, Robert
Robert.Djabarov at usaa.com
Wed Nov 19 12:26:30 CST 2003
If you modify MDAC on a SQL box through anything other than a service pack, - you're really asking for trouble! And what do you mean by "they are not the most optimal ones"??? MDAC? That statement just doesn't make any sense! -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco H Tapia Sent: Wednesday, November 19, 2003 12:22 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]SQL Server strangeness Yes but in the Microsoft tradition, they are not the most optimal ones.. :( sorry. -- -Francisco John W. Colby wrote: >Thanks, I'll check that. I know that SQL Server loads it's own when it >installs. > >John W. Colby >www.ColbyConsulting.com > >-----Original Message----- >From: dba-sqlserver-bounces at databaseadvisors.com >[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of >Francisco H Tapia >Sent: Wednesday, November 19, 2003 1:36 AM >To: dba-sqlserver at databaseadvisors.com >Subject: Re: [dba-SQLServer]SQL Server strangeness > > >I'd start w/ the MDAC that is loaded on your crashed box, what did you >have before, and what do you have now? get the component checker from >microsoft.com/downloads > >I highly recommend MDAC 2.6 sp1 and above. > >-- >-Francisco > >John W. Colby wrote: > > > >>Awhile back I moved my client billing to SQL Server, just a simple >>upload >> >> >of > > >>the mdb data, and then relinked to the ODBC. Nothing fancy. >> >>It all just worked. >> >>Now (since recovering EVERYTHING due to a hard disk crash), the LIKE >> >> >keyword > > >>is causing failures in the odbc call. I use things like "LIKE >>forms!someform!somecontrol" etc. Now this fails (silently), just no >>data returned. Replace the LIKE with IN() and it works again. >> >>The TRULY strange part is that I use a LIKE ccfrmWhich() EVERYWHERE in >> >> >order > > >>to only display active records in my forms. That fails in a combo, >>but succeeds in the form that hosts that combo. >> >>I do so love Access / SQL Server. >> >> >> >>John W. Colby >>www.ColbyConsulting.com >> >> >> >> > > > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com