Errors while running SQLH2 Tool

I am recieving following errors while running SQLH2
can you advice how can i resolve them
Errors:
1.InvalidOperationException Cannot read log entry number 4243737.
2.NullReferenceException Object reference not set to an instance of an
object.
3.Event Log There is no gap in history, but the
previous last event
is out of bounds
What version of SQLH2 are you running? I hope it's updated version
(2.0.024).
1. Quote from SQLH2 V2 Deployment Guide
Cannot read log entry number ###.
This error usually indicates that the event log on the target machine is
corrupted. It's easy to verify using Event Viewer - try to open the
suspected event log and check if you can read events from it (sometimes
Event Viewer is able to show the list of events, but an actual attempt to
read some events fails).
I would need more inofmation regarding the other two.
Please send a mail to SQLH2@.microsoft.com
(with your H2log.txt attached).
Thanks
Grigory
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Aneel Ismaily" <Aneel Ismaily@.discussions.microsoft.com> wrote in message
news:A219CD0B-C253-43E2-90E2-487CE248BAF3@.microsoft.com...
> I am recieving following errors while running SQLH2
> can you advice how can i resolve them
> Errors:
> 1.InvalidOperationException Cannot read log entry number 4243737.
> 2.NullReferenceException Object reference not set to an instance of
an
> object.
> 3.Event Log There is no gap in history, but the
> previous last event
> is out of bounds
>

Error:Cannot resolve collation conflict for equal to operation.

Exception information:System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.
Who can tell me how to resolve this problem?
ThxIs this an error you've seen here on the ASP.NET Forums? (After all, you've posted this message in the forum dedicated to ASP.NET Forum bugs and discussions.)

Or, is this an error in your own application? If so, I will move this thread into theSQL Server and MSDE forum.|||Maybe I made a mistake.(I just met this error in my own server with asp.net environment)|||You've got mixed collations, this typically occurs when your underlying tables collation doesn't match the servers default collation. You need to specify the collation you want to use in the query. Look up COLLATE and DATABASE_DEFAULT.

It's also a common gotcha if you're using table vars, for the same reason, the same "COLLATE database_default" does the trick.

error:40 connecting with sql server 2000

Hi
I am getting this really annoying error that I cant resolve.
I have created a website that accesses a SQL SERVER 2000 database and
it works perfectly on my home machine. The error has occurred when I
have transferred it to my hosts server.
This is the error:
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: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
This is my connection string:
<add key="ConnectionString" value="Provider=sqloledb;Data
Source=hostsserver****,1433;Initial
Catalog=db******;User Id=dbo*******;Password=********; "/>
It says I am trying to connect to a SQL SERVER 2000 database as this is
what I devloped the site on so I do not know why it thinks I am trying
to connect to SQL SERVER 2005.
Can anyone help?Is your host database server and your home database server the same? It look
s
like that your host database server is in SQL Server 2005.
By the way do you use outside host provider? If yes, you might want to
consider giving them an e-mail. Looking at the connection string, I don't se
e
any problem:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=
Your_Database_Name;UserId=Your_Username;
Password=Your_Password;" .
So I am thinking that the host database server might be on different port
number than 1433 or use a named instance?
Lucas
"chrisbarber1@.gmail.com" wrote:

> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Thanks for your reply.

> Is your host database server and your home database server the same?
Yes both are on sql server 2000

> By the way do you use outside host provider? If yes, you might want to
> consider giving them an e-mail.
The host providor has been absolutely hopeless.

> So I am thinking that the host database server might be on different port
> number than 1433 or use a named instance?
I'll look in to this although on the hosts control panel definately
says 1433.
Any other ideas?|||<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
It really sounds like the ISP is full of it and somehow your site is trying
to connect to a 2005 server with remote connections turned off.

> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Check the value of instance config parameter: "remote access" and see
whether it is enabled..
> sp_configure 'remote access'
Jayesh
<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>

error:40 connecting with sql server 2000

Hi
I am getting this really annoying error that I cant resolve.
I have created a website that accesses a SQL SERVER 2000 database and
it works perfectly on my home machine. The error has occurred when I
have transferred it to my hosts server.
This is the error:
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: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
This is my connection string:
<add key="ConnectionString" value="Provider=sqloledb;Data
Source=hostsserver****,1433;Initial
Catalog=db******;User Id=dbo*******;Password=********; "/>
It says I am trying to connect to a SQL SERVER 2000 database as this is
what I devloped the site on so I do not know why it thinks I am trying
to connect to SQL SERVER 2005.
Can anyone help?Is your host database server and your home database server the same? It looks
like that your host database server is in SQL Server 2005.
By the way do you use outside host provider? If yes, you might want to
consider giving them an e-mail. Looking at the connection string, I don't see
any problem:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;UserId=Your_Username;Password=Your_Password;" .
So I am thinking that the host database server might be on different port
number than 1433 or use a named instance?
Lucas
"chrisbarber1@.gmail.com" wrote:
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Thanks for your reply.
> Is your host database server and your home database server the same?
Yes both are on sql server 2000
> By the way do you use outside host provider? If yes, you might want to
> consider giving them an e-mail.
The host providor has been absolutely hopeless.
> So I am thinking that the host database server might be on different port
> number than 1433 or use a named instance?
I'll look in to this although on the hosts control panel definately
says 1433.
Any other ideas?|||<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
It really sounds like the ISP is full of it and somehow your site is trying
to connect to a 2005 server with remote connections turned off.
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Check the value of instance config parameter: "remote access" and see
whether it is enabled..
> sp_configure 'remote access'
Jayesh
<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> 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: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>

ERROR: System.OutOfMemoryException

How should I resolve the following error message when running report?
ERROR:
Exception of type 'System.OutOfMemoryException' was thrownBuy more RAM ¬¬
No, I'm kidding. Well, what are you exactly doing? Are you running a report
that accesses many tables or tables with many rows?|||What a great sense of humor!
However, I am just running a report via Report Manager.
http://reportserv/reports
TABLE ROWS below:
6,683
QUERY below:
SELECT Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
FROM Lists_Members AS Lists_Members INNER JOIN
List_Codes_Table AS List_Codes_Table ON
Lists_Members.LSTM_Lists_ID = List_Codes_Table.LIST_Id
GROUP BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
ORDER BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group
"F. Dwarf" wrote:
> Buy more RAM ¬¬
> No, I'm kidding. Well, what are you exactly doing? Are you running a report
> that accesses many tables or tables with many rows?|||Well, I'm still puzzled. I don't figure out what could be the problem