Problem with SQL Mail and Oulook 2003

Here try this. Outlook 2003 and SQL 2000 SP3.
Open Outlook 2003. Then go to SQL Server Manager and browse to where the
settings are for SQL Mail. Make sure the MAPI profile you choose there is
the MAPI profile you used to sign into Outlook 2003. Then Test the SQL Mail
by clicking Test. You should get a MAPI session was initialized. Then
close out of SQL Server Manager. Bring up Outlook 2003 and close it. Now
try to start Outlook 2003. You will get an error that the Outlook folders
could not be initialized and Outlook 2003 will shut down. The only way to
fix this is to stop the MSSQL services. Then you will be able to open
Outlook 2003.
--
George Hester
_________________________________> The only way to
> fix this is to stop the MSSQL services. Then you will be able to open
> Outlook 2003.
Or to use a different profile.
Or to not use a SQL Server machine for reading client e-mail (is it a
server, or a desktop? you need to pick one...).
Or to use a different solution for e-mail within SQL Server (e.g. avoid MAPI
altogether).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Or to fix the SQL Mail so that it releases the MAPI session when it =finishes? Doesn't that sound like a reasonable expectation?
-- George Hester
__________________________________
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message =news:ebcRGeM2DHA.2208@.TK2MSFTNGP12.phx.gbl...
> > The only way to
> > fix this is to stop the MSSQL services. Then you will be able to =open
> > Outlook 2003.
> > Or to use a different profile.
> > Or to not use a SQL Server machine for reading client e-mail (is it a
> server, or a desktop? you need to pick one...).
> > Or to use a different solution for e-mail within SQL Server (e.g. =avoid MAPI
> altogether).
> > -- > Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
> >|||>> Or to fix the SQL Mail so that it releases the MAPI session when it
finishes? Doesn't that sound like a reasonable expectation?
A little more work involved there, than the changes I proposed to your
strategy (seeing as this clearly doesn't affect a large number of
customers).
Frankly, I'd rather they focus their attention on Yukon than tending to
onesy-twosy "bugs" where people aren't using the software as intended
anyway...
A|||Oh well I suppose I am the only person in the world who thinks it would be a
good idea for SQL Mail to release the MAPI session when it finishes. Too
bad huh?
--
George Hester
_________________________________
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:esQrocV2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> >> Or to fix the SQL Mail so that it releases the MAPI session when it
> finishes? Doesn't that sound like a reasonable expectation?
> A little more work involved there, than the changes I proposed to your
> strategy (seeing as this clearly doesn't affect a large number of
> customers).
> Frankly, I'd rather they focus their attention on Yukon than tending to
> onesy-twosy "bugs" where people aren't using the software as intended
> anyway...
> A
>sql

Problem with regional settings I think

I have a developer server (which we run ASP.NEt solutions against) it's an
MSDE instance and then we have another "LIVE" server which also has an MSDE
instance.
We are using Crystal Reports to get Reports out of the Databases and the
reports look different when we run them against the servers.
A Total ( in the report) on our Develooper Server shows as 2,00 in the
report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
something to do with how the MSDE is returning numbers (floats) and Thousand
Separators...
Where do I start to check for these things?
Best regards/
Lars NetzelIt's not the thousands separator. It's the decimal point. In Europe,
you'll see the comma used to mark the decimal point. I'd check the regional
settings on both those boxes.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Lars Netzel" <nospam@.doamin.com> wrote in message
news:eW7o2AGBFHA.2428@.TK2MSFTNGP14.phx.gbl...
I have a developer server (which we run ASP.NEt solutions against) it's an
MSDE instance and then we have another "LIVE" server which also has an MSDE
instance.
We are using Crystal Reports to get Reports out of the Databases and the
reports look different when we run them against the servers.
A Total ( in the report) on our Develooper Server shows as 2,00 in the
report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
something to do with how the MSDE is returning numbers (floats) and Thousand
Separators...
Where do I start to check for these things?
Best regards/
Lars Netzel|||I have checked the regional settings in the Windows OS on both Servers..
they are identical (Swedish Settings) I'm wondering if there are any
regional settings in teh SQL server itself... and if so where do I find
that?
/Lars
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23qxBgiGBFHA.2540@.TK2MSFTNGP09.phx.gbl...
> It's not the thousands separator. It's the decimal point. In Europe,
> you'll see the comma used to mark the decimal point. I'd check the
> regional
> settings on both those boxes.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Lars Netzel" <nospam@.doamin.com> wrote in message
> news:eW7o2AGBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> I have a developer server (which we run ASP.NEt solutions against) it's an
> MSDE instance and then we have another "LIVE" server which also has an
> MSDE
> instance.
> We are using Crystal Reports to get Reports out of the Databases and the
> reports look different when we run them against the servers.
> A Total ( in the report) on our Develooper Server shows as 2,00 in the
> report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
> something to do with how the MSDE is returning numbers (floats) and
> Thousand
> Separators...
> Where do I start to check for these things?
> Best regards/
> Lars Netzel
>
>|||Did you try changing to, say, US? Also, if the SQL Server service is
running on a domain account, log on with that account and check its
settings.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Lars Netzel" <nospam@.doamin.com> wrote in message
news:%23ABo9rGBFHA.3512@.TK2MSFTNGP10.phx.gbl...
I have checked the regional settings in the Windows OS on both Servers..
they are identical (Swedish Settings) I'm wondering if there are any
regional settings in teh SQL server itself... and if so where do I find
that?
/Lars
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23qxBgiGBFHA.2540@.TK2MSFTNGP09.phx.gbl...
> It's not the thousands separator. It's the decimal point. In Europe,
> you'll see the comma used to mark the decimal point. I'd check the
> regional
> settings on both those boxes.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Lars Netzel" <nospam@.doamin.com> wrote in message
> news:eW7o2AGBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> I have a developer server (which we run ASP.NEt solutions against) it's an
> MSDE instance and then we have another "LIVE" server which also has an
> MSDE
> instance.
> We are using Crystal Reports to get Reports out of the Databases and the
> reports look different when we run them against the servers.
> A Total ( in the report) on our Develooper Server shows as 2,00 in the
> report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
> something to do with how the MSDE is returning numbers (floats) and
> Thousand
> Separators...
> Where do I start to check for these things?
> Best regards/
> Lars Netzel
>
>