Error loading resource string in SP2

After I installed the SP2 and reboot the server, when I try to print the a
report, it keep pop up the error message say"Error loading resource string",
after I click many times, I got the printer properties window, many text in
the button are disappear, but I still could print it out.
Any idea?
ThanksMy guess is that you had the beta of SP2. If so then you need to clear out
then per Brian Welcker (MS): You need to clean out any older versions of the
controls from your C:\WINDOWS\Downloaded Program Files directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"msnews.microsoft.com" <huangxiaohua@.hotmail.com> wrote in message
news:uYZWGkxSFHA.2304@.tk2msftngp13.phx.gbl...
> After I installed the SP2 and reboot the server, when I try to print the a
> report, it keep pop up the error message say"Error loading resource
string",
> after I click many times, I got the printer properties window, many text
in
> the button are disappear, but I still could print it out.
> Any idea?
> Thanks
>

Error in translated error string

I didn't find a good thread to put this, but since I noticed it in the SQL Server Express version I put it here:

Here is an error I get in Swedish:
"Konvertering av nvarchar v?rdet av typen Ny! till datatypen int misslyckades."

The error string is however not correct. In English it reads:
Syntax error converting the nvarchar value 'Ny!' to a column of data type int.

And in Swedish it should be:
"Konvertering av nvarchar-v?rdet 'Ny!' till datatypen int misslyckades."
or even
"Konvertering av nvarchar-v?rdet 'Ny!' till ett f?lt av datatypen int misslyckades."

Is there an address to send this kind of errors to?

Kind regards,
Andreas Jansson
No, this is truly an implemtation error. You are trying to pass a value to SQL Server which is not numeric although SQL Server expected that type. It would ne nice for us to know where you get the error and what you are doing to receive this error.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I'm fully aware of the implementation errror (which has been corrected). What I'm concerned about is the erroneous translation of that exact error message into Swedish.

Translated back into English the message would read:
Converting the nvarchar value of type Ny! to data type int failed.

So in the Swedish error we read that (the nvarchar value) Ny! is a type, which it of course is not.

Also, there should be a hyphen between "nvarchar" and "v?rdet": "nvarchar-v?rdet".

|||If its just a translation error in your opinion, should should file this as a bug on connect.microsoft.com to correct this in the next versions of SQL Server. You can have a look at the sysmessages in SQL Server (sysmessages table in the master database) to see which string is parametrized here.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error in Stored Procedure while working with temp. table

Creating a temporary table in stored procedure and using a sql query to insert the data in temp. table.I am facing the error as :

String or binary data would be truncated.The statement has been terminated.

The procedure i created is as :

ALTER PROCEDUREfetchpersondetails

AS

CREATE Table#tempperson (personIDint,FirstNamenvarchar(200),LastNamenvarchar(250),titlenvarchar(150),Professionnvarchar(200),StreetAddressnvarchar(300),

StateAddressnvarchar(200),CityAddressnvarchar(200),CountryAddressnvarchar(200),ZipAddressnvarchar(200),Telephonenvarchar(200),Mobilenvarchar(200),

Faxnvarchar(200),Emailnvarchar(250),NotesPubntext,Affiliationnvarchar(200),Categorynvarchar(200))

Insert into#tempperson

SELECTdbo.tblperson.personID,ISNULL(dbo.tblperson.fName, N'') +' '+ISNULL(dbo.tblperson.mName, N'')ASFirstName, dbo.tblperson.lnameASLastName,

dbo.tblperson.honorASTitle, dbo.tblperson.titleASProfession, dbo.tblperson.street +' '+ISNULL(dbo.tblperson.suite, N'')ASStreetAddress,

dbo.tblperson.cityAScityaddress, dbo.tblperson.stateASstateaddress, dbo.tblperson.postalCodeASzipaddress,

dbo.tblperson.Phone1 +','+ISNULL(dbo.tblperson.Phone2, N'') +','+ISNULL(dbo.tblperson.Phone3, N'')ASTelephone,

dbo.tblperson.mobilePhoneASmobile, dbo.tblperson.officeFax +','+ISNULL(dbo.tblperson.altOfficeFax, N'') +','+ISNULL(dbo.tblperson.altOfficeFax2,

N'')ASFax,ISNULL(dbo.tblperson.Email1, N'') +','+ISNULL(dbo.tblperson.Email2, N'') +','+ISNULL(dbo.tblperson.Email3, N'')ASEmail,

dbo.tblperson.notesASNotesPub, dbo.tblOrganizations.orgNameASAffiliation, dbo.tblOrganizations.orgCategoryASCategory,

dbo.tblCountry.countryNameFullAScountryaddress

FROMdbo.tblpersonINNER JOIN

dbo.tblOrganizationsONdbo.tblperson.orgID = dbo.tblOrganizations.orgIDINNER JOIN

dbo.tblCountryONdbo.tblperson.countryCode = dbo.tblCountry.ISOCode

please let me know the solurion of this error.

What the error msg means is that you are trying to insert a value that is larger than what the column can take. Check your column lengths in the temp table and the data coming in from your SELECT statment. Apparently, you have crossed the limit somewhere.

|||

I made it working.Its not the column length that creating problem.

Error in my connection string

<add name="TimeTrackingDB" connectionString="provider=MSSQL$DEV_2000;Integrated Security=SSPI;Data Source=PORT06139\DEV_2000;Initial Catalog=TimeTracking;Persist Security Info=True;User ID=user_TTT;Password=user_TTT;pooling=false;"/>

When i'm lauching the web application, i have an error message saying that there is a mistake with the provider...

I'm using Microsoft SQL Server 2000.

Anybody can help me?

Thanks by advance :)http://www.connectionstrings.com/?carrier=sqlserver2005|||since you are using 2000, these might be more appropriate:

http://www.connectionstrings.com/?carrier=sqlserver

Error in formula

Hi All,

I get the "A String is required here" error with my formula and it higlights the line in bold.

If {@.ScheduledTasks} = 0 then
"N/S"
Else If {@.TotalTasks} = 0 then
"N/D"
Else
(sum({@.TimelyCOmplete},{@.Group_CrewUnit})/(sum({@.TimelyCOmplete},{@.Group_CrewUnit}) + sum({@.MissedTasks},{@.Group_CrewUnit}) + sum({@.LateComplete},{@.Group_CrewUnit}))) * 100

Thanks in advanceYour third line will return an integer - all statements must return the same type. Wrap the third line in ToText().

Error in DataAdapter.Fill

i have this code :
private void Page_Load(object sender, ...)
{
if(! IsPostBack)
{
string strConnection = "server=localhost; uid=sa;pwd=**secret**; database=northwind";
string strCommand = "Select * from Customers";

SqlDataAdapter dataAdapter = newSqlDataAdapter(strCommand, strConnection);

DataSet dataset = new DataSet();

dataAdapter.Fill(dataset, "Products");
SqlCommandBuilder bldr = newSqlCommandBuilder(dataAdapter);

DataTable dataTable = dataset.Tables[0];
dgCustomer.DataSource = dataTable;
dgCustomer.DataBind();
}
}

when i run this code, error like this appear :

Server Error in '/Registeration' Application.

---

SQL Server does not exist or access denied.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:

Line 41: DataSet dataset = new DataSet();
Line 42:
Line 43: dataAdapter.Fill(dataset, "Products");
Line 44: SqlCommandBuilder bldr = new SqlCommandBuilder(dataAdapter);
Line 45:

Source File:e:\asp.net\registeration\register.aspx.cs Line:43

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
 System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
 System.Data.SqlClient.SqlConnection.Open()
 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
 Registeration.WebForm1.Page_Load(Object sender, EventArgs e) in e:\asp.net\registeration\register.aspx.cs:43
 System.Web.UI.Control.OnLoad(EventArgs e)
 System.Web.UI.Control.LoadRecursive()
 System.Web.UI.Page.ProcessRequestMain()

---

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

how can i solve this problem? thank you...

Repliedhere

Thanks

Error in connect to SQL Sever

I have a problem with the connection to the DB…

I wrote this connection string in the web.config

<addname="dbConnectionString"connectionString="server=(local);database=2C2M;Trusted_connection = True"providerName="System.Data.SqlClient"/>But then when I creat ( SQLdataSource ) and chose this connection , this message is appeared

DataBase schema could not be retrieved for this connection . Please make sure the connection setting are correct and that the database is online. An error has occurred while establishing a connection to the sever . When connection to SQL Server 2005 , this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. ( provider : Named Pipes provider , error : 40 – Could not open connection toSQL Server )

How I can solve this problem ?

Note : I use SQL EXRESS SERVER

you need to change the connection string then try it, in order to get the well formed connection string do the following:

on your desktop create a new text document and change its extension to .udl