MAX and DATEDIFF: sp3

Showing posts with label sp3. Show all posts

Friday, March 30, 2012

Mdac Xp 2000

My Development machine is Win XP Pro.
I have MDAC 2.7, Visual Studio 6.0 SP3 Installed.

I am running into some issues where a vb program i wrote runs perfectly fine (Using ADO) when connecting to sql server but only runs fine on half of the windows 2000 machines i tested on.

Anyone have any suggestions? even stranger is that the versions of the odbc driver on the 2000 box are newer than the versions on my xp box with MDAC 2.7 SP1 installed.

All machines have DSN's set up exactly the same. I even tested with a DSN'less connection just to be sure (same result).Refer to event viewer logs for any kind of information in this regard.

MDAC Upgrade

Please advice.
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
--
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> >--Original Message--
> >SQL Server 2000 Service Pack 3a comes with MDAC 2.7
> Service Pack 1a, so the
> >best way is to install the SQL Server Service Pack.
> >
> >--
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> >> Please advice.
> >>
> >> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
> MDAC
> >> 2.6 SP1.
> >> I would like to upgrade this to MDAC 2.7. Can I simply
> >> run the MDAC 2.7 update or what is the Microsoft way to
> >> do this.
> >>
> >> Help Appreciated.
> >
> >
> >.
> >

MDAC Upgrade

Wednesday, March 28, 2012

MDAC 2.8 and SQL 2000 SP3 in Windows 2000 SP3?

Is that OK? Any gotchas? Thanks.
--
George Hester
__________________________________Shawn,
We have some applications that can not use too high MDAC versions.
According to http://support.microsoft.com/default.aspx?scid=kb;en-us;823718,
there is a patch fixing the same security hole as 2.8 does. However, it
does not say explicitly whether it is just a fix without enhancing the MDAC
version, or it brings MDAC to version 2.8. Can you -- or someone else --
verify? Thanks.
Quentin
"Shawn Aebi [MSFT]" <shawna@.online.microsoft.com> wrote in message
news:atyhMB$aDHA.2408@.cpmsftngxa06.phx.gbl...
> We encourage people to read the following article before upgrading to MDAC
> 2.8
> http://support.microsoft.com/default.aspx?scid=kb;en-us;820761
> A substantial amount of security work went into MDAC 2.8 which affected
> some behavioral conditions.
> Shawn Aebi
> Microsoft
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

Monday, March 26, 2012

MDAC 2.71 Memory Leak

Hi everyone,
I understand SQL Server 2000 SP3 contains an MDAC 2.71
version that causes Memory Leak. However, If I install
MDAC 2.71 through Windows Update, would the server suffer
from Memory Leak also?
I have an SQL 2000 server running on Win 2K. My server
was never installed SP3. But, I did update MDAC 2.7
version via Windows Update. Few months later, my server
now is experiencing Memory Leak. When I run MDAC component
checker, there does have mismatches of MDAC 2.7 SP1 or 2.7
XP SP1. I wonder how do I fix that? I don't really want
to install SP3a. Would install the latest version of MDAC
(2.71a) fix the problem?
Thank you very very very much!!
AnnieHave you looked at the date and time stamp related to the
MDAC installation ? Is this on a dual or higher processor
server ? I am researching the same but on multiple
processor problem with the MDAC.
Bruce
>--Original Message--
>Hi everyone,
> I understand SQL Server 2000 SP3 contains an MDAC 2.71
>version that causes Memory Leak. However, If I install
>MDAC 2.71 through Windows Update, would the server suffer
>from Memory Leak also?
> I have an SQL 2000 server running on Win 2K. My server
>was never installed SP3. But, I did update MDAC 2.7
>version via Windows Update. Few months later, my server
>now is experiencing Memory Leak. When I run MDAC
component
>checker, there does have mismatches of MDAC 2.7 SP1 or
2.7
>XP SP1. I wonder how do I fix that? I don't really want
>to install SP3a. Would install the latest version of MDAC
>(2.71a) fix the problem?
>Thank you very very very much!!
>Annie
>.
>|||Mine is Dual processor.
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
There is another MDAC version came out call MDAC 2.71
Refresh. The difference between MDAC 2.71 and 2.71
Refresh is mdac_typ.exe file posted on MS website.
But, I don't know what files does this mdac_typ.exe
alter.
What's your problem?
Annie
>--Original Message--
>Have you looked at the date and time stamp related to the
>MDAC installation ? Is this on a dual or higher processor
>server ? I am researching the same but on multiple
>processor problem with the MDAC.
>Bruce
>>--Original Message--
>>Hi everyone,
>> I understand SQL Server 2000 SP3 contains an MDAC 2.71
>>version that causes Memory Leak. However, If I install
>>MDAC 2.71 through Windows Update, would the server
suffer
>>from Memory Leak also?
>> I have an SQL 2000 server running on Win 2K. My
server
>>was never installed SP3. But, I did update MDAC 2.7
>>version via Windows Update. Few months later, my server
>>now is experiencing Memory Leak. When I run MDAC
>component
>>checker, there does have mismatches of MDAC 2.7 SP1 or
>2.7
>>XP SP1. I wonder how do I fix that? I don't really
want
>>to install SP3a. Would install the latest version of
MDAC
>>(2.71a) fix the problem?
>>Thank you very very very much!!
>>Annie
>>.
>.
>

MDAC

What version of MDAC does a client pc need to have to
access SQL Server 2000 SP3a, on a Windows 2000 SP3
server. MDAC 2.7 SP1?
What is recommended as a procedure to make sure this
version is rollout to users? How should that work'
What version comes with Windows XP?
Thanks,
JimVersions of MDAC earlier that MDAC 2.7 SP1 can access SQL Server 2000 SP3.
I am not aware of a version of MDAC that will not access SQL Server 2000
SP3. You would not have the ability to use the new features of SQL Server
2000 but still would have access.
Windows XP ships with MDAC 2.7.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||So earlier version of MDAC are ok. Later versions than
what's installed on the SQL box you run the risk of not
being able to access all of the functionality on the SQL
Server.
Great. Thanks.
>--Original Message--
>Versions of MDAC earlier that MDAC 2.7 SP1 can access
SQL Server 2000 SP3.
>I am not aware of a version of MDAC that will not access
SQL Server 2000
>SP3. You would not have the ability to use the new
features of SQL Server
>2000 but still would have access.
>Windows XP ships with MDAC 2.7.
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>

Wednesday, March 21, 2012

MBSA and MSXML 2.6

Dear All,
MBSA is saying that I currently have MSXML 2.6 SP2, and that I should
upgrade to SP3. When I did a search on the net, not only is SP3 not
publicly available, it is also included in MS SQL 2000 SP3 that I
already have installed.
How come I am still getting these errors from MBSA despite my servers
having MS SQL 2000 SP3 installed?
Is there a way to manually check my version of MSXML 2.6?
Has anyone had a similar problem?
Thanks.
Aramid"Aramid" <aramid@.hotmail.com> wrote in message
news:63drc112j512d4dntnt2t5q3butk2v51h3@.
4ax.com...
> Dear All,
> MBSA is saying that I currently have MSXML 2.6 SP2, and that I should
> upgrade to SP3. When I did a search on the net, not only is SP3 not
> publicly available, it is also included in MS SQL 2000 SP3 that I
> already have installed.
> How come I am still getting these errors from MBSA despite my servers
> having MS SQL 2000 SP3 installed?
> Is there a way to manually check my version of MSXML 2.6?
This may seem funny but it's no joke: the only KB article I could find, for
checking the XML version called by IE was to get filemon.exe from the
SysInternals.com site, open an XML file with IE, locate the reference to
msxml?.dll in filemon output, and get its properties to check its version.
Here's the article, it's a scream:
http://support.microsoft.com/defaul...kb;en-us;296647
This one is also an interesting read, and it contains links to the how-to
for upgrading your installed parser:
http://support.microsoft.com/defaul...kb;en-us;269238
-Mark

> Has anyone had a similar problem?
> Thanks.
> Aramid

Monday, March 19, 2012

Maximum size of table?

SQL20 Ent SP3 WIN2K Adv SP3
I'm hoping for some guidance here.
I've a single table with 184,000,000 rows, I think this is probably
a good candidate for some kind of partitioning.
My question is, how many rows would constitute a decent sized
table, before partitioning?
I know it's a very subjective question and depends on row size
database size and others, but any opinions would be most welcome.It's more on what you do with the data and how you access it. Explain a
little of how you access this table and we can give a better answer.
--
Andrew J. Kelly
SQL Server MVP
"Stressed" <k@.c.co.uk> wrote in message
news:uIKG5g7SDHA.2248@.TK2MSFTNGP11.phx.gbl...
> SQL20 Ent SP3 WIN2K Adv SP3
> I'm hoping for some guidance here.
> I've a single table with 184,000,000 rows, I think this is probably
> a good candidate for some kind of partitioning.
> My question is, how many rows would constitute a decent sized
> table, before partitioning?
> I know it's a very subjective question and depends on row size
> database size and others, but any opinions would be most welcome.
>|||Sorry,
In addition to the previous, Data Junction is used to load the data, query
analyzer is used by our analysts to query the data.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ehcR3u7SDHA.2148@.TK2MSFTNGP11.phx.gbl...
> It's more on what you do with the data and how you access it. Explain a
> little of how you access this table and we can give a better answer.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Stressed" <k@.c.co.uk> wrote in message
> news:uIKG5g7SDHA.2248@.TK2MSFTNGP11.phx.gbl...
> > SQL20 Ent SP3 WIN2K Adv SP3
> >
> > I'm hoping for some guidance here.
> >
> > I've a single table with 184,000,000 rows, I think this is probably
> > a good candidate for some kind of partitioning.
> >
> > My question is, how many rows would constitute a decent sized
> > table, before partitioning?
> >
> > I know it's a very subjective question and depends on row size
> > database size and others, but any opinions would be most welcome.
> >
> >
>|||When you do these updates right after you import the data does it involve
any of the previous rows or just the new ones? How about the subsets, are
they created only from the new data? Sounds like you work mainly with
blocks of data, maybe by date. If that's true then you may consider
partitioning the data by date (weeks, Month, quarter etc) so it's easier to
work with only the relevant data. If you do keep it in a single table then
make sure you have a clustered index on the column(s) that will allow you to
differentiate the current data. Otherwise you may be scanning the entire
table over and over for these updates and queries.
--
Andrew J. Kelly
SQL Server MVP
"Stressed" <k@.c.co.uk> wrote in message
news:uaxCE27SDHA.1556@.TK2MSFTNGP10.phx.gbl...
> Thanks for taking the time to reply.
> Table is used in a warehousing type environment. Initially a bulk load,
> then incremental loads, approx once a month. Once the load has taken
> place a series of updates are performed, following that, the table is
> used to create subsets of data in another database, for shipping to our
> client sites for review.
> In short, much loading, some updating, much querying.
> I hope this gives a reasonable insight.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:ehcR3u7SDHA.2148@.TK2MSFTNGP11.phx.gbl...
> > It's more on what you do with the data and how you access it. Explain a
> > little of how you access this table and we can give a better answer.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Stressed" <k@.c.co.uk> wrote in message
> > news:uIKG5g7SDHA.2248@.TK2MSFTNGP11.phx.gbl...
> > > SQL20 Ent SP3 WIN2K Adv SP3
> > >
> > > I'm hoping for some guidance here.
> > >
> > > I've a single table with 184,000,000 rows, I think this is probably
> > > a good candidate for some kind of partitioning.
> > >
> > > My question is, how many rows would constitute a decent sized
> > > table, before partitioning?
> > >
> > > I know it's a very subjective question and depends on row size
> > > database size and others, but any opinions would be most welcome.
> > >
> > >
> >
> >
>

Friday, March 30, 2012

Mdac Xp 2000

MDAC Upgrade

MDAC Upgrade

Wednesday, March 28, 2012

MDAC 2.8 and SQL 2000 SP3 in Windows 2000 SP3?

Monday, March 26, 2012

MDAC 2.71 Memory Leak

MDAC

Wednesday, March 21, 2012

MBSA and MSXML 2.6

Monday, March 19, 2012

Maximum size of table?

MAX and DATEDIFF

Blog Archive

About Me