May 5, 2010 at 11:26 am
OS is Windows server 2003. We need to upgrade outlook2000 to 2007 We have SQL2000 (some day we will get 2005) on the server and I would like to know of any issues upgrading outlook straight from 2000 to 2007 and it being able to interface with SQL2000
Thank you
May 6, 2010 at 4:32 am
I was under the impression that Outlook generally communicated with Exchange and not SQL?
/Rasmus
May 6, 2010 at 12:16 pm
First question: Why do you have Office products running on your server?
Second question: Be more specific...what you are using Outlook for with regards to SQL Server?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 6, 2010 at 12:54 pm
MeltonDBA (5/6/2010)
First question: Why do you have Office products running on your server?Second question: Be more specific...what you are using Outlook for with regards to SQL Server?
SQL 7 and SQL 2000 required a MAPI compliant email client (read full Outlook) in order to use the built in email sending abilities. It was a very common build to include putting Outlook on SQL servers.
Basically, SQL used the MAPI profile to send mail. SQL did not know the term SMTP until 2005.
That being said, I don't the the answer to the OP's question. But logic would dictate they they woul likely work.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
May 6, 2010 at 1:05 pm
Not fully sure if it will work. MS recommend using Outlook 2000 for a few bug fixes when using a MAPI client - even for SQL 2005.
I think the best bet would be to setup a test sandbox and try it out.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 1:42 pm
As well this should be in the SQL Server 2000 SCC forum, not 2008 😀
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 6, 2010 at 1:45 pm
This article[/url] indicates that the bug with SQL Server 2000 that required the Outlook client to be installed for the missing dll's was corrected with Service Pack 1.
It's been years since I've used SQL 2000 but I know I was sending mail without an Outlook client. Hopefully you can figure out how to fix your server to avoid this dependency altogether.
May 6, 2010 at 1:47 pm
bteraberry (5/6/2010)
This article[/url] indicates that the bug with SQL Server 2000 that required the Outlook client to be installed for the missing dll's was corrected with Service Pack 1.It's been years since I've used SQL 2000 but I know I was sending mail without an Outlook client. Hopefully you can figure out how to fix your server to avoid this dependency altogether.
The way around it is the is a DLL/XP that just uses SMTP, but I have not used it in years and don't remember many details.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply