SQLserver7 Build623

The message "Coinitialize has not been called" has plagued me since
starting with SQLserver. Usually when performing a copy operation
somewhere in the database.

However, now I'm trying to build views for a large database consisting
of many many tables. It was going along just fine, when I received
this message upon adding a table to a view at the New View UI. Then
it happened to every attempt following.

1) Any idea to what is the cause of this message suddenly appearing?

2) Is there any way to call Coinitialize other than restarting EM?

3) Is there a fix for this?

4) Am I the only one?

Thanks!

Mike


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Report this post to a moderator

By build 623 I presume you got this through SELECT @@version
This indicates you are still on RTM

Try SPing to SP4 and see if you get the same errors



--



Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



<mike> wrote in message news:vp8nuucgesa16r7suakv5thvc
drkumv2la@4ax.com...
> SQLserver7 Build623
>
> The message "Coinitialize has not been called" has plagued me since
> starting with SQLserver. Usually when performing a copy operation
> somewhere in the database.
>
> However, now I'm trying to build views for a large database consisting
> of many many tables. It was going along just fine, when I received
> this message upon adding a table to a view at the New View UI. Then
> it happened to every attempt following.
>
> 1) Any idea to what is the cause of this message suddenly appearing?
>
> 2) Is there any way to call Coinitialize other than restarting EM?
>
> 3) Is there a fix for this?
>
> 4) Am I the only one?
>
> Thanks!
>
> Mike
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Report this post to a moderator

For the record, I know this is known issue after doing a google
search.

But I see a lot of suggestions, but have not yet seen a reply that
something actually worked.

Also, some of the suggestions would only seem logical if this were a
consistent issue. But what is strange is that all will be going along
fine, and then the issue pops its head after doing something that I've
done over and over already. It just happens.

Has anyone found a solution that actually fixes this issue??

thx.


On Mon, 02 Dec 2002 10:19:13 -0800, mike <> wrote:

>SQLserver7 Build623
>
>The message "Coinitialize has not been called" has plagued me since
>starting with SQLserver. Usually when performing a copy operation
>somewhere in the database.
>
>However, now I'm trying to build views for a large database consisting
>of many many tables. It was going along just fine, when I received
>this message upon adding a table to a view at the New View UI. Then
>it happened to every attempt following.
>
>1) Any idea to what is the cause of this message suddenly appearing?
>
>2) Is there any way to call Coinitialize other than restarting EM?
>
>3) Is there a fix for this?
>
>4) Am I the only one?
>
>Thanks!
>
>Mike
>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Report this post to a moderator

I'm at this SP level only because two of my clients are still at this
level. I'm concerned that if I were to upgrade, and they don't ,
there will be issues if I were to hit or change their tables from my
dev pc (laptop).

Do you know if I can be running one SP level on my dev machine, and
still connect successfully to my clients systems running a different
SP level? I have no control over the SP level of my clents at this
point.

??

On Mon, 2 Dec 2002 18:27:48 -0000, "Allan Mitchell"
<allan@no-spam.SQLDTS.com> wrote:

>By build 623 I presume you got this through SELECT @@version
>This indicates you are still on RTM
>
>Try SPing to SP4 and see if you get the same errors



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Report this post to a moderator

Yes you can run different SP levels and still have connectivity. I would
urge your clients to SP their boxes. SQL Server 7 has been out for 3 1/2
years now and in that time features have been discovered and rectified by
SPs.


--



Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



<mike> wrote in message news:0o9nuu86lk3c0vfj3uj3dqso2
qf7sfl9bq@4ax.com...
> I'm at this SP level only because two of my clients are still at this
> level. I'm concerned that if I were to upgrade, and they don't ,
> there will be issues if I were to hit or change their tables from my
> dev pc (laptop).
>
> Do you know if I can be running one SP level on my dev machine, and
> still connect successfully to my clients systems running a different
> SP level? I have no control over the SP level of my clents at this
> point.
>
> ??
>
> On Mon, 2 Dec 2002 18:27:48 -0000, "Allan Mitchell"
> <allan@no-spam.SQLDTS.com> wrote:
>
> >By build 623 I presume you got this through SELECT @@version
> >This indicates you are still on RTM
> >
> >Try SPing to SP4 and see if you get the same errors
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Report this post to a moderator

Can I jump to the latest SP from base level, or is there a migration
path that needs to be followed?

I'll start searching for the link now...

thx.

On Mon, 2 Dec 2002 19:41:19 -0000, "Allan Mitchell"
<allan@no-spam.SQLDTS.com> wrote:

>Yes you can run different SP levels and still have connectivity. I would
>urge your clients to SP their boxes. SQL Server 7 has been out for 3 1/2
>years now and in that time features have been discovered and rectified by
>SPs.



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Report this post to a moderator

I am on SQLServer7 Build 1063 (which as far as I know is SP4) and I experience the same problem quite frequently. As of yet I am unable to find anything to fix this issue other than restarting EM, which is a big pain as this CoInitialize problem occurs quite freqently. The only suggestion I've received is "install SP4" which, assuming I have SP4 currently installed, doesn't seem to have worked. Not seeking any advice at the moment, just thought I'd post and say that this problem also seems to be occuring in SP4.

--
Tony

quote:

---

Originally posted by mike
SQLserver7 Build623

The message "Coinitialize has not been called" has plagued me since
starting with SQLserver. Usually when performing a copy operation
somewhere in the database.

However, now I'm trying to build views for a large database consisting
of many many tables. It was going along just fine, when I received
this message upon adding a table to a view at the New View UI. Then
it happened to every attempt following.

1) Any idea to what is the cause of this message suddenly appearing?

2) Is there any way to call Coinitialize other than restarting EM?

3) Is there a fix for this?

4) Am I the only one?

Thanks!

Mike


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

---

Report this post to a moderator

I'm on SQL Server 7 SP4 Build 2195

I have the problem. I cannot update to SQL 2000, business decision !

Has anyone found another solution by now ?

Report this post to a moderator