Error Rendering trough Web Service to WebArchivo format

Hi,
We are using the Reporting Services Web Service, in order to expose some
reports in our Web Application, right now I am trying to enable exporting the
report to the available formats in Reporting Services, and altough everything
seems to be working fine, when I try to render as Web Archive, I get the
following exception:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> The parameter is incorrect.
first I tough it was because of the device info configuration I was using,
since it was the same of the html format (which had things like turning off
the toolbar), thus I instead didnt pass any deviceinfo(null), in both cases
it works fine in all formats but it doesnt in Web Archive.
I have been searching for info about the error, but I havent found any ...
if anyone knows what is happening, I will be thankfull :) ... in the mean
time, I will keep trying, and if I find anything I will post it here.I have continued digging on the problem, I havent found anything on the
internet, and I have cleared out some things about the problem ...
so, here are some aditional info about the problem:
- it isnt only happening when I try to render the report trough the Web
Service, it also happens when I use url access.
- it is happening specifically in this report, there are other reports that
works well
- I am not using any totals/subtotals formulas (I say this, since I have
read this might cause trouble in certain rendering extensions)
- I just found something else (I have 3 reports):
- the report that is working doesnt receive any parameter
- the 2 reports that doesnt work receive 1 parameter, and additionaly have
a list of valid values ...
it looks like it were a bug, something along the lines that rendering
extension either ignores the parameters, or gets confused where there is a
list of valid values ...
Any help will be greatly appreciated ... in the mean time, I will be playing
with the reports definition, in order to find what is exactly happening, if I
dont find a solution soon I will restrict that rendering extension from being
used :(:(:( ...|||I am done with this, I am pretty certain is a bug, just not the type of bug I
tough ...
it is really weird, I played with the parameter options in the report and
the error kept happening, then I decided playing with the report design ...
well, whenever I put a third column in my report, the error happens when I
try to export it to web archive ... I put all types of definition in the
third column, to see if I managed to see anything making it fail, but didnt
arrive to anything, I tried from the simplest one (static text + no
formatting) all trough a "complex" one (formatting + dinamic text ...)

Error recording

Hi all,

I have an application in production that use a lot of stored procedures and the application doesnt record any error if any during the operation. (There is only a RESUME NEXT sentence).

So I want to know if there is a way to make SQL Server to register an error if any during the execution of a Stored Procedure without changing any of them. Say, that I want SQL Server to register an error during an execution of an user defined Stored Procedure as an internal error.

Thanks in advance.

God Bless.Is there a problem trapping the error in the application (get rid of the resume next and handle the error) ?|||Originally posted by rnealejr
Is there a problem trapping the error in the application (get rid of the resume next and handle the error) ?

Yes, the application is in the production environment and we have to solve the problem as soon as posible. If we change the code in the application then after that we should test the app, and we dont have time.|||Off the top of my head - you could use alerts (but that would be tedious) - do you know what errors you want to trap ?

error plz help

when i run my application using web parts on sql 2000 an error displayed (

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) can any one tell me why that error

)

Hi,

Please try this article on support.microsoft.com.

Article ID is 926929.

OR.

Make sure that the SQL Browser Service is started and make sure the password is correct, Because in my case customer had changed his passwords and we made sure that he changes his passwords from SSCM rather than
Services and then he was able to connect with no problems.

If you have any further issues please let me know on my e-mail ID.

Subject sould be Error code.

Thanks and Best Regards.

Farhat Nishat.

|||

i am sure that the SQL Browser Service is started and the password is correct i think that there steps done before running the web parts

because i think that web parts runs only on sql 2005 so do you know what to do to run web parts on sql2000 ?plz reply

|||

Can you check this blog? http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

If you still have problem, please copy/paste your connection string here?

error please help

any Idea why i am getting this error?

Server Error in '/endorse' Application.

---

Incorrect syntax near 'nvarchar'.

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: Incorrect syntax near 'nvarchar'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +890426 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +767130 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +404 System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary values) +447 System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +72 System.Web.UI.WebControls.DetailsView.HandleInsert(String commandArg, Boolean causesValidation) +390 System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +623 System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e) +95 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e) +109 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5104

---

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

My code is like........

<%@.PageLanguage="VB" %>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<scriptrunat="server">

</script>

<htmlxmlns="http://www.w3.org/1999/xhtml">

<headrunat="server">

<title>Untitled Page</title>

</head>

<body>

<formid="form1"runat="server">

<div>

<asp:LoginViewID="LoginView1"runat="server">

<LoggedInTemplate>

<asp:DetailsViewID="DetailsView1"runat="server"AllowPaging="True"AutoGenerateRows="False"

DataKeyNames="id"DataSourceID="SqlDataSource1"Height="50px"Width="125px">

<Fields>

<asp:BoundFieldDataField="RoomNo"HeaderText="RoomNo"SortExpression="RoomNo"/>

<asp:BoundFieldDataField="Name MR"HeaderText="Name MR"SortExpression="Name MR"/>

<asp:BoundFieldDataField="Att Resi"HeaderText="Att Resi"SortExpression="Att Resi"/>

<asp:BoundFieldDataField="Age Sex"HeaderText="Age Sex"SortExpression="Age Sex"/>

<asp:BoundFieldDataField="Adm Date"HeaderText="Adm Date"SortExpression="Adm Date"/>

<asp:BoundFieldDataField="Diagnosis"HeaderText="Diagnosis"SortExpression="Diagnosis"/>

<asp:BoundFieldDataField="Diet IVF"HeaderText="Diet IVF"SortExpression="Diet IVF"/>

<asp:BoundFieldDataField="Medications"HeaderText="Medications"SortExpression="Medications"/>

<asp:BoundFieldDataField="Consults"HeaderText="Consults"SortExpression="Consults"/>

<asp:BoundFieldDataField="Followup"HeaderText="Followup"SortExpression="Followup"/>

<asp:CommandFieldShowDeleteButton="True"ShowEditButton="True"ShowInsertButton="True"/>

</Fields>

</asp:DetailsView>

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConflictDetection="CompareAllValues"

ConnectionString="<%$ ConnectionStrings:endorseConnectionString1 %>"DeleteCommand="DELETE FROM [endorse] WHERE [id] = @.original_id AND [RoomNo] = @.original_RoomNo AND [Name MR] = @.original_Name_MR AND [Att Resi] = @.original_Att_Resi AND [Age Sex] = @.original_Age_Sex AND [Adm Date] = @.original_Adm_Date AND [Diagnosis] = @.original_Diagnosis AND [Diet IVF] = @.original_Diet_IVF AND [Medications] = @.original_Medications AND [Consults] = @.original_Consults AND [Followup] = @.original_Followup"

InsertCommand="INSERT INTO [endorse] ([RoomNo], [Name MR], [Att Resi], [Age Sex], [Adm Date], [Diagnosis], [Diet IVF], [Medications], [Consults], [Followup]) VALUES (@.RoomNo, @.Name_MR, @.Att_Resi, @.Age_Sex, @.Adm_Date, @.Diagnosis, @.Diet_IVF, @.Medications, @.Consults, @.Followup)"

OldValuesParameterFormatString="original_{0}"SelectCommand="SELECT * FROM [endorse] WHERE ([id] = @.id)"

UpdateCommand="UPDATE [endorse] SET [RoomNo] = @.RoomNo, [Name MR] = @.Name_MR, [Att Resi] = @.Att_Resi, [Age Sex] = @.Age_Sex, [Adm Date] = @.Adm_Date, [Diagnosis] = @.Diagnosis, [Diet IVF] = @.Diet_IVF, [Medications] = @.Medications, [Consults] = @.Consults, [Followup] = @.Followup WHERE [id] = @.original_id AND [RoomNo] = @.original_RoomNo AND [Name MR] = @.original_Name_MR AND [Att Resi] = @.original_Att_Resi AND [Age Sex] = @.original_Age_Sex AND [Adm Date] = @.original_Adm_Date AND [Diagnosis] = @.original_Diagnosis AND [Diet IVF] = @.original_Diet_IVF AND [Medications] = @.original_Medications AND [Consults] = @.original_Consults AND [Followup] = @.original_Followup">

<SelectParameters>

<asp:QueryStringParameterDefaultValue="0"Name="id"QueryStringField="id"Type="Int32"/>

</SelectParameters>

<DeleteParameters>

<asp:ParameterName="original_id"Type="Int32"/>

<asp:ParameterName="original_RoomNo"Type="Int32"/>

<asp:ParameterName="original_Name_MR"Type="String"/>

<asp:ParameterName="original_Att_Resi"Type="String"/>

<asp:ParameterName="original_Age_Sex"Type="String"/>

<asp:ParameterName="original_Adm_Date"Type="DateTime"/>

<asp:ParameterName="original_Diagnosis"Type="String"/>

<asp:ParameterName="original_Diet_IVF"Type="String"/>

<asp:ParameterName="original_Medications"Type="String"/>

<asp:ParameterName="original_Consults"Type="String"/>

<asp:ParameterName="original_Followup"Type="String"/>

</DeleteParameters>

<UpdateParameters>

<asp:ParameterName="RoomNo"Type="Int32"/>

<asp:ParameterName="Name_MR"Type="String"/>

<asp:ParameterName="Att_Resi"Type="String"/>

<asp:ParameterName="Age_Sex"Type="String"/>

<asp:ParameterName="Adm_Date"Type="DateTime"/>

<asp:ParameterName="Diagnosis"Type="String"/>

<asp:ParameterName="Diet_IVF"Type="String"/>

<asp:ParameterName="Medications"Type="String"/>

<asp:ParameterName="Consults"Type="String"/>

<asp:ParameterName="Followup"Type="String"/>

<asp:ParameterName="original_id"Type="Int32"/>

<asp:ParameterName="original_RoomNo"Type="Int32"/>

<asp:ParameterName="original_Name_MR"Type="String"/>

<asp:ParameterName="original_Att_Resi"Type="String"/>

<asp:ParameterName="original_Age_Sex"Type="String"/>

<asp:ParameterName="original_Adm_Date"Type="DateTime"/>

<asp:ParameterName="original_Diagnosis"Type="String"/>

<asp:ParameterName="original_Diet_IVF"Type="String"/>

<asp:ParameterName="original_Medications"Type="String"/>

<asp:ParameterName="original_Consults"Type="String"/>

<asp:ParameterName="original_Followup"Type="String"/>

</UpdateParameters>

<InsertParameters>

<asp:ParameterName="RoomNo"Type="Int32"/>

<asp:ParameterName="Name_MR"Type="String"/>

<asp:ParameterName="Att_Resi"Type="String"/>

<asp:ParameterName="Age_Sex"Type="String"/>

<asp:ParameterName="Adm_Date"Type="DateTime"/>

<asp:ParameterName="Diagnosis"Type="String"/>

<asp:ParameterName="Diet_IVF"Type="String"/>

<asp:ParameterName="Medications"Type="String"/>

<asp:ParameterName="Consults"Type="String"/>

<asp:ParameterName="Followup"Type="String"/>

</InsertParameters>

</asp:SqlDataSource>

</LoggedInTemplate>

<AnonymousTemplate>

you are not logged in.

</AnonymousTemplate>

</asp:LoginView>

</div>

</form>

</body>

</html>

Here is a wild shot in the dark...

I notice there is a field called Age_Sex. Is it possible the data being inserted has a comma between the two data items?

Even if it isn't causing the problem, having two data items in one field certainly will raise some eyebrows, if not some havoc.

|||

Thanks for your reply steve,

I tried to remove the comma from the data fields and still the same error. I don't want to many columns in the table thats why i am combining the fields, I know database design is not efficient in that way but it is surving the purpose for me.

If you could help further I will appriciate it.

Thanks again.

Error on viewing Crystal Report

hello,

i designed an application containing Crystal Report in VB.NET and viewed the application and Report successfully on my system. But when i try to execute the same packaged application on a different system, i get an error message saying that a dll cannot be found or invalid code.

Please help me to debug the application.check the CrystalRuntime|||You need to install Crystal Report Runtime module.
Please check this thread (http://www.dev-archive.com/forum/showthread.php?t=432198).

Error on VB Sample which is delivered by installation.

Hi,

after i try to build the web application "Web Development - Data Entry Form" i get the following error message. I already change the variable username to system which is defined in Machine.Config.

The Error messega is like following:
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.

Thanks,The username you see in machine.config is most likely not the username you want to provide in the connection string in your application. You need to provide a valid username and password for your SQL server. If you did not install the db server yourself, you should be able to get valid login info from the person who installed it.

If the db server is local, you might be able to get away with the following for your connection string: "server=localhost;TrustedConnection=true;database=YOUR_DB"

error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

hi,

i'm using SQL Server CE 2.0 in my application.
When i try to synchronize my database by calling

replicator.Synchronize();
errors :
Initializing SQL Server Reconciler has failed.
process could not connect to Distributor
SQL Server does not exists and access denied.

what i did right now is i try to register

regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll"
regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll"

both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!!

I do not know what's going wrong..=(

Who can help me?!!! HELP~~~~~~~~~

thanks..

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.|||Just my two cents....

Also check whether you are able to browse the URL or not
/VirtualDirectoryName/sscesa20.dll">http://<IIS-Box-Name>/VirtualDirectoryName/sscesa20.dll from device?
Are you able to browse the general internet/intranet from the device?
If you are able to do both of the above then both connectivity on the device and on the IIS are setup correctly.|||Hi June...
I am also facing the same problem regarding the Initializing SQL Server Reconciler has failed using SQL Server CE 2.0......in my case it happened when i raised the data size in the database befor sync. Actually i am new to this tech can u pls tell me in detail bout wat xactly these dll are for and how to run
"both of the DLL files were succeed register" wat does this mean...pls do take some of ur time to answer my query.It will be a gr8 help from ur side.....

Thanks in advance to you.
Regards,
Asheesh.|||I'm sorry for late response..I've been disconnected from Internet for few days...
By the way, how to connect to my distributor. Actually my distributor is same as my publisher...|||when i type http://IP_address/Virtual_dir_alias/sscesa20.dll

the SQL Server CE Server Agent is shown in my browser|||Hi, Asheesh...

I facing this problem just i try to pull a table from my SQL Server 2000 to my emulator's local database using SQL Server Ce 2.0. I did not try to raise my data size since i just want to create a new database for my emulator. However, i assume i succeed to connect my sscesa20.dll since when i try to browse sscesa20.dll, SQL Server Ce Server Agent message is shown in my browser (no matter in desktop IE or emulator IE)

I try to search online, some suggest that the error occur because of the DLL file that correspond to the SQL Server CE Replication provider is not registered on the computer where SQL Server CE Server Tools is installed. That's y i tried to manually register this DLL file.|||

Mahesh Dudgikar wrote:

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.

Hi Mahesh,

thanks for reply...

what is SAC...^^;;
i do not know what is that...?

thanks

best regards,
june|||

Hi June,
SAC is Surface Area Configuration Tool that lets you manage how connections are done to this instance of SQL Server.
To access it Click on Start-->All Programs-->Microsoft SQL Server-->Configuration Tools-->SQL Server Surface Area Configuration-->Surface Area Configuration for Services and Connections-->DataBase Engine-->Remote Connections-->Local and Remote conenctions-->Using both TCP/IP and named pipes.
Then recycle the server.

Also try connecting to the SQL Server from a remote machine using osql to see if you can connect to the server.

|||Hi Mahesh,

I'm sorry, i didn't mention my SQL Server version in my previous message. Actually i'm using SQL Server 2000...I'm not sure whether SQL Server 2000 having SAC feature..However, i didn't get Configuration Tools in from my MS SQL Server folder...:(

thanks...

june|||And I assumed this was SQL Server 2005 :) dont know why I was under that impression. SAC is only with SQL Server 2005.

So now, you have SQL Server 200 SP3 or SP4?
Can you also try registering replrec.dll? This should be in %ProgramFiles%\Microsoft SQL Server\80\COM directory and retry the synch please.|||June, Could you also please post the connection string you are using to connect to the server.|||Hi,

i'm using SP3a for my SQL Server 2000.
I registered the replrec.dll and re-sync..the error still remain

error messages:
initializing SQL Server Reconciler has failed
process could not connect to Distributor
SQL Server does not exist or access denied..
=(|||Few more questions:
1. Have youever synched successfully previously with this device (subscriber) and publisher?
2. Is this reinitializing?
3. What about permissions for snapshot folder and other items for IIS/SQL Server service. When you setup the virtual directory did you provide all the accounts permissions?|||

ok...my replication declaration:

private const string INTERNETURL = "http://localhost/Northwind/sscesa20.dll";
private const string PUBLISHERSERVER = "TWEEDLEDEE";
private const string PUBLISHERDATABASE = "Northwind";
private const SecurityType PUBLISHERSECURITYMODE =
SecurityType.NTAuthentication;
private const string PUBLICATION = "NorthwindProducts";
private string SUBSCRIBER = Dns.GetHostName();
private const string LOCALDATABASE = "\\My Documents\\products.sdf";
private const string CONNECTIONSTRING = "data source = " + LOCALDATABASE;

i do not sure is it my snapshot folder problem...i'm confuse to the snapshot folder that i created during creating my publication and during set up my virtual directory folder. When i create my publication, my snapshot is C:\Labs\Snapshot (i follow the tutorial)
However, when i set up my virtual directory and enter d same path (C:\Labs\Snapshot), it pop up a message said unable to found the file. Then i enter the snapshot folder as
\\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\ReplData

HOWEVER, when i check out my snapshot location using Enterprise Server
there stated it as \\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\REPLDATA
under generate snapshot in the following location

error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

hi,

i'm using SQL Server CE 2.0 in my application.
When i try to synchronize my database by calling

replicator.Synchronize();
errors :
Initializing SQL Server Reconciler has failed.
process could not connect to Distributor
SQL Server does not exists and access denied.

what i did right now is i try to register

regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll"
regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll"

both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!!

I do not know what's going wrong..=(

Who can help me?!!! HELP~~~~~~~~~

thanks..

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.|||Just my two cents....

Also check whether you are able to browse the URL or not
/VirtualDirectoryName/sscesa20.dll">http://<IIS-Box-Name>/VirtualDirectoryName/sscesa20.dll from device?
Are you able to browse the general internet/intranet from the device?
If you are able to do both of the above then both connectivity on the device and on the IIS are setup correctly.|||Hi June...
I am also facing the same problem regarding the Initializing SQL Server Reconciler has failed using SQL Server CE 2.0......in my case it happened when i raised the data size in the database befor sync. Actually i am new to this tech can u pls tell me in detail bout wat xactly these dll are for and how to run
"both of the DLL files were succeed register" wat does this mean...pls do take some of ur time to answer my query.It will be a gr8 help from ur side.....

Thanks in advance to you.
Regards,
Asheesh.|||I'm sorry for late response..I've been disconnected from Internet for few days...
By the way, how to connect to my distributor. Actually my distributor is same as my publisher...|||when i type http://IP_address/Virtual_dir_alias/sscesa20.dll

the SQL Server CE Server Agent is shown in my browser|||Hi, Asheesh...

I facing this problem just i try to pull a table from my SQL Server 2000 to my emulator's local database using SQL Server Ce 2.0. I did not try to raise my data size since i just want to create a new database for my emulator. However, i assume i succeed to connect my sscesa20.dll since when i try to browse sscesa20.dll, SQL Server Ce Server Agent message is shown in my browser (no matter in desktop IE or emulator IE)

I try to search online, some suggest that the error occur because of the DLL file that correspond to the SQL Server CE Replication provider is not registered on the computer where SQL Server CE Server Tools is installed. That's y i tried to manually register this DLL file.|||

Mahesh Dudgikar wrote:

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.

Hi Mahesh,

thanks for reply...

what is SAC...^^;;
i do not know what is that...?

thanks

best regards,
june|||

Hi June,
SAC is Surface Area Configuration Tool that lets you manage how connections are done to this instance of SQL Server.
To access it Click on Start-->All Programs-->Microsoft SQL Server-->Configuration Tools-->SQL Server Surface Area Configuration-->Surface Area Configuration for Services and Connections-->DataBase Engine-->Remote Connections-->Local and Remote conenctions-->Using both TCP/IP and named pipes.
Then recycle the server.

Also try connecting to the SQL Server from a remote machine using osql to see if you can connect to the server.

|||Hi Mahesh,

I'm sorry, i didn't mention my SQL Server version in my previous message. Actually i'm using SQL Server 2000...I'm not sure whether SQL Server 2000 having SAC feature..However, i didn't get Configuration Tools in from my MS SQL Server folder...:(

thanks...

june|||And I assumed this was SQL Server 2005 :) dont know why I was under that impression. SAC is only with SQL Server 2005.

So now, you have SQL Server 200 SP3 or SP4?
Can you also try registering replrec.dll? This should be in %ProgramFiles%\Microsoft SQL Server\80\COM directory and retry the synch please.|||June, Could you also please post the connection string you are using to connect to the server.|||Hi,

i'm using SP3a for my SQL Server 2000.
I registered the replrec.dll and re-sync..the error still remain

error messages:
initializing SQL Server Reconciler has failed
process could not connect to Distributor
SQL Server does not exist or access denied..
=(|||Few more questions:
1. Have youever synched successfully previously with this device (subscriber) and publisher?
2. Is this reinitializing?
3. What about permissions for snapshot folder and other items for IIS/SQL Server service. When you setup the virtual directory did you provide all the accounts permissions?|||

ok...my replication declaration:

private const string INTERNETURL = "http://localhost/Northwind/sscesa20.dll";
private const string PUBLISHERSERVER = "TWEEDLEDEE";
private const string PUBLISHERDATABASE = "Northwind";
private const SecurityType PUBLISHERSECURITYMODE =
SecurityType.NTAuthentication;
private const string PUBLICATION = "NorthwindProducts";
private string SUBSCRIBER = Dns.GetHostName();
private const string LOCALDATABASE = "\\My Documents\\products.sdf";
private const string CONNECTIONSTRING = "data source = " + LOCALDATABASE;

i do not sure is it my snapshot folder problem...i'm confuse to the snapshot folder that i created during creating my publication and during set up my virtual directory folder. When i create my publication, my snapshot is C:\Labs\Snapshot (i follow the tutorial)
However, when i set up my virtual directory and enter d same path (C:\Labs\Snapshot), it pop up a message said unable to found the file. Then i enter the snapshot folder as
\\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\ReplData

HOWEVER, when i check out my snapshot location using Enterprise Server
there stated it as \\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\REPLDATA
under generate snapshot in the following location

error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

hi,

i'm using SQL Server CE 2.0 in my application.
When i try to synchronize my database by calling

replicator.Synchronize();
errors :
Initializing SQL Server Reconciler has failed.
process could not connect to Distributor
SQL Server does not exists and access denied.

what i did right now is i try to register

regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll"
regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll"

both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!!

I do not know what's going wrong..=(

Who can help me?!!! HELP~~~~~~~~~

thanks..

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.|||Just my two cents....

Also check whether you are able to browse the URL or not
/VirtualDirectoryName/sscesa20.dll">http://<IIS-Box-Name>/VirtualDirectoryName/sscesa20.dll from device?
Are you able to browse the general internet/intranet from the device?
If you are able to do both of the above then both connectivity on the device and on the IIS are setup correctly.|||Hi June...
I am also facing the same problem regarding the Initializing SQL Server Reconciler has failed using SQL Server CE 2.0......in my case it happened when i raised the data size in the database befor sync. Actually i am new to this tech can u pls tell me in detail bout wat xactly these dll are for and how to run
"both of the DLL files were succeed register" wat does this mean...pls do take some of ur time to answer my query.It will be a gr8 help from ur side.....

Thanks in advance to you.
Regards,
Asheesh.|||I'm sorry for late response..I've been disconnected from Internet for few days...
By the way, how to connect to my distributor. Actually my distributor is same as my publisher...|||when i type http://IP_address/Virtual_dir_alias/sscesa20.dll

the SQL Server CE Server Agent is shown in my browser|||Hi, Asheesh...

I facing this problem just i try to pull a table from my SQL Server 2000 to my emulator's local database using SQL Server Ce 2.0. I did not try to raise my data size since i just want to create a new database for my emulator. However, i assume i succeed to connect my sscesa20.dll since when i try to browse sscesa20.dll, SQL Server Ce Server Agent message is shown in my browser (no matter in desktop IE or emulator IE)

I try to search online, some suggest that the error occur because of the DLL file that correspond to the SQL Server CE Replication provider is not registered on the computer where SQL Server CE Server Tools is installed. That's y i tried to manually register this DLL file.|||

Mahesh Dudgikar wrote:

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.

Hi Mahesh,

thanks for reply...

what is SAC...^^;;
i do not know what is that...?

thanks

best regards,
june|||

Hi June,
SAC is Surface Area Configuration Tool that lets you manage how connections are done to this instance of SQL Server.
To access it Click on Start-->All Programs-->Microsoft SQL Server-->Configuration Tools-->SQL Server Surface Area Configuration-->Surface Area Configuration for Services and Connections-->DataBase Engine-->Remote Connections-->Local and Remote conenctions-->Using both TCP/IP and named pipes.
Then recycle the server.

Also try connecting to the SQL Server from a remote machine using osql to see if you can connect to the server.

|||Hi Mahesh,

I'm sorry, i didn't mention my SQL Server version in my previous message. Actually i'm using SQL Server 2000...I'm not sure whether SQL Server 2000 having SAC feature..However, i didn't get Configuration Tools in from my MS SQL Server folder...:(

thanks...

june|||And I assumed this was SQL Server 2005 :) dont know why I was under that impression. SAC is only with SQL Server 2005.

So now, you have SQL Server 200 SP3 or SP4?
Can you also try registering replrec.dll? This should be in %ProgramFiles%\Microsoft SQL Server\80\COM directory and retry the synch please.|||June, Could you also please post the connection string you are using to connect to the server.|||Hi,

i'm using SP3a for my SQL Server 2000.
I registered the replrec.dll and re-sync..the error still remain

error messages:
initializing SQL Server Reconciler has failed
process could not connect to Distributor
SQL Server does not exist or access denied..
=(|||Few more questions:
1. Have youever synched successfully previously with this device (subscriber) and publisher?
2. Is this reinitializing?
3. What about permissions for snapshot folder and other items for IIS/SQL Server service. When you setup the virtual directory did you provide all the accounts permissions?|||

ok...my replication declaration:

private const string INTERNETURL = "http://localhost/Northwind/sscesa20.dll";
private const string PUBLISHERSERVER = "TWEEDLEDEE";
private const string PUBLISHERDATABASE = "Northwind";
private const SecurityType PUBLISHERSECURITYMODE =
SecurityType.NTAuthentication;
private const string PUBLICATION = "NorthwindProducts";
private string SUBSCRIBER = Dns.GetHostName();
private const string LOCALDATABASE = "\\My Documents\\products.sdf";
private const string CONNECTIONSTRING = "data source = " + LOCALDATABASE;

i do not sure is it my snapshot folder problem...i'm confuse to the snapshot folder that i created during creating my publication and during set up my virtual directory folder. When i create my publication, my snapshot is C:\Labs\Snapshot (i follow the tutorial)
However, when i set up my virtual directory and enter d same path (C:\Labs\Snapshot), it pop up a message said unable to found the file. Then i enter the snapshot folder as
\\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\ReplData

HOWEVER, when i check out my snapshot location using Enterprise Server
there stated it as \\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\REPLDATA
under generate snapshot in the following location

Error Number: -2147217900

we have an ASP based intranet application that creates a job, adds the steps
and starts the job all using ASP script. This is working for many years
without any issue. The reason we went this route is to see the activities of
this job from another ASP page in an asynchronized way. But lately we ran
into the following error. Any help/clu on this is appreciated.
Error Creating SQL Job failed
Error information:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Number: -2147217900
Error Description: Distributed transaction completed. Either enlist this
session in a new transaction or the NULL transaction.
Can anyone lend some help on this please?
"MSFT Developer" <MSFTDeveloper@.DeveloperNet.Net> wrote in message
news:O9CZhqukFHA.3336@.tk2msftngp13.phx.gbl...
> we have an ASP based intranet application that creates a job, adds the
> steps and starts the job all using ASP script. This is working for many
> years without any issue. The reason we went this route is to see the
> activities of this job from another ASP page in an asynchronized way. But
> lately we ran into the following error. Any help/clu on this is
> appreciated.
> Error Creating SQL Job failed
> Error information:
> Error Source: Microsoft OLE DB Provider for SQL Server
> Error Number: -2147217900
> Error Description: Distributed transaction completed. Either enlist this
> session in a new transaction or the NULL transaction.
>
>
>

Error Number: -2147217900

we have an ASP based intranet application that creates a job, adds the steps
and starts the job all using ASP script. This is working for many years
without any issue. The reason we went this route is to see the activities of
this job from another ASP page in an asynchronized way. But lately we ran
into the following error. Any help/clu on this is appreciated.
Error Creating SQL Job failed
Error information:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Number: -2147217900
Error Description: Distributed transaction completed. Either enlist this
session in a new transaction or the NULL transaction.Can anyone lend some help on this please?
"MSFT Developer" <MSFTDeveloper@.DeveloperNet.Net> wrote in message
news:O9CZhqukFHA.3336@.tk2msftngp13.phx.gbl...
> we have an ASP based intranet application that creates a job, adds the
> steps and starts the job all using ASP script. This is working for many
> years without any issue. The reason we went this route is to see the
> activities of this job from another ASP page in an asynchronized way. But
> lately we ran into the following error. Any help/clu on this is
> appreciated.
> Error Creating SQL Job failed
> Error information:
> Error Source: Microsoft OLE DB Provider for SQL Server
> Error Number: -2147217900
> Error Description: Distributed transaction completed. Either enlist this
> session in a new transaction or the NULL transaction.
>
>
>|||Go to MSDTC time out settings and increase the Transaction timeout to
some appropriate value(greater then what it was before). if the error
was caused due to tranaction timeouts then this is the solution. Other
wise NO CLUE :-(
maicalal
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1757334.html|||Go to MSDTC time out settings and increase the Transaction timeout to
some appropriate value(greater then what it was before). if the error
was caused due to tranaction timeouts then this is the solution. Other
wise NO CLUE :-(
maicalal
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1757334.html

Error Number: -2147217900

we have an ASP based intranet application that creates a job, adds the steps
and starts the job all using ASP script. This is working for many years
without any issue. The reason we went this route is to see the activities of
this job from another ASP page in an asynchronized way. But lately we ran
into the following error. Any help/clu on this is appreciated.
Error Creating SQL Job failed
Error information:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Number: -2147217900
Error Description: Distributed transaction completed. Either enlist this
session in a new transaction or the NULL transaction.Can anyone lend some help on this please?
"MSFT Developer" <MSFTDeveloper@.DeveloperNet.Net> wrote in message
news:O9CZhqukFHA.3336@.tk2msftngp13.phx.gbl...
> we have an ASP based intranet application that creates a job, adds the
> steps and starts the job all using ASP script. This is working for many
> years without any issue. The reason we went this route is to see the
> activities of this job from another ASP page in an asynchronized way. But
> lately we ran into the following error. Any help/clu on this is
> appreciated.
> Error Creating SQL Job failed
> Error information:
> Error Source: Microsoft OLE DB Provider for SQL Server
> Error Number: -2147217900
> Error Description: Distributed transaction completed. Either enlist this
> session in a new transaction or the NULL transaction.
>
>
>

Error Number - 10040 - Invalid error handling

Any answer to this error message will be appreacited. Gets
this when an application is ran on sql server 2000
database on production. The same application works fine on
test database even after refreshing of the test with a
copy of production database is still works fine on test
databse on test server and not on production.
Thanks,
Henry.Aboki (waco361@.hotmail.com) writes:
> Any answer to this error message will be appreacited. Gets
> this when an application is ran on sql server 2000
> database on production. The same application works fine on
> test database even after refreshing of the test with a
> copy of production database is still works fine on test
> databse on test server and not on production.
There does not seem to be any message 10040 in master..sysmessages. Can
you post the completely error message with prefixes and all, so we
can get an idea from where the error message might come?
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||Is this error being generated by the application rather than SQL Server ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Aboki" <waco361@.hotmail.com> wrote in message
news:02cf01c34d6c$5ed1a470$a401280a@.phx.gbl...
Any answer to this error message will be appreacited. Gets
this when an application is ran on sql server 2000
database on production. The same application works fine on
test database even after refreshing of the test with a
copy of production database is still works fine on test
databse on test server and not on production.
Thanks,
Henry.

Error Number - 10040 - Invalid error handling

Any answer to this error message will be appreacited. Gets
this when an application is ran on sql server 2000
database on production. The same application works fine on
test database even after refreshing of the test with a
copy of production database is still works fine on test
databse on test server and not on production.
Thanks,
Henry.Aboki (waco361@.hotmail.com) writes:
> Any answer to this error message will be appreacited. Gets
> this when an application is ran on sql server 2000
> database on production. The same application works fine on
> test database even after refreshing of the test with a
> copy of production database is still works fine on test
> databse on test server and not on production.
There does not seem to be any message 10040 in master..sysmessages. Can
you post the completely error message with prefixes and all, so we
can get an idea from where the error message might come?
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||Is this error being generated by the application rather than SQL Server ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Aboki" <waco361@.hotmail.com> wrote in message
news:02cf01c34d6c$5ed1a470$a401280a@.phx.gbl...
Any answer to this error message will be appreacited. Gets
this when an application is ran on sql server 2000
database on production. The same application works fine on
test database even after refreshing of the test with a
copy of production database is still works fine on test
databse on test server and not on production.
Thanks,
Henry.

Error messages of return codes of SQL installer

Hi all,

I have one application through which i m installing SQL Server 2005 Express Edition.

If some failure occures, all I get is one exitCode which is a return code of SQL Express installer. Is there any way by which I can find out the exact reason of failure.

One example is error code 28062.

This error code is for "sql is unable to install on compressed folder / drive".

Please help

Thanks and regards,

-Anup

Are you using either encrypted or compressed drives where you want to install the edition on ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error Message: Transaction cannot start while in firehose mode

Hi,
I am dealing with an application where the back-end is SqlServer2000. There
is a master table where one filed is empty that needs to be filled in with
correct value. As I am trying to add the value to this field on a particular
row, I am getting the following message: Transaction cannot start while in
firehose mode. Now I am planning to send a update command to the particular
row to fill in the blank value for the field concerned. However, before I do
that I just want to know, why I am getting the above error. Any help is
appreciated. Thanks.> As I am trying to add the value to this field on a particular row
How are you "trying to add the value"? An update statement, a stored
procedure call, pasting into Enterprise Manager's "Open Table" view, ...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||I was trying to add the blank field value from Enterprise Manager, by right
clicking and opening the table and choosing all row option and then going to
the right record and the blank field to fill it up. At this point, I got the
above message. I would like to know why I am getting such message and is it
safe to run a update query to update the blank field in one record via Query
Analyzer. Thanks
"Aaron [SQL Server MVP]" wrote:
> > As I am trying to add the value to this field on a particular row
> How are you "trying to add the value"? An update statement, a stored
> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||If your table has a primary key (or a unique way to identify a single row),
then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
Manager has its purposes, but data manipulation is not one of them. Please
have a look through this article: http://www.aspfaq.com/2455
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> I was trying to add the blank field value from Enterprise Manager, by
right
> clicking and opening the table and choosing all row option and then going
to
> the right record and the blank field to fill it up. At this point, I got
the
> above message. I would like to know why I am getting such message and is
it
> safe to run a update query to update the blank field in one record via
Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
> > > As I am trying to add the value to this field on a particular row
> >
> > How are you "trying to add the value"? An update statement, a stored
> > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >|||Thanks for the help Aaron. I appreciate it.
"Aaron [SQL Server MVP]" wrote:
> If your table has a primary key (or a unique way to identify a single row),
> then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
> Manager has its purposes, but data manipulation is not one of them. Please
> have a look through this article: http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jack" <Jack@.discussions.microsoft.com> wrote in message
> news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> > I was trying to add the blank field value from Enterprise Manager, by
> right
> > clicking and opening the table and choosing all row option and then going
> to
> > the right record and the blank field to fill it up. At this point, I got
> the
> > above message. I would like to know why I am getting such message and is
> it
> > safe to run a update query to update the blank field in one record via
> Query
> > Analyzer. Thanks
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > > As I am trying to add the value to this field on a particular row
> > >
> > > How are you "trying to add the value"? An update statement, a stored
> > > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> > >
>
>|||Chances are the table does not have a valid PK and is causing the error.
--
Andrew J. Kelly SQL MVP
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
>I was trying to add the blank field value from Enterprise Manager, by right
> clicking and opening the table and choosing all row option and then going
> to
> the right record and the blank field to fill it up. At this point, I got
> the
> above message. I would like to know why I am getting such message and is
> it
> safe to run a update query to update the blank field in one record via
> Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
>> > As I am trying to add the value to this field on a particular row
>> How are you "trying to add the value"? An update statement, a stored
>> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>

Error message: String or binary data truncated

Hi, all!
I encountered that error message while testing my application using
MSDE. It appears when I issue this type of statement:
INSERT INT atable (Col1, Col2, ...)
VALUES (Val1, Val2,...)
The string columns are of type 'char'.
The strange is that the message does not appear always. In one case I
had error in two consecutive executions of the query. After that, in the
3rd execution *with exactly the same data!* all went OK!? I cannot
understand where lies the problem.
The same thing does not happen at all when testing with MS SQL Server 2000.
Please, can somebody give me a hint about what probably goes on.
hi Lazar,
Lazar Videnov wrote:
> Hi, all!
> I encountered that error message while testing my application using
> MSDE. It appears when I issue this type of statement:
> INSERT INT atable (Col1, Col2, ...)
> VALUES (Val1, Val2,...)
> The string columns are of type 'char'.
> The strange is that the message does not appear always. In one case I
> had error in two consecutive executions of the query. After that, in
> the 3rd execution *with exactly the same data!* all went OK!? I cannot
> understand where lies the problem.
> The same thing does not happen at all when testing with MS SQL Server
> 2000.
> Please, can somebody give me a hint about what probably goes on.
are you sure this is not depending on the provided values exceeding the
maximum storage of the columns?
DECLARE @.t TABLE (
c char(5)
)
INSERT INTO @.t VALUES ( 'abcdefghi' )
--<--
Server: Msg 8152, Level 16, State 9, Line 4
String or binary data would be truncated.
The statement has been terminated.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
Actually, I don't do any checks for exceeding the storage space in the
string columns. I thought about that, but the strange is that this error
happens only sometimes. That is why I'm curious. And, as I wrote, it
works all fine in MS SQL Server 2000. I thought that the server just
trims the data and everything is OK.
Now, I'll make sure that I pass strings with length less than the
definition of the column, and I'll test again.
thanks

error message!

Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
--
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(S1T00) Native Err:(0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(S1T00) Native Err:(0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-RobYou are seeing a timeout error. You can find some general info on this at:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <rob@.nul.ca> wrote in message
news:012301c3d93a$f2ebb510$a401280a@.phx.gbl...
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
--
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(S1T00) Native Err:(0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(S1T00) Native Err:(0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-Rob|||Hi Rob,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Before we go any further, I would like to collect more information from you:
1. Can you please tell me how you run this batch? Do you run it in an ADO
application?
2. What is the connection string? Which provider you use to connect to SQL
Server?
3. When does the timeout error occur? Are you sure that the timeout error
occurred when your customer performed the batch?
In the following situations I agree with Vyas:
1. If you ran the batch in an ADO application
2. If the timeout error occurred, when your customer was running the batch
but not when they were connected to SQL Serer.
3. If the batch works fine using Query Analyzer.
As we know, there are two kinds of timeout in ADO: connection timeout and
query timeout. The default connectiontimeout is 15 seconds. The default
commandtimeout is 30 seconds. If the system is overloaded, the default
value may be too small, please increase these value to see if the problem
still occur.
con.connectiontimeout=150
con.commandtimeout=300
Also, the root solution is that you can improve the query performance to
decrease the execution time.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
I dont know how to increase the timeout?
where is the following settings?
con.connectiontimeout=150
con.commandtimeout=300
Thanks-Rob
>--Original Message--
>Hi Rob,
>My name is Michael and I would like to thank you for
using Microsoft
>newsgroup.
>Before we go any further, I would like to collect more
information from you:
>1. Can you please tell me how you run this batch? Do you
run it in an ADO
>application?
>2. What is the connection string? Which provider you use
to connect to SQL
>Server?
>3. When does the timeout error occur? Are you sure that
the timeout error
>occurred when your customer performed the batch?
>In the following situations I agree with Vyas:
>1. If you ran the batch in an ADO application
>2. If the timeout error occurred, when your customer was
running the batch
>but not when they were connected to SQL Serer.
>3. If the batch works fine using Query Analyzer.
>As we know, there are two kinds of timeout in ADO:
connection timeout and
>query timeout. The default connectiontimeout is 15
seconds. The default
>commandtimeout is 30 seconds. If the system is
overloaded, the default
>value may be too small, please increase these value to
see if the problem
>still occur.
>con.connectiontimeout=150
>con.commandtimeout=300
>Also, the root solution is that you can improve the query
performance to
>decrease the execution time.
>Thanks for using Microsoft newsgroup.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Hi Rob,
Thanks for your feedback. CommandTimeout Property in ADO indicates how long
to wait while executing a command before terminating the attempt and
generating an error.
CommandTimeout Property
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdapro02_5.asp
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

error message!

Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATES1T00) Native Err0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATES1T00) Native Err0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-RobYou are seeing a timeout error. You can find some general info on this at:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <rob@.nul.ca> wrote in message
news:012301c3d93a$f2ebb510$a401280a@.phx.gbl...
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATES1T00) Native Err0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATES1T00) Native Err0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-Rob|||Hi Rob,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Before we go any further, I would like to collect more information from you:
1. Can you please tell me how you run this batch? Do you run it in an ADO
application?
2. What is the connection string? Which provider you use to connect to SQL
Server?
3. When does the timeout error occur? Are you sure that the timeout error
occurred when your customer performed the batch?
In the following situations I agree with Vyas:
1. If you ran the batch in an ADO application
2. If the timeout error occurred, when your customer was running the batch
but not when they were connected to SQL Serer.
3. If the batch works fine using Query Analyzer.
As we know, there are two kinds of timeout in ADO: connection timeout and
query timeout. The default connectiontimeout is 15 seconds. The default
commandtimeout is 30 seconds. If the system is overloaded, the default
value may be too small, please increase these value to see if the problem
still occur.
con.connectiontimeout=150
con.commandtimeout=300
Also, the root solution is that you can improve the query performance to
decrease the execution time.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
I dont know how to increase the timeout?
where is the following settings?
con.connectiontimeout=150
con.commandtimeout=300
Thanks-Rob

quote:

---

>--Original Message--
>Hi Rob,
>My name is Michael and I would like to thank you for

---

using Microsoft

quote:

---

>newsgroup.
>Before we go any further, I would like to collect more

---

information from you:

quote:

---

>1. Can you please tell me how you run this batch? Do you

---

run it in an ADO

quote:

---

>application?
>2. What is the connection string? Which provider you use

---

to connect to SQL

quote:

---

>Server?
>3. When does the timeout error occur? Are you sure that

---

the timeout error

quote:

---

>occurred when your customer performed the batch?
>In the following situations I agree with Vyas:
>1. If you ran the batch in an ADO application
>2. If the timeout error occurred, when your customer was

---

running the batch

quote:

---

>but not when they were connected to SQL Serer.
>3. If the batch works fine using Query Analyzer.
>As we know, there are two kinds of timeout in ADO:

---

connection timeout and

quote:

---

>query timeout. The default connectiontimeout is 15

---

seconds. The default

quote:

---

>commandtimeout is 30 seconds. If the system is

---

overloaded, the default

quote:

---

>value may be too small, please increase these value to

---

see if the problem

quote:

---

>still occur.
>con.connectiontimeout=150
>con.commandtimeout=300
>Also, the root solution is that you can improve the query

---

performance to

quote:

---

>decrease the execution time.
>Thanks for using Microsoft newsgroup.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and

---

confers no rights.

quote:

---

>.
>

---

|||Hi Rob,
Thanks for your feedback. CommandTimeout Property in ADO indicates how long
to wait while executing a command before terminating the attempt and
generating an error.
CommandTimeout Property
http://msdn.microsoft.com/library/d...-us/ado270/htm/
mdapro02_5.asp
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Error Message with Recordset.Update

Hi,

I am converting a VB6 application to C# using ADO. I have the following code:

private ADODB.Connection cn = new ADODB.Connection();
private ADODB.Recordset rs = new ADODB.Recordset();

private connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source= " + stdDir;
strClientSQL = "SELECT * FROM Client ORDER BY casename, renldate, product, fundingcode";

cn.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
cn.Open(Utilities.connectionString,null,null,0);

rs.CursorLocation = ADODB.CursorLocationEnum.adUseServer;
rs.Open(strClientSQL,cn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic,-1);

rs.Fields["CaseName"].Value = this.txtCaseName.Text;

rs.Fields["CaseNo"].Value = this.txtCaseNumber.Text;

rs.Update();

When I try to compile and run it I get the following error message:

"No overload for method 'Update' takes '0' arguments"

I am not sure if I need to enter information in the update command or do something else. This seems pretty straight forward but I can't figure out how to do it. Can someone please help me?

Thanks,

Mark

The thing is that you have to place the fieldas and its values in the function, like this:

rsMsg.Update("Field1,Field2,Field3", "Value1,Value2,Value3");

But i supossed that you want to update the whole recordset, am i rigth?
That's a good question.... give me some time to answer that.

Hugo|||try without the parenthesis

rs.Update