For the FAQ: Requirements to run Emerald on clients with non-US data
formats and US-Version on Server:
Client:
1. SQL client with latest service pack (Version >= 6.50.252)
2. Client config / 'UseInternational Settings' must be checked
Server:
1. If SQL server is not localized, local language (i.e. 'Deutsch') needs
to be installed from SQL-setup. (*.loc files from CD or MSDN)
2. Create a login account with the correct local language for
Emerald-login. If running SQL in mixed/integrated security mode, have
the Emerald users mapped to this account.
cu, Peter
> -----Original Message-----
> From: Peter A. Sang [SMTP:pesa@sang.de]
> Sent: Monday, May 18, 1998 11:04 AM
> To: 'Dale E. Reed Jr.'
> Cc: 'emerald-beta@iea-software.com'
> Subject: Bugs in Emerald 2.5.67 [RE: Error 13 'Types
> incompatible']
>
[....]
> **********************************************************************
> **
> ******************************************************
> Bug#2
> Select The TimeOn Tab and click 'update': Error in SQL statement.
>
> Manually executing the query:
>
> Select Start=DateAdd(Second, (0-AcctSessionTime-AcctDelayTime),
> CallDate), (AcctSessionTime/60)+1, (AcctInputOctets/1000)+1,
> (AcctOutputOctets/1000)+1, Location, UserName, AcctTerminateCause,
> Server, NASPort, ConnectInfo From Calls, Servers Where
> (Username='rmohneck') and CallDate >= '30.04.98' and CallDate <=
> '30.05.98' and AcctStatusType=2 and NASIdentifier=IPAddress Order
> by
> Start
>
> results in (GERMAN SQL client against US SQL server)
>
> Msg 296, Level 16, State 3
> The conversion of CHAR to SMALLDATETIME resulted in a SMALLDATETIME
> value out of range.
> Msg 296, Level 16, State 3
> The conversion of CHAR to SMALLDATETIME resulted in a SMALLDATETIME
> value out of range.
>
> Changin the above query to US date format gives the correct results!
>
> Start
> Location
> UserName AcctTerminateCause Server
> NASPort ConnectInfo
> --------------------------- ----------- ----------- -----------
> --------------- -------------------------------- ------------------
> ------------------------- ----------- --------------------------------
>
> 30 Apr 1998 12:43 26 22 2111
> PortMaster3 rmohneck 1
> PM3
> 2 14400 MNP/NONE
> 30 Apr 1998 20:34 25 78 592
> PortMaster3 rmohneck 1
> PM3
> 2 14400 MNP/NONE
> 1 Mai 1998 13:29 8 44 289
> PortMaster3 rmohneck 1
> PM3
> 0 14400 MNP/NONE
> [.....]
>
> I setup a GERMAN SQL server and tried your original query, if it's
> directed against a german server, it works! So this is dependent on
> the
> SERVER and NOT a client issue!!!
>
> Results #2 (GERMAN SQL client against GERMAN SQL server)
>
> Start
> Location
> UserName AcctTerminateCause Server
> NASPort ConnectInfo
> --------------------------- ----------- ----------- -----------
> --------------- -------------------------------- ------------------
> ------------------------- ----------- --------------------------------
>
> 30.04.98 12:43 26 22 2111
> PortMaster3 rmohneck 1
> PM3
> 2 14400 MNP/NONE
> 30.04.98 20:34 25 78 592
> PortMaster3 rmohneck 1
> PM3
> 2 14400 MNP/NONE
> 01.05.98 13:29 8 44 289
> PortMaster3 rmohneck 1
> PM3
> 0 14400 MNP/NONE
> [...]
>
> NOTE THE DIFFERENT DATE FORMATS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> Please have a look at
> http://support.microsoft.com/support/kb/articles/q173/9/07.asp
> regarding
> this issue ! Maybe it would be best to have Emerald use the ISO
> format???
>
> Thats enough for today ;)
>
> cu, Peter
>
>
> > -----Original Message-----
> > From: Dale E. Reed Jr. [SMTP:daler@iea-software.com]
> > Sent: Monday, May 18, 1998 9:20 AM
> > To: pesa@sang.de
> > Subject: Re: Delivery failure (emerald-beta@iea-software.com)
> >
> > postmaster@iea-software.com wrote:
> > >
> > > 1st problem: whenever I try to edit a subaccount, I get a 'Emerald
> > error
> > > 13: Types incompatible'.
> >
> > I attached to your SQL Server and it all works. What kind of SQL
> > client are you usign (German or english) and what is your reginal
> > settings for date and numeric/currency? I'm using a US engligh
> > setting and client here.
> >
> >