MDAC2.71 Service Pack 1 Refresh: mdac_typ.exe ??

Hi all,
I run MDAC Component Check on my SQL Server 2000. None
of the versions of MDAC passed the tests. The closest one
is 2.7 SP1 (2.71.9030.9) with only One error on
msjtes40.dll file
msjtes40.dll,Error,Field 'FileVersion' mismatch:
Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
Expression
Does this mean that I have to install 2.71 Service
Pack 1 Refresh: mdac_typ.exe ?
What files contain in this mdac_typ.exe? Would
installing this file help on Memory Leak?
Thank you sooooo much!!!
P.S.: I think I install 2.7 SP1 via Windows Update. I
didn't apply SQL Sever 2000 SP3 at all.
AnnieThat file almost always checks different, so don't worry.
normally if the version number is higher compared to the closest match it is
OK.
This normally happens because you installed some software with an newer DLL.
( I am assuming msjtes40.dll is installed by MS Office, since I always see
it being different at work.)
Tim S
"Annie" <piyomeme@.yahoo.com> wrote in message
news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
> Hi all,
> I run MDAC Component Check on my SQL Server 2000. None
> of the versions of MDAC passed the tests. The closest one
> is 2.7 SP1 (2.71.9030.9) with only One error on
> msjtes40.dll file
> msjtes40.dll,Error,Field 'FileVersion' mismatch:
> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
> Expression
> Does this mean that I have to install 2.71 Service
> Pack 1 Refresh: mdac_typ.exe ?
> What files contain in this mdac_typ.exe? Would
> installing this file help on Memory Leak?
> Thank you sooooo much!!!
> P.S.: I think I install 2.7 SP1 via Windows Update. I
> didn't apply SQL Sever 2000 SP3 at all.
> Annie
>|||Thank you, Tim.
I don't have MS Office installed on Server, but it could
be something else.
That was helpful. Thank you~
Annie
>--Original Message--
>That file almost always checks different, so don't worry.
>normally if the version number is higher compared to the
closest match it is
>OK.
>This normally happens because you installed some software
with an newer DLL.
>( I am assuming msjtes40.dll is installed by MS Office,
since I always see
>it being different at work.)
>Tim S
>
>"Annie" <piyomeme@.yahoo.com> wrote in message
>news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
>> Hi all,
>> I run MDAC Component Check on my SQL Server 2000.
None
>> of the versions of MDAC passed the tests. The closest
one
>> is 2.7 SP1 (2.71.9030.9) with only One error on
>> msjtes40.dll file
>> msjtes40.dll,Error,Field 'FileVersion' mismatch:
>> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
>> Expression
>> Does this mean that I have to install 2.71 Service
>> Pack 1 Refresh: mdac_typ.exe ?
>> What files contain in this mdac_typ.exe? Would
>> installing this file help on Memory Leak?
>> Thank you sooooo much!!!
>> P.S.: I think I install 2.7 SP1 via Windows Update. I
>> didn't apply SQL Sever 2000 SP3 at all.
>> Annie
>
>.
>

MDAC upgrade problem CompCheck reports 2.5 instead of 2.8

I am running SQL server on a Windows 2000 server with sp4 installed. After installing SQL service pack 4 on the machine my applications began complaining that MDAC was version 2.5 sure enough CompChecker reports version 2.5. I have tried to install the latest version of MDAC (2.8) on the machine but no matter what I do CompChecker reports 2.5.

I've tried reinstalling the SQL service pack I had no luck with that. Any help with this issue would be greatly appreciated.

WHen was the Windows service pack4 was applied, is it after SQL SP4 or before?

Check this KBA http://support.microsoft.com/kb/823939 for informaiton, ifyou need then you have to install MDAC 2.8 seperately.

|||The service pack was applied before the upgrade.|||I don't know if this helps but I think the issue is with the Windows File Protection. If I attempt to rename one of the dlls the server will automatically replace the file on the server with the 2.5 version. Is there some way to overcome this?|||Did you try to install the MDAC 2.8 separately like Satya proposed ? The file cannot be changed as the Windows FileProtextion is enabled for them (as you already noticed). if you already tried to install the MDAC 2.8, did you get an error or did the install run through ? Did you restart the system afterwards ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I finally figured this out. It turns out that there were certain registry settings that were incorrectly set when SP4 was applied to SQL Server 2000. I don't want to get into the exact registry settings that need to be changed but that is where the answer lies.

Thanks to all for your assistance.

MDAC 2.7 Question

Hey Guy's,
I have a Windows 2003 Server (Standard Edition)
It also has SQL Server 2000 with Service Pack 3.
I am using this for testing my companies software compatability with Windows
2003.
Our software installs MDAC to work properly at the moment 2.7, but when our
installer runs it says cannot install as MDAC won't install it only supports
versions of Windows up to 2000...Is there a version available for 2003 yet?
Thanks,
Chris.
-mcpAFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available for download (yet). Why not
re-write the install program so it check for MDAC version, if lower than the your supported
level, you give an option to install. If higher than the tested (supported) level, well. In this
case, you quite simply need to test the sw on a machine with MDAC 2.8 (a W2K3 machine).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chris" <-@.-.com> wrote in message news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> Hey Guy's,
> I have a Windows 2003 Server (Standard Edition)
> It also has SQL Server 2000 with Service Pack 3.
> I am using this for testing my companies software compatability with Windows
> 2003.
> Our software installs MDAC to work properly at the moment 2.7, but when our
> installer runs it says cannot install as MDAC won't install it only supports
> versions of Windows up to 2000...Is there a version available for 2003 yet?
> Thanks,
> Chris.
> -mcp
>
>|||Can we get the MDAC mappings associated with the SPs of Windows and SQL =Server ? I've been searching for sometime for a site with this =consolidated information ...
-- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:eAOegWuRDHA.1552@.TK2MSFTNGP12.phx.gbl...
> AFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available for =download (yet). Why not
> re-write the install program so it check for MDAC version, if lower =than the your supported
> level, you give an option to install. If higher than the tested =(supported) level, well. In this
> case, you quite simply need to test the sw on a machine with MDAC 2.8 =(a W2K3 machine).
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at: =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "Chris" <-@.-.com> wrote in message =news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> > Hey Guy's,
> >
> > I have a Windows 2003 Server (Standard Edition)
> > It also has SQL Server 2000 with Service Pack 3.
> >
> > I am using this for testing my companies software compatability with =Windows
> > 2003.
> >
> > Our software installs MDAC to work properly at the moment 2.7, but =when our
> > installer runs it says cannot install as MDAC won't install it only =supports
> > versions of Windows up to 2000...Is there a version available for =2003 yet?
> >
> > Thanks,
> >
> > Chris.
> > -mcp
> >
> >
> >
> >|||I haven't searched for such site. Here's what I have checked/remember by heart:
W2K MDAC 2.5
W2K sp1 MDAC 2.5 sp1
W2K sp2 MDAC 2.5 sp2
SQL2K MDAC 2.6
XP MDAC 2.7
W2K3 MDAC 2.8
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Vinodk" <vinodk_sct@.hotmail.com> wrote in message
news:%23YDVQguRDHA.3700@.tk2msftngp13.phx.gbl...
Can we get the MDAC mappings associated with the SPs of Windows and SQL Server ? I've been
searching for sometime for a site with this consolidated information ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions
http://www32.brinkster.com/sqlvinod
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in message
news:eAOegWuRDHA.1552@.TK2MSFTNGP12.phx.gbl...
> AFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available for download (yet). Why not
> re-write the install program so it check for MDAC version, if lower than the your supported
> level, you give an option to install. If higher than the tested (supported) level, well. In
this
> case, you quite simply need to test the sw on a machine with MDAC 2.8 (a W2K3 machine).
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Chris" <-@.-.com> wrote in message news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> > Hey Guy's,
> >
> > I have a Windows 2003 Server (Standard Edition)
> > It also has SQL Server 2000 with Service Pack 3.
> >
> > I am using this for testing my companies software compatability with Windows
> > 2003.
> >
> > Our software installs MDAC to work properly at the moment 2.7, but when our
> > installer runs it says cannot install as MDAC won't install it only supports
> > versions of Windows up to 2000...Is there a version available for 2003 yet?
> >
> > Thanks,
> >
> > Chris.
> > -mcp
> >
> >
> >
>|||Cool Tibor ...
But I think you missed SQL SP3a ?
and thankx in advance ... :) ...
And just a twist to the whole thing is it possible to find the MDAC =version from ISQLW window? I know abt the version ... But this ... Hmmm =... I would be interested in knowing this also ... -- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:OB3mMmuRDHA.2236@.tk2msftngp13.phx.gbl...
> I haven't searched for such site. Here's what I have checked/remember =by heart:
> > W2K MDAC 2.5
> W2K sp1 MDAC 2.5 sp1
> W2K sp2 MDAC 2.5 sp2
> > SQL2K MDAC 2.6
> > XP MDAC 2.7
> W2K3 MDAC 2.8
> -- > Tibor Karaszi, SQL Server MVP
> Archive at: =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "Vinodk" <vinodk_sct@.hotmail.com> wrote in message
> news:%23YDVQguRDHA.3700@.tk2msftngp13.phx.gbl...
> Can we get the MDAC mappings associated with the SPs of Windows and =SQL Server ? I've been
> searching for sometime for a site with this consolidated information =...
> > -- > HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> SCT Software Solutions
> http://www32.brinkster.com/sqlvinod
> > > "Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message
> news:eAOegWuRDHA.1552@.TK2MSFTNGP12.phx.gbl...
> > AFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available =for download (yet). Why not
> > re-write the install program so it check for MDAC version, if lower =than the your supported
> > level, you give an option to install. If higher than the tested =(supported) level, well. In
> this
> > case, you quite simply need to test the sw on a machine with MDAC =2.8 (a W2K3 machine).
> >
> > -- > > Tibor Karaszi, SQL Server MVP
> > Archive at: =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> >
> >
> > "Chris" <-@.-.com> wrote in message =news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> > > Hey Guy's,
> > >
> > > I have a Windows 2003 Server (Standard Edition)
> > > It also has SQL Server 2000 with Service Pack 3.
> > >
> > > I am using this for testing my companies software compatability =with Windows
> > > 2003.
> > >
> > > Our software installs MDAC to work properly at the moment 2.7, but =when our
> > > installer runs it says cannot install as MDAC won't install it =only supports
> > > versions of Windows up to 2000...Is there a version available for =2003 yet?
> > >
> > > Thanks,
> > >
> > > Chris.
> > > -mcp
> > >
> > >
> > >
> >
> >
> >|||>> And just a twist to the whole thing is it possible to find the MDAC
version from ISQLW window?
http://www.aspfaq.com/2057 says:
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'|||Thankx Aaron ... :) ...
-- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message =news:#F3B$3uRDHA.2228@.tk2msftngp13.phx.gbl...
> >> And just a twist to the whole thing is it possible to find the MDAC
> version from ISQLW window?
> > http://www.aspfaq.com/2057 says:
> > EXEC master..xp_regread
> N'HKEY_LOCAL_MACHINE',
> N'Software\Microsoft\DataAccess',
> N'Version'
> >

MaxInsertCommitSize not found in SQL Server Destination

Hi,

I have installed SQL Server 2005 Service Pack 1 installed. I could see that from running @.@.Version command.

i am not able to find the MaxInsertCommitSize custom property in my sql server destination in SSIS packages.

is there anything specific i need to do to see that.

--

Mahadevan H

That property is not on the SQL Server Destination, it's on the OLE DB Destination.|||

Hi Jwelch,

thank you for your reply. But please refer the following URL from MSDN. It says it is the property of the SQL Destination.

http://msdn2.microsoft.com/en-us/library/ms135971.aspx#sqlserver

Regards

Mahadevan H

|||

h_mahadev wrote:

Hi Jwelch,

thank you for your reply. But please refer the following URL from MSDN. It says it is the property of the SQL Destination.

http://msdn2.microsoft.com/en-us/library/ms135971.aspx#sqlserver

Regards

Mahadevan H

The documentation is correct, it is there. I've pulled a SQL Server Destination into my dataflow, hit F4, and I can see the property in the properties pane.

I'm confused as to why you think it doesn't exist?

-Jamie

|||

Hi,

when i do the same thin i am not getting that property. I am wondering why.

Regards

Mahadevan H

|||

What service pack have you got installed. I am on SP1.

-Jamie

|||SP1 only.|||

h_mahadev wrote:

Hi Jwelch,

thank you for your reply. But please refer the following URL from MSDN. It says it is the property of the SQL Destination.

http://msdn2.microsoft.com/en-us/library/ms135971.aspx#sqlserver

Regards

Mahadevan H

Doh! You are absolutely correct. And, when I rechecked, it is showing up for me as well, just as Jamie mentioned.

If you right-clcik the task, choose Advanced Editor, go to the Component Properties tab, and look in the sction for Custom Properties, does it show up there?