Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts

Tuesday, March 27, 2012

collation or local sensitive settings or other configuration properties

I installed the samples and tutoriales on the same server as SQL Server 2005 and VS 2005 Team Suite.

Living in Belgium, the local settings are:

language = Duch (Belgium)

code page = 850

e.g. in the database samples (AdventureWorks database – AdventureWorks Warehouse database)

my date notation is: 26-12-2005

my number notation is: 1,0013016921998599

all demo samples and tutorials are developed using

language = English (United States)

code page 1252

e.g. in SampleCurrencyData.txt

the date notation is: 12/26/2005 00:00:00

the number notation is: 1.0013016921998599

I do not have any problems to test the diferent services (Data Base Engine Services, Analysis Services, reporting & notifications services ..) but I do not succeed to deploy any samples of integration services !

e.g. for Integration Services Tutorial - lesson 1: “Creating the Project and Basic Package”

there are no error messages, 1097 rows are processed

but, checking the result in the database, no data is updated in the FactCurrencyRate table of the AdventureWorksDW database !

Why?

- is the problem related to the local language settings? how to solve this?

- what is the influence of the code page ? is there any compatibility between 1252 and 850 as code page?

- Server collation (e.g. Latin_1_General_CI_AS) is reported as key for the Unicode notation for character strings but what about notation of numbers?

- when to use float data type DT_R4 or DT_R8?

- I have remarked that the DT_DBTimeStamp is undependent from the source time notation – Is this correct?

- what is the difference between DT_Date and DT_DBDate or DT_DBTime, or DT_DBTimeStamp?

- Is Integration Services dependant of the local settings of the database engine?

- how to set / modify additional regional properties in a SSIS and SSRS package?

- how to change the default setting of the Flat File Connection Manager [starting the wizard, the local setting for the language – Dutch appears and this is OK for me but as codepage appears 1252 (ANSI Latin) and this is not OK as my server code page = 850]?

- how to work with e.g. US based data as source and Belgium settings for reports?

I am also struggling with trying to get the SSIS tutorials to work because of the text files having the dates in MM/DD/YYYY format while my local setting expects DD/MM/YYYY (English - New Zealand)

What needs to be done so that the Integration Services tutorials work in countries other than the USA?

|||

OK, got it - the answer is simple...

In the data source definition of the flat file containing the currency data, specify the locale as English(USA).

I suspect there are many users who follow the tutorial instructions to the letter and the instructions do not mention the locale setting - OK if you are in the USA.

|||

I

I have the same issue

My

Locale: Russian(Russia)

Code Page: 1251 (ANSI - кириллица)

Changing it, as you wrote it, to

Locale: English(United States)

does not correct this problem but just invokes more problems!!!!!


I aslo tried
ETL Package Problem
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=603488&SiteID=1


No luck either!

|||OK, I installed just one more instance with default English(US) language and

voilà .. everything started to work...
So, the conclusion is that in order to use SSIS I should migrate everything to a new instance with English(US)!? since default language/collation cannot be reset

I'd like to hear any better solution

|||

Another solution:

on http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

you find database for case-sensitive collation and case-insensitive collation, a attached the other database and now works.

|||

This link tells that samples download had moved to codeplex

And codeplex has hundreds of samples

Which one?

collation or local sensitive settings or other configuration properties

I installed the samples and tutoriales on the same server as SQL Server 2005 and VS 2005 Team Suite.

Living in Belgium, the local settings are:

language = Duch (Belgium)

code page = 850

e.g. in the database samples (AdventureWorks database – AdventureWorks Warehouse database)

my date notation is: 26-12-2005

my number notation is: 1,0013016921998599

all demo samples and tutorials are developed using

language = English (United States)

code page 1252

e.g. in SampleCurrencyData.txt

the date notation is: 12/26/2005 00:00:00

the number notation is: 1.0013016921998599

I do not have any problems to test the diferent services (Data Base Engine Services, Analysis Services, reporting & notifications services ..) but I do not succeed to deploy any samples of integration services !

e.g. for Integration Services Tutorial - lesson 1: “Creating the Project and Basic Package”

there are no error messages, 1097 rows are processed

but, checking the result in the database, no data is updated in the FactCurrencyRate table of the AdventureWorksDW database !

Why?

- is the problem related to the local language settings? how to solve this?

- what is the influence of the code page ? is there any compatibility between 1252 and 850 as code page?

- Server collation (e.g. Latin_1_General_CI_AS) is reported as key for the Unicode notation for character strings but what about notation of numbers?

- when to use float data type DT_R4 or DT_R8?

- I have remarked that the DT_DBTimeStamp is undependent from the source time notation – Is this correct?

- what is the difference between DT_Date and DT_DBDate or DT_DBTime, or DT_DBTimeStamp?

- Is Integration Services dependant of the local settings of the database engine?

- how to set / modify additional regional properties in a SSIS and SSRS package?

- how to change the default setting of the Flat File Connection Manager [starting the wizard, the local setting for the language – Dutch appears and this is OK for me but as codepage appears 1252 (ANSI Latin) and this is not OK as my server code page = 850]?

- how to work with e.g. US based data as source and Belgium settings for reports?

I am also struggling with trying to get the SSIS tutorials to work because of the text files having the dates in MM/DD/YYYY format while my local setting expects DD/MM/YYYY (English - New Zealand)

What needs to be done so that the Integration Services tutorials work in countries other than the USA?

|||

OK, got it - the answer is simple...

In the data source definition of the flat file containing the currency data, specify the locale as English(USA).

I suspect there are many users who follow the tutorial instructions to the letter and the instructions do not mention the locale setting - OK if you are in the USA.

|||

I

I have the same issue

My

Locale: Russian(Russia)

Code Page: 1251 (ANSI - кириллица)

Changing it, as you wrote it, to

Locale: English(United States)

does not correct this problem but just invokes more problems!!!!!


I aslo tried
ETL Package Problem
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=603488&SiteID=1


No luck either!

|||OK, I installed just one more instance with default English(US) language and

voilà .. everything started to work...
So, the conclusion is that in order to use SSIS I should migrate everything to a new instance with English(US)!? since default language/collation cannot be reset

I'd like to hear any better solution

|||

Another solution:

on http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

you find database for case-sensitive collation and case-insensitive collation, a attached the other database and now works.

|||

This link tells that samples download had moved to codeplex

And codeplex has hundreds of samples

Which one?

collation or local sensitive settings or other configuration properties

I installed the samples and tutoriales on the same server as SQL Server 2005 and VS 2005 Team Suite.

Living in Belgium, the local settings are:

language = Duch (Belgium)

code page = 850

e.g. in the database samples (AdventureWorks database – AdventureWorks Warehouse database)

my date notation is: 26-12-2005

my number notation is: 1,0013016921998599

all demo samples and tutorials are developed using

language = English (United States)

code page 1252

e.g. in SampleCurrencyData.txt

the date notation is: 12/26/2005 00:00:00

the number notation is: 1.0013016921998599

I do not have any problems to test the diferent services (Data Base Engine Services, Analysis Services, reporting & notifications services ..) but I do not succeed to deploy any samples of integration services !

e.g. for Integration Services Tutorial - lesson 1: “Creating the Project and Basic Package”

there are no error messages, 1097 rows are processed

but, checking the result in the database, no data is updated in the FactCurrencyRate table of the AdventureWorksDW database !

Why?

- is the problem related to the local language settings? how to solve this?

- what is the influence of the code page ? is there any compatibility between 1252 and 850 as code page?

- Server collation (e.g. Latin_1_General_CI_AS) is reported as key for the Unicode notation for character strings but what about notation of numbers?

- when to use float data type DT_R4 or DT_R8?

- I have remarked that the DT_DBTimeStamp is undependent from the source time notation – Is this correct?

- what is the difference between DT_Date and DT_DBDate or DT_DBTime, or DT_DBTimeStamp?

- Is Integration Services dependant of the local settings of the database engine?

- how to set / modify additional regional properties in a SSIS and SSRS package?

- how to change the default setting of the Flat File Connection Manager [starting the wizard, the local setting for the language – Dutch appears and this is OK for me but as codepage appears 1252 (ANSI Latin) and this is not OK as my server code page = 850]?

- how to work with e.g. US based data as source and Belgium settings for reports?

I am also struggling with trying to get the SSIS tutorials to work because of the text files having the dates in MM/DD/YYYY format while my local setting expects DD/MM/YYYY (English - New Zealand)

What needs to be done so that the Integration Services tutorials work in countries other than the USA?

|||

OK, got it - the answer is simple...

In the data source definition of the flat file containing the currency data, specify the locale as English(USA).

I suspect there are many users who follow the tutorial instructions to the letter and the instructions do not mention the locale setting - OK if you are in the USA.

|||

I

I have the same issue

My

Locale: Russian(Russia)

Code Page: 1251 (ANSI - кириллица)

Changing it, as you wrote it, to

Locale: English(United States)

does not correct this problem but just invokes more problems!!!!!


I aslo tried
ETL Package Problem
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=603488&SiteID=1


No luck either!

|||OK, I installed just one more instance with default English(US) language and

voilà .. everything started to work...
So, the conclusion is that in order to use SSIS I should migrate everything to a new instance with English(US)!? since default language/collation cannot be reset

I'd like to hear any better solution

|||

Another solution:

on http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

you find database for case-sensitive collation and case-insensitive collation, a attached the other database and now works.

|||

This link tells that samples download had moved to codeplex

And codeplex has hundreds of samples

Which one?

collation or local sensitive settings or other configuration properties

I installed the samples and tutoriales on the same server as SQL Server 2005 and VS 2005 Team Suite.

Living in Belgium, the local settings are:

language = Duch (Belgium)

code page = 850

e.g. in the database samples (AdventureWorks database – AdventureWorks Warehouse database)

my date notation is: 26-12-2005

my number notation is: 1,0013016921998599

all demo samples and tutorials are developed using

language = English (United States)

code page 1252

e.g. in SampleCurrencyData.txt

the date notation is: 12/26/2005 00:00:00

the number notation is: 1.0013016921998599

I do not have any problems to test the diferent services (Data Base Engine Services, Analysis Services, reporting & notifications services ..) but I do not succeed to deploy any samples of integration services !

e.g. for Integration Services Tutorial - lesson 1: “Creating the Project and Basic Package”

there are no error messages, 1097 rows are processed

but, checking the result in the database, no data is updated in the FactCurrencyRate table of the AdventureWorksDW database !

Why?

- is the problem related to the local language settings? how to solve this?

- what is the influence of the code page ? is there any compatibility between 1252 and 850 as code page?

- Server collation (e.g. Latin_1_General_CI_AS) is reported as key for the Unicode notation for character strings but what about notation of numbers?

- when to use float data type DT_R4 or DT_R8?

- I have remarked that the DT_DBTimeStamp is undependent from the source time notation – Is this correct?

- what is the difference between DT_Date and DT_DBDate or DT_DBTime, or DT_DBTimeStamp?

- Is Integration Services dependant of the local settings of the database engine?

- how to set / modify additional regional properties in a SSIS and SSRS package?

- how to change the default setting of the Flat File Connection Manager [starting the wizard, the local setting for the language – Dutch appears and this is OK for me but as codepage appears 1252 (ANSI Latin) and this is not OK as my server code page = 850]?

- how to work with e.g. US based data as source and Belgium settings for reports?

I am also struggling with trying to get the SSIS tutorials to work because of the text files having the dates in MM/DD/YYYY format while my local setting expects DD/MM/YYYY (English - New Zealand)

What needs to be done so that the Integration Services tutorials work in countries other than the USA?

|||

OK, got it - the answer is simple...

In the data source definition of the flat file containing the currency data, specify the locale as English(USA).

I suspect there are many users who follow the tutorial instructions to the letter and the instructions do not mention the locale setting - OK if you are in the USA.

|||

I

I have the same issue

My

Locale: Russian(Russia)

Code Page: 1251 (ANSI - кириллица)

Changing it, as you wrote it, to

Locale: English(United States)

does not correct this problem but just invokes more problems!!!!!


I aslo tried
ETL Package Problem
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=603488&SiteID=1


No luck either!

|||OK, I installed just one more instance with default English(US) language and

voilà .. everything started to work...
So, the conclusion is that in order to use SSIS I should migrate everything to a new instance with English(US)!? since default language/collation cannot be reset

I'd like to hear any better solution

|||

Another solution:

on http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

you find database for case-sensitive collation and case-insensitive collation, a attached the other database and now works.

|||

This link tells that samples download had moved to codeplex

And codeplex has hundreds of samples

Which one?

Sunday, March 25, 2012

Collation difference between SQL 6.5 server and SQL 2000 server

Hello,
We are facing the following problem:
We have installed SQL 6.5 server Enterprise edition on Windows 2000
Advanced server. On this system, in the regional settings, the Locale
is Japanese and in Office 2003 Language settings also, we have added
Japanese.
We have another system with Windows 2000 server on which we have
installed SQL 2000 server Enterprise edition with SP4. On this system,
in the regional settings, the Locale is Japanese and in Office 2003
Language settings also, we have added Japanese.

>From the front end VB code, a query is formed which contains Japanese
value. This works in the SQL 6.5 environment but does not work in the
SQL 2000 environment. If we directly execute the query in SQL 2000
server, it is returning the row. But the VB front end is not
recognizing the row.
The query is like this:
SELECT * FROM Tstar_Currency WHERE Currency =3D N'=C6=CE=DD'
This query works when the VB client connects to the SQL 6.5 server and
the front end fetches one row. But when the VB client connects to SQL
2000 server, the front end is not fetching any row. However, if we
directly execute this in query analyzer in SQL 2000 server, it returns
one row.
Any idea why this is happening? What collation setting should we give
in the SQL 2000 server? Do we need to do anything in the front end
application?
Any help will be greatly appreciated. This is very urgent. Please also
mail to ravi.meenakshi@.gmail.com
Thanks!I would sugest running the VB app in debug mode and see what happens when
the VB app issues the select statment. In addition at the same time you may
open Profiler.
The collation you are using in sql 6.5 works well for you so I would try to
keep the same collation with sql 2000.
Be aware that with sql2000 you have collation at three levels: server,
database and columns.
Verify that you have installed sql 2000 with the desired collation.
Yaniv
--
<Ravi.Meenakshi@.gmail.com> wrote in message
news:1135763223.233337.224300@.g49g2000cwa.googlegroups.com...
Hello,
We are facing the following problem:
We have installed SQL 6.5 server Enterprise edition on Windows 2000
Advanced server. On this system, in the regional settings, the Locale
is Japanese and in Office 2003 Language settings also, we have added
Japanese.
We have another system with Windows 2000 server on which we have
installed SQL 2000 server Enterprise edition with SP4. On this system,
in the regional settings, the Locale is Japanese and in Office 2003
Language settings also, we have added Japanese.

>From the front end VB code, a query is formed which contains Japanese
value. This works in the SQL 6.5 environment but does not work in the
SQL 2000 environment. If we directly execute the query in SQL 2000
server, it is returning the row. But the VB front end is not
recognizing the row.
The query is like this:
SELECT * FROM Tstar_Currency WHERE Currency = N''
This query works when the VB client connects to the SQL 6.5 server and
the front end fetches one row. But when the VB client connects to SQL
2000 server, the front end is not fetching any row. However, if we
directly execute this in query analyzer in SQL 2000 server, it returns
one row.
Any idea why this is happening? What collation setting should we give
in the SQL 2000 server? Do we need to do anything in the front end
application?
Any help will be greatly appreciated. This is very urgent. Please also
mail to ravi.meenakshi@.gmail.com
Thanks!|||(Ravi.Meenakshi@.gmail.com) writes:
> We have installed SQL 6.5 server Enterprise edition on Windows 2000
> Advanced server. On this system, in the regional settings, the Locale
> is Japanese and in Office 2003 Language settings also, we have added
> Japanese.
> We have another system with Windows 2000 server on which we have
> installed SQL 2000 server Enterprise edition with SP4. On this system,
> in the regional settings, the Locale is Japanese and in Office 2003
> Language settings also, we have added Japanese.
>
> value. This works in the SQL 6.5 environment but does not work in the
> SQL 2000 environment. If we directly execute the query in SQL 2000
> server, it is returning the row. But the VB front end is not
> recognizing the row.
> The query is like this:
> SELECT * FROM Tstar_Currency WHERE Currency = N''
> This query works when the VB client connects to the SQL 6.5 server and
> the front end fetches one row. But when the VB client connects to SQL
> 2000 server, the front end is not fetching any row. However, if we
> directly execute this in query analyzer in SQL 2000 server, it returns
> one row.
Wait a minute, that query does not even have legal syntax for
SQL 6.5. Is the N really there?
What does sp_helpsort return on SQL 6.5?
On SQL 2000, what does SELECT Serverproperty('Collation') return?
If you run sp_help on Tstar_Currency on SQL 2000, which is the
data type, and which is the collation for that column?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||The N is there in the query only in SQL 2000, not in 6.5
The data type of Currency column in Tstar_Currency in SQL 6.5 is
char(20) and in SQL 2000 is nchar(20)
The collation of this column in SQL 2000 is Japanese_CI_AS
The only change in the VB code is the inclusion of N before the
Japanese value.
Any clues on how to solve the problem?|||I ran profiler for the 2000 environment. In the query I first saw in
the profiler, I saw boxes. Then I changed the font in the Profiler to
Japanese. Then the query displayed like this:
SELECT MSCICode FROM Tstar_Currency WHERE Currency =3D N'=EF=BE=86=EF=BE=8E=
=EF=BE=9D'
When I executed this query in query analyzer, it did not return any
rows.
Please note that the client PC on which the VB application is running,
the regional settings is changed to Japanese.
I can't understand why the Japanese value was not passed correctly from
VB to SQL Server.
Any clues?|||(Ravi.Meenakshi@.gmail.com) writes:
> The N is there in the query only in SQL 2000, not in 6.5
> The data type of Currency column in Tstar_Currency in SQL 6.5 is
> char(20) and in SQL 2000 is nchar(20)
> The collation of this column in SQL 2000 is Japanese_CI_AS
> The only change in the VB code is the inclusion of N before the
> Japanese value.
> Any clues on how to solve the problem?
I asked you these questions:
What does sp_helpsort return on SQL 6.5?
On SQL 2000, what does SELECT Serverproperty('Collation') return?
It's difficult to give clues, if I don't get any.
But it does sound funny to me that the sole difference should be the
addition of the N. If the characters in the string are Unicode, it would
not work on 6.5. Since it works on 6.5, I suspect that the string is in
some other character set. In which case it will of course not work with
a Unicode column.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||The output of sp_helpsort in 65. is:
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase
Case-insensitive dictionary sort order for use with several We
stern-European languages including English, French, and German
. Uses the ISO 8859-1 character set.
The output of SELECT Serverproperty('Collation') in SQL 2000 is
SQL_Latin1_General_CP1_CI_AS
The collation setting of the SQL 2000 server is the default setting.
The collation for the database that the front end code is accessing is
Japanese_CI_AS|||(Ravi.Meenakshi@.gmail.com) writes:
> The output of sp_helpsort in 65. is:
> Character Set = 1, iso_1
> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
> Sort Order = 52, nocase
> Case-insensitive dictionary sort order for use with several We
> stern-European languages including English, French, and German
> . Uses the ISO 8859-1 character set.
> The output of SELECT Serverproperty('Collation') in SQL 2000 is
It sounds like a miracle if you get Japanese text correcly into that
server. Or at least a great deal of luck.

> SQL_Latin1_General_CP1_CI_AS
> The collation setting of the SQL 2000 server is the default setting.
> The collation for the database that the front end code is accessing is
> Japanese_CI_AS
I have not really managed to fully understand at what collation the
client APIs looks at when they convert data between character sets,
but I suspect that's the server collation. In which case Japanese text
that is the ANSI code page, will be mangled before it's sent to SQL Server.
Apparently you are building a an entire command string in VB. Try to use
parameterised command instead, as then you can declare the type of the
parameter.
You could also try to install an instance of SQL 2000 that has
Japanese_CI_AS as its server collation.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsqlsql

Thursday, March 22, 2012

Collation conflict

Hi all,

I have a db server which was installed with Collation 'SQL_Latin_General_CP1_CS_AS' and now I have to replace this server with a new server and I want to install this server with Collation 'SQL_Latin_General_CP1_CI_AS'.

I am using Linked Servers to collect some data from my Sybase database which has "Code Page 850 (Multilingual) character set,us_english,Binary ordering, for use with Code Page 850 (cp850)."

But with new SQL server(case-insensitive settings), I am unable to run a select query (joining a local server and sybase server) and I get an error message "cannot resolve collation conflict for equal to operation"

I have tried changing property of linked server by specifying Remote server collation to true and Collation Name as 'SQL_Latin_General_CP1_CS_AS' as well as 'SQL_Latin_General_CP850_Bin' but I do get the same error message.

Could any of you please help me in this regard ?

Thanks in advance.

Wilson

Edit: Sorted out. Somehow it is working now after specifying Remote server collation to true and Collation Name as 'SQL_Latin_General_CP1_CS_AS'hi,
check this link and tell me.
http://support.microsoft.com/kb/325335/en-us

Sunday, March 11, 2012

Co-Existence of MSDE Instances

My server has an instance of MSDE that was installed by the VERITAS backup
software.I have a new application now thats to be deployed which will need
MSDE,Is it ok to load another instance of MSDE for the new application or can
I use the one instance to run both VERITAS and the New application...any
suggestions will be much appreciated.
Thank you all.
hi Maverick,
"maverick" <maverick@.discussions.microsoft.com> ha scritto nel messaggio
news:2239EDC1-15D6-4F6E-B0DC-093D5199D97E@.microsoft.com...
> My server has an instance of MSDE that was installed by the VERITAS backup
> software.I have a new application now thats to be deployed which will need
> MSDE,Is it ok to load another instance of MSDE for the new application or
can
> I use the one instance to run both VERITAS and the New application...any
> suggestions will be much appreciated.
> Thank you all.
as you already know, technically you can install up to 16 MSDE/SQL Server
instances on the same server... only 1 instance can be the default
instances, where all others will be named instances..
legally, it's all another story.
since MSDE has become rellay free, the original constraint that each ISV
MUST install his/her own instance has become obsolete, but....
but each ISV can legally protect his/her own installed instance so that it
can not be used by other applications/external databases
so you have to check Verits documentation or directly ask them for such an
info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You don't really want to share another application's instance anyway. What
is the SA password they are using? Even if you are granted access (which I
doubt), what happens when the software is updated and they replace the
database or you uninstall the application and the database (and the MSDE)
instance is removed?
No, you really should install your own instance until we get to SQL Express
which does suggest/encourage use of a common instance.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2q2sltFqoea4U1@.uni-berlin.de...
> hi Maverick,
> "maverick" <maverick@.discussions.microsoft.com> ha scritto nel messaggio
> news:2239EDC1-15D6-4F6E-B0DC-093D5199D97E@.microsoft.com...
> can
> as you already know, technically you can install up to 16 MSDE/SQL Server
> instances on the same server... only 1 instance can be the default
> instances, where all others will be named instances..
> legally, it's all another story.
> since MSDE has become rellay free, the original constraint that each ISV
> MUST install his/her own instance has become obsolete, but....
> but each ISV can legally protect his/her own installed instance so that it
> can not be used by other applications/external databases
> so you have to check Verits documentation or directly ask them for such an
> info
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Well, it worked for me. I installed the MSCRM Outlook Sales client on my
laptop. It installs MSDE for it's database.
They I installed Microsoft Small business Manager which will also create a
MSDE database.
It worked and the machine did not complain too much.
But beyond that I did not do much.
Also this worked with full SqL and MSDE on the same laptop.
MSDE supported Sales Outlook Client for MSCRM and I had the Great Plains 7.5
running and connecting the client to the full MSSQL Databases.
I slowed the laptop down but that was about it.
Hope that helps.
"maverick" wrote:

> My server has an instance of MSDE that was installed by the VERITAS backup
> software.I have a new application now thats to be deployed which will need
> MSDE,Is it ok to load another instance of MSDE for the new application or can
> I use the one instance to run both VERITAS and the New application...any
> suggestions will be much appreciated.
> Thank you all.
|||With the MSDE, you are encouraged to run your application in its own
instance. This also avoids issues with administrative passwords, etc. In the
future (with SQL Express), the situation changes though and you'll be
encouraged to use the single SQLExpress instance.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Curt Spanburgh" <CurtSpanburgh@.discussions.microsoft.com> wrote in message
news:D42533B2-F027-40F4-B2B8-E05E3299857F@.microsoft.com...
> Well, it worked for me. I installed the MSCRM Outlook Sales client on my
> laptop. It installs MSDE for it's database.
> They I installed Microsoft Small business Manager which will also create a
> MSDE database.
> It worked and the machine did not complain too much.
> But beyond that I did not do much.
> Also this worked with full SqL and MSDE on the same laptop.
> MSDE supported Sales Outlook Client for MSCRM and I had the Great Plains
7.5[vbcol=seagreen]
> running and connecting the client to the full MSSQL Databases.
> I slowed the laptop down but that was about it.
> Hope that helps.
>
> "maverick" wrote:
backup[vbcol=seagreen]
need[vbcol=seagreen]
or can[vbcol=seagreen]

Thursday, March 8, 2012

Code Problem in Reporting Services 2005

We have just installed SQL Server 2005 Reporting Services and have
encountered an error converting the first report from SQL Server 2000
Reporting Services 2000 to the new version. The error is in using an
embedded code function being used in an expression.
The expression is:
=Code.GetEmployeeId(Fields!EmployeeId.Value).
The code function is:
Public Function GetEmployeeId(ByVal id as Object) As String
Dim text as String
text = iif (IsNothing(id), 0, id)
Return text
End Function
When the expression is edited, the function name. "GetEmployeeId", is
underlined in red and the popup error text says "Unrecognized Identifier."
What do I need to do to be able to get RS 2005 to recognize my function?
Thanks,
Tomits a VB.net code.
try this:
if id is nothing then
return 0
else
return id
end if
"Tom Bean" <tbean@.newsgroup.nospam> wrote in message
news:%23ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl...
> We have just installed SQL Server 2005 Reporting Services and have
> encountered an error converting the first report from SQL Server 2000
> Reporting Services 2000 to the new version. The error is in using an
> embedded code function being used in an expression.
> The expression is:
> =Code.GetEmployeeId(Fields!EmployeeId.Value).
> The code function is:
> Public Function GetEmployeeId(ByVal id as Object) As String
> Dim text as String
> text = iif (IsNothing(id), 0, id)
> Return text
> End Function
> When the expression is edited, the function name. "GetEmployeeId", is
> underlined in red and the popup error text says "Unrecognized Identifier."
> What do I need to do to be able to get RS 2005 to recognize my function?
> Thanks,
> Tom
>|||Hello Tom,
If you use the following expression in a textbox directly, what is the
result?
=Code.GetEmployeeId(nothing)
=Code.GetEmployeeId(1)
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Tom Bean" <tbean@.newsgroup.nospam>
>Subject: Code Problem in Reporting Services 2005
>Date: Tue, 17 Jan 2006 18:37:33 -0600
>Lines: 26
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67023
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>We have just installed SQL Server 2005 Reporting Services and have
>encountered an error converting the first report from SQL Server 2000
>Reporting Services 2000 to the new version. The error is in using an
>embedded code function being used in an expression.
>The expression is:
> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>The code function is:
>Public Function GetEmployeeId(ByVal id as Object) As String
> Dim text as String
> text = iif (IsNothing(id), 0, id)
> Return text
>End Function
>When the expression is edited, the function name. "GetEmployeeId", is
>underlined in red and the popup error text says "Unrecognized Identifier."
>What do I need to do to be able to get RS 2005 to recognize my function?
>Thanks,
>Tom
>
>|||Peter,
When I edit the expression, with either 'nothing' or '1' as the parameter,
GetEmployeeId is still underlined in red and the "Unrecognized Identifier"
error still pops up. However, when the report is rendered, the values '0'
and '1' are displayed in the textboxes.
My concern is that some undocumented change has occurred in the way a code
block needs to be formatted in order for the function to be recognized. The
code I showed in my original post is all that is contained in the window on
the Code tab of the reports properties. Does something need to be changed
in the Code window to get the function to be recognized?
Thanks,
Tom
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hello Tom,
> If you use the following expression in a textbox directly, what is the
> result?
> =Code.GetEmployeeId(nothing)
> =Code.GetEmployeeId(1)
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>|||Peter,
After investigating the problem with my report further, I found that the
problem isn't with the code even though an error is raised in the expression
editor. The problem seems to be due to the location of the subreport.
The subreport with the problem is in a cell of a 3 row table that contains
two groups. The first group, the ServiceGroup, is in the first row and the
second group, the EmployeeGroup, is in the second row. If the subreport is
put in a cell in the first row (first group), it works. If the subreport is
put in a cell in the second row (second group), it fails with an "internal
error" message.
Is there some issue with multiple groups in one table that would cause the
subreport to fail?
Thanks,
Tom
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hello Tom,
> If you use the following expression in a textbox directly, what is the
> result?
> =Code.GetEmployeeId(nothing)
> =Code.GetEmployeeId(1)
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>|||Hello Tom,
Since the issue occurs consistently on this specific situation, it is more
like a problem in RS2005 though I did not find any known issue related. You
may want to contact CSS directly so they could look into this in timely
manner.
For a complete list of Microsoft Customer Support Services phone numbers,
please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Tom Bean" <tbean@.newsgroup.nospam>
>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
<93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Code Problem in Reporting Services 2005
>Date: Wed, 18 Jan 2006 14:46:54 -0600
>Lines: 92
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67080
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Peter,
>After investigating the problem with my report further, I found that the
>problem isn't with the code even though an error is raised in the
expression
>editor. The problem seems to be due to the location of the subreport.
>The subreport with the problem is in a cell of a 3 row table that contains
>two groups. The first group, the ServiceGroup, is in the first row and
the
>second group, the EmployeeGroup, is in the second row. If the subreport
is
>put in a cell in the first row (first group), it works. If the subreport
is
>put in a cell in the second row (second group), it fails with an "internal
>error" message.
>Is there some issue with multiple groups in one table that would cause the
>subreport to fail?
>Thanks,
>Tom
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> If you use the following expression in a textbox directly, what is the
>> result?
>> =Code.GetEmployeeId(nothing)
>> =Code.GetEmployeeId(1)
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized
Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>>
>
>|||Peter,
I have rewritten my query so the second subreport, in the second row/group,
is no longer necessary. This provides me with a usable workaround but I
think you should escalate this problem to the Reporting Services group to
they can restore the functionality that was available in RS2000.
Thanks,
Tom
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:fT%23Yc2NHGHA.1240@.TK2MSFTNGXA02.phx.gbl...
> Hello Tom,
> Since the issue occurs consistently on this specific situation, it is more
> like a problem in RS2005 though I did not find any known issue related.
> You
> may want to contact CSS directly so they could look into this in timely
> manner.
> For a complete list of Microsoft Customer Support Services phone numbers,
> please go to the following address on the World Wide Web:
> <http://support.microsoft.com/directory/overview.asp>
> If you are outside the US please see http://support.microsoft.com for
> regional support phone numbers.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
> <93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
>>Subject: Re: Code Problem in Reporting Services 2005
>>Date: Wed, 18 Jan 2006 14:46:54 -0600
>>Lines: 92
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67080
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Peter,
>>After investigating the problem with my report further, I found that the
>>problem isn't with the code even though an error is raised in the
> expression
>>editor. The problem seems to be due to the location of the subreport.
>>The subreport with the problem is in a cell of a 3 row table that contains
>>two groups. The first group, the ServiceGroup, is in the first row and
> the
>>second group, the EmployeeGroup, is in the second row. If the subreport
> is
>>put in a cell in the first row (first group), it works. If the subreport
> is
>>put in a cell in the second row (second group), it fails with an "internal
>>error" message.
>>Is there some issue with multiple groups in one table that would cause the
>>subreport to fail?
>>Thanks,
>>Tom
>>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>>news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> If you use the following expression in a textbox directly, what is the
>> result?
>> =Code.GetEmployeeId(nothing)
>> =Code.GetEmployeeId(1)
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized
> Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>>
>>
>|||Hello Tom,
Thank you for your feedback. Please rest assured that this issue has been
report to the proper channel. If there is any update about this, we will
let you know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Tom Bean" <tbean@.newsgroup.nospam>
>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
<93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
<fT#Yc2NHGHA.1240@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Code Problem in Reporting Services 2005
>Date: Thu, 19 Jan 2006 08:46:54 -0600
>Lines: 165
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <O676qcQHGHA.984@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67121
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Peter,
>I have rewritten my query so the second subreport, in the second
row/group,
>is no longer necessary. This provides me with a usable workaround but I
>think you should escalate this problem to the Reporting Services group to
>they can restore the functionality that was available in RS2000.
>Thanks,
>Tom
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:fT%23Yc2NHGHA.1240@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> Since the issue occurs consistently on this specific situation, it is
more
>> like a problem in RS2005 though I did not find any known issue related.
>> You
>> may want to contact CSS directly so they could look into this in timely
>> manner.
>> For a complete list of Microsoft Customer Support Services phone numbers,
>> please go to the following address on the World Wide Web:
>> <http://support.microsoft.com/directory/overview.asp>
>> If you are outside the US please see http://support.microsoft.com for
>> regional support phone numbers.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>> <93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
>>Subject: Re: Code Problem in Reporting Services 2005
>>Date: Wed, 18 Jan 2006 14:46:54 -0600
>>Lines: 92
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:67080
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Peter,
>>After investigating the problem with my report further, I found that the
>>problem isn't with the code even though an error is raised in the
>> expression
>>editor. The problem seems to be due to the location of the subreport.
>>The subreport with the problem is in a cell of a 3 row table that
contains
>>two groups. The first group, the ServiceGroup, is in the first row and
>> the
>>second group, the EmployeeGroup, is in the second row. If the subreport
>> is
>>put in a cell in the first row (first group), it works. If the subreport
>> is
>>put in a cell in the second row (second group), it fails with an
"internal
>>error" message.
>>Is there some issue with multiple groups in one table that would cause
the
>>subreport to fail?
>>Thanks,
>>Tom
>>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>>news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> If you use the following expression in a textbox directly, what is the
>> result?
>> =Code.GetEmployeeId(nothing)
>> =Code.GetEmployeeId(1)
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader
so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized
>> Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my
function?
>>Thanks,
>>Tom
>>
>>
>>
>>
>
>

Code page translations are not supported for the text data type. From: 1252 To: 950.

Code page translations are not supported for the text data type. From:
1252 To: 950.

I would like to know what this message means. I also installed the
language packs in advanced settings, Everything is set to English. My
windows XP computer is XP English. For some reason I cant get an update
to go thru using ADO. like Recordset.Update

Although other routines using .update work

Any ideas?Is it possible that If I installed MSDE when I had set under advanced
settings the nonunicode programs to Chinese that this would happen? I
have also noticed I can get around this by using the N' like select *
from some where something = N'something'

Anyway, how does one normally get around this issue, would an uninstall
of MSDE and then reinstall while XP is set to English fix this issue?|||That worked, uninstaled MSDE and reinstalled while XP was set to
english.
But I think the only setting change I made was under
control panel
regional settings
advanced language for nonunicode programs to Chinese(Taiwan).|||Hi

The collation was probably not explicitly set for the installation see
http://msdn.microsoft.com/library/d...istsql_84xl.asp
http://msdn.microsoft.com/library/d..._ca-co_2e95.asp

John

<sdowney717@.msn.com> wrote in message
news:1110744591.148218.180470@.z14g2000cwz.googlegr oups.com...
> That worked, uninstaled MSDE and reinstalled while XP was set to
> english.
> But I think the only setting change I made was under
> control panel
> regional settings
> advanced language for nonunicode programs to Chinese(Taiwan).|||Yes, it gives no options on the install, it must just use whatever is
set for the language. That does answer another question I was wondering
about, involving default collations. Is there an updated install for
MSDE, I only have the one off my Office XP CDROM. from 2000|||Hi

The latest release is downloadable from
http://www.microsoft.com/downloads/...&displaylang=en
this includes SP3a although you can apply SP3a to your existing system using
the appropriate download from
http://www.microsoft.com/sql/downloads/2000/sp3.asp

John

<sdowney717@.msn.com> wrote in message
news:1110749126.795817.193210@.f14g2000cwb.googlegr oups.com...
> Yes, it gives no options on the install, it must just use whatever is
> set for the language. That does answer another question I was wondering
> about, involving default collations. Is there an updated install for
> MSDE, I only have the one off my Office XP CDROM. from 2000|||sdowney717@.msn.com (sdowney717@.msn.com) writes:
> Is it possible that If I installed MSDE when I had set under advanced
> settings the nonunicode programs to Chinese that this would happen? I
> have also noticed I can get around this by using the N' like select *
> from some where something = N'something'

The N' means that the literal is nvarchar and thus Unicode, and thus not
subject to conversion between different 8-bit character sets.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Wednesday, March 7, 2012

COALESCE function problem

Hi, I downloaded "Microsoft SQL Server Compact Edition" v3.1, installed, created database in VS2005, created table TESTTABLE with one column TEST NVARCHAR 200 and run this command against it:

SELECT coalesce(test,NULL) from testtable

but it says

Error : The function is not recognized by SQL Server Compact Edition. [ Name of function = coalesce,Data type (if known) = ]

In this forums there are more usages of coalesce function, so I think it is supported and fully functional, but where is the problem, then ?

My system is Windows Vista Business (Czech version), version of sqlcese30.dll and sqlceqp30.dll is 3.0.5300.0.

thank you for suggestions

J.S.

The COALSECE finction works fine in SQL Compact 3.1, it is a problem with the tool you are using. Have successfully tested in SQL Server Management Studio SP2. It is a problem with the Visual Studio Server Explorer query parser.

|||But, I'am not using any tool - I am using it from application (.NET 2.0). I will make a sample...|||

Hmm, i dont't know where was the problem, but now problem is another:

The specified argument value for the function is not valid. [ Argument # = 2,Name of function(if known) = coalesce ]

my source code i used:

string fn = args[0];

string cs = "Data source='"+fn+"'";

SqlCeConnection conn = new SqlCeConnection(cs);

conn.Open();

//only if table does not exists

//SqlCeCommand cmd1 = new SqlCeCommand("CREATE TABLE TESTTABLE ( TEST NVARCHAR(200) NULL )", conn);

//cmd1.ExecuteNonQuery();

SqlCeCommand cmd2 = new SqlCeCommand();

cmd2.CommandText = "SELECT COALESCE(TEST,@.p1) FROM TESTTABLE";

cmd2.Parameters.AddWithValue("p1", "no value");

cmd2.Connection = conn;

SqlCeDataAdapter adapter = new SqlCeDataAdapter(cmd2);

DataSet ds = new DataSet();

adapter.Fill(ds);

another command

SELECT COALESCE(TEST,'no value') FROM TESTTABLE

is OK, but this is not my scenario...

I think the problem is in parameter - it cannot be used in COALESCE function ?

|||

Looks like you must change the statement to not use parameters!

|||

But this is against th best practices - to use parameters instead of literals...

Of course, I am using SqlServerCe as alternative data provider (user can configure SqlServer/SqlServerCe) and i dont want to write another (bad!) code to achive same functionality...

any ideas ? will this be supported in another version ?

thank you

|||

Hi Jan.

This piece of code breaks with the error you mention using SQL Compact 3.1 in VS 2005, but works (res = "no value") with SQL Compact 3.5 beta 2 and VS 2008 beta 2:

Code Snippet

SqlCeConnection conn = new SqlCeConnection(@."Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf;");
conn.Open();
SqlCeCommand cmd2 = new SqlCeCommand();
cmd2.CommandText = "SELECT COALESCE(Region,@.p1) FROM Customers WHERE [Customer Id] = 'ALFKI'";
cmd2.Parameters.AddWithValue("p1", "no value");
cmd2.Connection = conn;
object res;
res = cmd2.ExecuteScalar();

So time will mend all wounds!

|||

Oh ! Great, this is, what I want to read...

Thank you for your quick and brilliant answers.

COALESCE function problem

Hi, I downloaded "Microsoft SQL Server Compact Edition" v3.1, installed, created database in VS2005, created table TESTTABLE with one column TEST NVARCHAR 200 and run this command against it:

SELECT coalesce(test,NULL) from testtable

but it says

Error : The function is not recognized by SQL Server Compact Edition. [ Name of function = coalesce,Data type (if known) = ]

In this forums there are more usages of coalesce function, so I think it is supported and fully functional, but where is the problem, then ?

My system is Windows Vista Business (Czech version), version of sqlcese30.dll and sqlceqp30.dll is 3.0.5300.0.

thank you for suggestions

J.S.

The COALSECE finction works fine in SQL Compact 3.1, it is a problem with the tool you are using. Have successfully tested in SQL Server Management Studio SP2. It is a problem with the Visual Studio Server Explorer query parser.

|||But, I'am not using any tool - I am using it from application (.NET 2.0). I will make a sample...|||

Hmm, i dont't know where was the problem, but now problem is another:

The specified argument value for the function is not valid. [ Argument # = 2,Name of function(if known) = coalesce ]

my source code i used:

string fn = args[0];

string cs = "Data source='"+fn+"'";

SqlCeConnection conn = new SqlCeConnection(cs);

conn.Open();

//only if table does not exists

//SqlCeCommand cmd1 = new SqlCeCommand("CREATE TABLE TESTTABLE ( TEST NVARCHAR(200) NULL )", conn);

//cmd1.ExecuteNonQuery();

SqlCeCommand cmd2 = new SqlCeCommand();

cmd2.CommandText = "SELECT COALESCE(TEST,@.p1) FROM TESTTABLE";

cmd2.Parameters.AddWithValue("p1", "no value");

cmd2.Connection = conn;

SqlCeDataAdapter adapter = new SqlCeDataAdapter(cmd2);

DataSet ds = new DataSet();

adapter.Fill(ds);

another command

SELECT COALESCE(TEST,'no value') FROM TESTTABLE

is OK, but this is not my scenario...

I think the problem is in parameter - it cannot be used in COALESCE function ?

|||

Looks like you must change the statement to not use parameters!

|||

But this is against th best practices - to use parameters instead of literals...

Of course, I am using SqlServerCe as alternative data provider (user can configure SqlServer/SqlServerCe) and i dont want to write another (bad!) code to achive same functionality...

any ideas ? will this be supported in another version ?

thank you

|||

Hi Jan.

This piece of code breaks with the error you mention using SQL Compact 3.1 in VS 2005, but works (res = "no value") with SQL Compact 3.5 beta 2 and VS 2008 beta 2:

Code Snippet

SqlCeConnection conn = new SqlCeConnection(@."Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf;");
conn.Open();
SqlCeCommand cmd2 = new SqlCeCommand();
cmd2.CommandText = "SELECT COALESCE(Region,@.p1) FROM Customers WHERE [Customer Id] = 'ALFKI'";
cmd2.Parameters.AddWithValue("p1", "no value");
cmd2.Connection = conn;
object res;
res = cmd2.ExecuteScalar();

So time will mend all wounds!

|||

Oh ! Great, this is, what I want to read...

Thank you for your quick and brilliant answers.

COALESCE function problem

Hi, I downloaded "Microsoft SQL Server Compact Edition" v3.1, installed, created database in VS2005, created table TESTTABLE with one column TEST NVARCHAR 200 and run this command against it:

SELECT coalesce(test,NULL) from testtable

but it says

Error : The function is not recognized by SQL Server Compact Edition. [ Name of function = coalesce,Data type (if known) = ]

In this forums there are more usages of coalesce function, so I think it is supported and fully functional, but where is the problem, then ?

My system is Windows Vista Business (Czech version), version of sqlcese30.dll and sqlceqp30.dll is 3.0.5300.0.

thank you for suggestions

J.S.

The COALSECE finction works fine in SQL Compact 3.1, it is a problem with the tool you are using. Have successfully tested in SQL Server Management Studio SP2. It is a problem with the Visual Studio Server Explorer query parser.

|||But, I'am not using any tool - I am using it from application (.NET 2.0). I will make a sample...|||

Hmm, i dont't know where was the problem, but now problem is another:

The specified argument value for the function is not valid. [ Argument # = 2,Name of function(if known) = coalesce ]

my source code i used:

string fn = args[0];

string cs = "Data source='"+fn+"'";

SqlCeConnection conn = new SqlCeConnection(cs);

conn.Open();

//only if table does not exists

//SqlCeCommand cmd1 = new SqlCeCommand("CREATE TABLE TESTTABLE ( TEST NVARCHAR(200) NULL )", conn);

//cmd1.ExecuteNonQuery();

SqlCeCommand cmd2 = new SqlCeCommand();

cmd2.CommandText = "SELECT COALESCE(TEST,@.p1) FROM TESTTABLE";

cmd2.Parameters.AddWithValue("p1", "no value");

cmd2.Connection = conn;

SqlCeDataAdapter adapter = new SqlCeDataAdapter(cmd2);

DataSet ds = new DataSet();

adapter.Fill(ds);

another command

SELECT COALESCE(TEST,'no value') FROM TESTTABLE

is OK, but this is not my scenario...

I think the problem is in parameter - it cannot be used in COALESCE function ?

|||

Looks like you must change the statement to not use parameters!

|||

But this is against th best practices - to use parameters instead of literals...

Of course, I am using SqlServerCe as alternative data provider (user can configure SqlServer/SqlServerCe) and i dont want to write another (bad!) code to achive same functionality...

any ideas ? will this be supported in another version ?

thank you

|||

Hi Jan.

This piece of code breaks with the error you mention using SQL Compact 3.1 in VS 2005, but works (res = "no value") with SQL Compact 3.5 beta 2 and VS 2008 beta 2:

Code Snippet

SqlCeConnection conn = new SqlCeConnection(@."Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf;");
conn.Open();
SqlCeCommand cmd2 = new SqlCeCommand();
cmd2.CommandText = "SELECT COALESCE(Region,@.p1) FROM Customers WHERE [Customer Id] = 'ALFKI'";
cmd2.Parameters.AddWithValue("p1", "no value");
cmd2.Connection = conn;
object res;
res = cmd2.ExecuteScalar();

So time will mend all wounds!

|||

Oh ! Great, this is, what I want to read...

Thank you for your quick and brilliant answers.

Saturday, February 25, 2012

Cnot start SQL Server 2000sp3

I have installed MSDE version of SQL server 2000 and sp3 with merge modules
and I cannot start the SQL server when the instance name is other than the
default. Can someone tell me what is wrong?
Hi Yiannis,
From your descriptions, I understood that you could not start SQL Server's
instance when this instance is not the default one by MSDE. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my knowledge, database engine operates as a service or process
that is separate from any application using MSDE 2000. Either MSDE 2000 or
any other version of SQL Server can be running at the same time on the same
computer. Each copy is called an instance. Each instance is installed,
started, stopped, configured, and patched independently of the other
instances.
However, I am not sure your steps about the installation and start-up for
the instance and what error messages could you find Event Log. Would you
please give me detailed descriptions about it, which I believe, will get us
closer to the resolution Could you give me a descriptions, with which I
could reproduce it on my machine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Here is how things are. With a setup project I am using all the merge
modules to install the SQL MSDE to the machine. When I configure the server
to use the default instance everything is going fine. When I change the
instance name and I use a named one then when I try to start the server
(same command "start") the server doesn;t start at all. I am trying to start
the server with the command from the instance binn dir "sqlservr -scommerce"
and I cannot start it. When I use the sqlmanagr to start the server it is
starting but the command doesn't start it.
Running machine is an XP Professional version 2002.
From the command prompt the command is going till "SQL Server is ready for
client connections" and never gets to an end.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> From your descriptions, I understood that you could not start SQL Server's
> instance when this instance is not the default one by MSDE. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know
> Based on my knowledge, database engine operates as a service or process
> that is separate from any application using MSDE 2000. Either MSDE 2000 or
> any other version of SQL Server can be running at the same time on the
same
> computer. Each copy is called an instance. Each instance is installed,
> started, stopped, configured, and patched independently of the other
> instances.
> However, I am not sure your steps about the installation and start-up for
> the instance and what error messages could you find Event Log. Would you
> please give me detailed descriptions about it, which I believe, will get
us
> closer to the resolution Could you give me a descriptions, with which I
> could reproduce it on my machine?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for you update!
However, I am still not sure about the root cause of this issue, Would you
please help me collection more detailed information? More detailed
information, I believe, will get us closer to the resolutions
First of all, could you start MSSQL Services by means of Control Panel ->
Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
Services by running Command "net start mssqlserver" (without quotation
marks)?
Secondly, could you see some error logs when you are starting up the SQL
Server? Error Number will be the most helpful ones for us to
troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
about the startup and post it here?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer?
Yes I can.
Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
The server is doesn't start. When I press Enter a dialog opens and closes
but I don';t have a chance to see anything.

> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
>
Here is the log file.
2004-05-28 16:34:39.69 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )
2004-05-28 16:34:39.72 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-28 16:34:39.73 server All rights reserved.
2004-05-28 16:34:39.74 server Server Process ID is 2680.
2004-05-28 16:34:39.74 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$COMMERCE\LOG\ERRORLOG'.
2004-05-28 16:34:39.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-05-28 16:34:39.82 server SQL Server configured for thread mode
processing.
2004-05-28 16:34:39.84 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-05-28 16:34:39.89 spid3 Starting up database 'master'.
2004-05-28 16:34:40.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-28 16:34:40.29 spid5 Starting up database 'model'.
2004-05-28 16:34:40.34 spid3 Server name is 'MANOSVMXP\COMMERCE'.
2004-05-28 16:34:40.35 spid3 Skipping startup of clean database id 4
2004-05-28 16:34:40.37 server SQL server listening on 192.5.129.70: 1041.
2004-05-28 16:34:40.38 server SQL server listening on 127.0.0.1: 1041.
2004-05-28 16:34:40.58 spid5 Clearing tempdb database.
2004-05-28 16:34:41.41 spid5 Starting up database 'tempdb'.
2004-05-28 16:34:41.76 spid3 Recovery complete.
2004-05-28 16:34:41.77 spid3 SQL global counter collection task is
created.
2004-05-28 16:34:42.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-05-28 16:34:42.69 server SQL Server is ready for client connections
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for you update!
> However, I am still not sure about the root cause of this issue, Would you
> please help me collection more detailed information? More detailed
> information, I believe, will get us closer to the resolutions
> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for your updates!
Since you could start MSSQL Services, could you tell me what's the command
in "Path to executable"? (You could find Path to executeable in Control
Panel -> Services -> Right Click MSSQLServer\InstanceName)
Secondly, try to find what's the result of command "net start
mssqlserver\InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
Finally, it seems OK with your Log files. Would you please tell me when if
hangs in "SQL Server is ready for client connections", Could you login the
server? If not, what's the error message and error number you will get?
Anyway, Would you please show me why do you like to startup
MSSQLServer\InstanceName with command? Maybe it will be easier for us
finding a workaround
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
MSSQL. "Commerce" is the instance name.
Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
System error 123 has occured.

> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
it is hanging the command from a dos prompt and then I am trying from the
services by right clicking to start and I get an error (message actually)
which says "The MSSQL$COMMERCE service on Local Computer started and then
stopped. Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."

> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
>
I am using InstallShield to install an application to the target machine. I
have configured the merge modules of the SQL Server 2k with sp3 to install
and everything is working fine if I use the default instance name. Sinse
other software manufacturers are using the default instance name there is a
problem installing all software in one machine. So I thought that changing
the instance name of my app would solve this problem and I could have my app
running with a different instance name. There is where the problem started
and I cannot start the SQL server with this instance name. From my code I am
usinf the command to start the SQL.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
> Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||I am trying to start the SQL with SQL Server object and command start to
start it but since I cannot do it like this I am trying with command line
and this is not working either.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Since you could start MSSQL Services, could you tell me what's the command
> The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
> MSSQL. "Commerce" is the instance name.
>
> Secondly, try to find what's the result of command "net start
> System error 123 has occured.
>
if[vbcol=seagreen]
the
> it is hanging the command from a dos prompt and then I am trying from the
> services by right clicking to start and I get an error (message actually)
> which says "The MSSQL$COMMERCE service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> I am using InstallShield to install an application to the target machine.
I
> have configured the merge modules of the SQL Server 2k with sp3 to install
> and everything is working fine if I use the default instance name. Sinse
> other software manufacturers are using the default instance name there is
a
> problem installing all software in one machine. So I thought that changing
> the instance name of my app would solve this problem and I could have my
app
> running with a different instance name. There is where the problem started
> and I cannot start the SQL server with this instance name. From my code I
am[vbcol=seagreen]
> usinf the command to start the SQL.
>
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
command[vbcol=seagreen]
if[vbcol=seagreen]
the[vbcol=seagreen]
rights.
>
|||Hi Yiannis,
Oops, It's an type that you shoud use $ instead of \
try to find what's the result of command "net start
mssqlserver$InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
What's the result of it? Could you start SQL Server successfully?
If you could, will this satisfy your requirements?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
I did it and I get an error "The service name is invalid"
I was looking at my previous post and I realize that it doesn;t make sense
what I wrote. The way I am trying to start SQL is with the Server object
from SQL-DMO. Since I cannot do it like this I am trying to start the server
with the command line.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> What's the result of it? Could you start SQL Server successfully?
> If you could, will this satisfy your requirements?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>