General network error. Check your network documentation

Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

Hello my friend,

Are you using forms authentication? If so, are you using a SQL Server Express database to handle the users and roles? If so, you need to change this so it uses a full proper SQL Server, not the Express version. I made a guess that you may be doing this because the error involves OpenAndLogin(). The Express version is just for development, not recommended for production. If I have guessed incorrectly, then I am sorry.

Kind regards

Scotty

|||

Hi Scotty,

Thanks for your information. But We are using SQL Server Enterprise edition. its full version. Please let me know if you have any information.

sql

General Network Error - MS Stumped

I've been working with Microsoft support for over 3 weeks now on an
intermittent General Network Error we're seeing in our production
environment between our ASP.NET application and SQL Server 2000. They are
continuing to work on the issue, but it seems as if our progress is grinding
to a halt. I asked this question on the newsgroups before going to MS but
figured I'd give it another shot now that I have more information.
The problem occurs intermittently (maybe 10 to 15 times per day). It seems
to be related to queries that return "large" amounts of data from SQL. The
problem started after we made an equipment change. We went from a single
server hosting both our ASP.NET application and SQL Server 2000, to one
server hosting IIS and another machine running SQL. An example of the
exception thrown appears at the bottom of this post.
MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS machine,
MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server. The MS
rep found nothing too out of the ordinary with our configuration, so he
asked me to do a network capture on both machines while the error occurred.
I was able to get a good capture in a small window and sent it off to MS.
The verdict is that IIS is basically halting the request. It is resetting
the database connection partway through retrieving the results of the stored
proc. IIS attempts to close the connection for some reason, SQL ignores and
keeps pumping back data, then IIS raises a reset. MS confirmed that there
is no packet loss. MS has not determined why this is happening and has not
advised me to capture any additional data.
If someone has any ideas, I am willing to provide as much detail as
possible. I wanted to keep this initial post as concise as possible.
Thanks for any assistance you can provide,
-joe
EXCEPTION:
System.Data.SqlClient.SqlException: General network error. Check your
network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
offset, Int32 len)
at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
Encoding encoding)
at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md, Int32
length)
at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)Have you eliminated hardware or installed software issues by trying to run
this on a different pair of machines?
--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> I've been working with Microsoft support for over 3 weeks now on an
> intermittent General Network Error we're seeing in our production
> environment between our ASP.NET application and SQL Server 2000. They are
> continuing to work on the issue, but it seems as if our progress is
grinding
> to a halt. I asked this question on the newsgroups before going to MS but
> figured I'd give it another shot now that I have more information.
> The problem occurs intermittently (maybe 10 to 15 times per day). It
seems
> to be related to queries that return "large" amounts of data from SQL.
The
> problem started after we made an equipment change. We went from a single
> server hosting both our ASP.NET application and SQL Server 2000, to one
> server hosting IIS and another machine running SQL. An example of the
> exception thrown appears at the bottom of this post.
> MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS
machine,
> MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server. The
MS
> rep found nothing too out of the ordinary with our configuration, so he
> asked me to do a network capture on both machines while the error
occurred.
> I was able to get a good capture in a small window and sent it off to MS.
> The verdict is that IIS is basically halting the request. It is resetting
> the database connection partway through retrieving the results of the
stored
> proc. IIS attempts to close the connection for some reason, SQL ignores
and
> keeps pumping back data, then IIS raises a reset. MS confirmed that there
> is no packet loss. MS has not determined why this is happening and has
not
> advised me to capture any additional data.
> If someone has any ideas, I am willing to provide as much detail as
> possible. I wanted to keep this initial post as concise as possible.
> Thanks for any assistance you can provide,
> -joe
> EXCEPTION:
> System.Data.SqlClient.SqlException: General network error. Check your
> network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
> offset, Int32 len)
> at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
> Encoding encoding)
> at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md, Int32
> length)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
>|||Unforunately, we're a small company and don't have the "luxury" of
duplicating the environment. However, there is plenty of horsepower there
to meet our needs. The web server is a Dell PowerEdge 1750 and the database
server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage is
quite light.
I would love to be able to do what you say and I appreciate the value it
would bring to solving the problem, unfortunately, it's not realistic for us
at this time.
Thanks
-joe
"Kevin Spencer" <kevin@.takempis.com> wrote in message
news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> Have you eliminated hardware or installed software issues by trying to run
> this on a different pair of machines?
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
> "Joe Ross" <joeross252@.hotmail.com> wrote in message
> news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> > I've been working with Microsoft support for over 3 weeks now on an
> > intermittent General Network Error we're seeing in our production
> > environment between our ASP.NET application and SQL Server 2000. They
are
> > continuing to work on the issue, but it seems as if our progress is
> grinding
> > to a halt. I asked this question on the newsgroups before going to MS
but
> > figured I'd give it another shot now that I have more information.
> >
> > The problem occurs intermittently (maybe 10 to 15 times per day). It
> seems
> > to be related to queries that return "large" amounts of data from SQL.
> The
> > problem started after we made an equipment change. We went from a
single
> > server hosting both our ASP.NET application and SQL Server 2000, to one
> > server hosting IIS and another machine running SQL. An example of the
> > exception thrown appears at the bottom of this post.
> >
> > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS
> machine,
> > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server. The
> MS
> > rep found nothing too out of the ordinary with our configuration, so he
> > asked me to do a network capture on both machines while the error
> occurred.
> >
> > I was able to get a good capture in a small window and sent it off to
MS.
> > The verdict is that IIS is basically halting the request. It is
resetting
> > the database connection partway through retrieving the results of the
> stored
> > proc. IIS attempts to close the connection for some reason, SQL ignores
> and
> > keeps pumping back data, then IIS raises a reset. MS confirmed that
there
> > is no packet loss. MS has not determined why this is happening and has
> not
> > advised me to capture any additional data.
> >
> > If someone has any ideas, I am willing to provide as much detail as
> > possible. I wanted to keep this initial post as concise as possible.
> >
> > Thanks for any assistance you can provide,
> > -joe
> >
> > EXCEPTION:
> > System.Data.SqlClient.SqlException: General network error. Check your
> > network documentation.
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception,
> > TdsParserState state)
> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, TdsParserState state)
> > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
> > offset, Int32 len)
> > at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
> > Encoding encoding)
> > at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md,
Int32
> > length)
> > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
> > at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> >
> >
>|||If it does turn out to be a hardware or installed software issue, I believe
you will have spent more than the cost of 2 machines in salaries trying to
find it.
--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> Unforunately, we're a small company and don't have the "luxury" of
> duplicating the environment. However, there is plenty of horsepower there
> to meet our needs. The web server is a Dell PowerEdge 1750 and the
database
> server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage is
> quite light.
> I would love to be able to do what you say and I appreciate the value it
> would bring to solving the problem, unfortunately, it's not realistic for
us
> at this time.
> Thanks
> -joe
>
> "Kevin Spencer" <kevin@.takempis.com> wrote in message
> news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> > Have you eliminated hardware or installed software issues by trying to
run
> > this on a different pair of machines?
> >
> > --
> > HTH,
> > Kevin Spencer
> > .Net Developer
> > Microsoft MVP
> > Big things are made up
> > of lots of little things.
> >
> > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> > > I've been working with Microsoft support for over 3 weeks now on an
> > > intermittent General Network Error we're seeing in our production
> > > environment between our ASP.NET application and SQL Server 2000. They
> are
> > > continuing to work on the issue, but it seems as if our progress is
> > grinding
> > > to a halt. I asked this question on the newsgroups before going to MS
> but
> > > figured I'd give it another shot now that I have more information.
> > >
> > > The problem occurs intermittently (maybe 10 to 15 times per day). It
> > seems
> > > to be related to queries that return "large" amounts of data from SQL.
> > The
> > > problem started after we made an equipment change. We went from a
> single
> > > server hosting both our ASP.NET application and SQL Server 2000, to
one
> > > server hosting IIS and another machine running SQL. An example of the
> > > exception thrown appears at the bottom of this post.
> > >
> > > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS
> > machine,
> > > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server.
The
> > MS
> > > rep found nothing too out of the ordinary with our configuration, so
he
> > > asked me to do a network capture on both machines while the error
> > occurred.
> > >
> > > I was able to get a good capture in a small window and sent it off to
> MS.
> > > The verdict is that IIS is basically halting the request. It is
> resetting
> > > the database connection partway through retrieving the results of the
> > stored
> > > proc. IIS attempts to close the connection for some reason, SQL
ignores
> > and
> > > keeps pumping back data, then IIS raises a reset. MS confirmed that
> there
> > > is no packet loss. MS has not determined why this is happening and
has
> > not
> > > advised me to capture any additional data.
> > >
> > > If someone has any ideas, I am willing to provide as much detail as
> > > possible. I wanted to keep this initial post as concise as possible.
> > >
> > > Thanks for any assistance you can provide,
> > > -joe
> > >
> > > EXCEPTION:
> > > System.Data.SqlClient.SqlException: General network error. Check your
> > > network documentation.
> > > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> exception,
> > > TdsParserState state)
> > > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > exception, TdsParserState state)
> > > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> > > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > > at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
> > > offset, Int32 len)
> > > at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
> > > Encoding encoding)
> > > at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md,
> Int32
> > > length)
> > > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[]
columns,
> > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > > at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
> > > at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > > at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> > >
> > >
> >
> >
>|||I respectfully disagree. Thank you for your overly helpful advice.
-joe
"Kevin Spencer" <kevin@.takempis.com> wrote in message
news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> If it does turn out to be a hardware or installed software issue, I
believe
> you will have spent more than the cost of 2 machines in salaries trying to
> find it.
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
> "Joe Ross" <joeross252@.hotmail.com> wrote in message
> news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> > Unforunately, we're a small company and don't have the "luxury" of
> > duplicating the environment. However, there is plenty of horsepower
there
> > to meet our needs. The web server is a Dell PowerEdge 1750 and the
> database
> > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage is
> > quite light.
> >
> > I would love to be able to do what you say and I appreciate the value it
> > would bring to solving the problem, unfortunately, it's not realistic
for
> us
> > at this time.
> >
> > Thanks
> > -joe
> >
> >
> > "Kevin Spencer" <kevin@.takempis.com> wrote in message
> > news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> > > Have you eliminated hardware or installed software issues by trying to
> run
> > > this on a different pair of machines?
> > >
> > > --
> > > HTH,
> > > Kevin Spencer
> > > .Net Developer
> > > Microsoft MVP
> > > Big things are made up
> > > of lots of little things.
> > >
> > > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > > news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> > > > I've been working with Microsoft support for over 3 weeks now on an
> > > > intermittent General Network Error we're seeing in our production
> > > > environment between our ASP.NET application and SQL Server 2000.
They
> > are
> > > > continuing to work on the issue, but it seems as if our progress is
> > > grinding
> > > > to a halt. I asked this question on the newsgroups before going to
MS
> > but
> > > > figured I'd give it another shot now that I have more information.
> > > >
> > > > The problem occurs intermittently (maybe 10 to 15 times per day).
It
> > > seems
> > > > to be related to queries that return "large" amounts of data from
SQL.
> > > The
> > > > problem started after we made an equipment change. We went from a
> > single
> > > > server hosting both our ASP.NET application and SQL Server 2000, to
> one
> > > > server hosting IIS and another machine running SQL. An example of
the
> > > > exception thrown appears at the bottom of this post.
> > > >
> > > > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS
> > > machine,
> > > > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server.
> The
> > > MS
> > > > rep found nothing too out of the ordinary with our configuration, so
> he
> > > > asked me to do a network capture on both machines while the error
> > > occurred.
> > > >
> > > > I was able to get a good capture in a small window and sent it off
to
> > MS.
> > > > The verdict is that IIS is basically halting the request. It is
> > resetting
> > > > the database connection partway through retrieving the results of
the
> > > stored
> > > > proc. IIS attempts to close the connection for some reason, SQL
> ignores
> > > and
> > > > keeps pumping back data, then IIS raises a reset. MS confirmed that
> > there
> > > > is no packet loss. MS has not determined why this is happening and
> has
> > > not
> > > > advised me to capture any additional data.
> > > >
> > > > If someone has any ideas, I am willing to provide as much detail as
> > > > possible. I wanted to keep this initial post as concise as
possible.
> > > >
> > > > Thanks for any assistance you can provide,
> > > > -joe
> > > >
> > > > EXCEPTION:
> > > > System.Data.SqlClient.SqlException: General network error. Check
your
> > > > network documentation.
> > > > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> > exception,
> > > > TdsParserState state)
> > > > at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > exception, TdsParserState state)
> > > > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > > > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32
bytesExpected)
> > > > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > > > at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff,
Int32
> > > > offset, Int32 len)
> > > > at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
> > > > Encoding encoding)
> > > > at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md,
> > Int32
> > > > length)
> > > > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[]
> columns,
> > > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > > > at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
> > > > at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > > > at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> > > >
> > > >
> > >
> > >
> >
> >
>|||> I respectfully disagree. Thank you for your overly helpful advice.
You stated originally that you had already spent 3 weeks on this problem
without a resolution. I don't know what your salaries are like, but 3 weeks
is a lot of man-hours, and Microsoft support is expensive. Maybe you should
disagree later, when and if you get it fixed.
Thank you for your overly defensive reply.
--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:OaXit3T$DHA.320@.TK2MSFTNGP10.phx.gbl...
> I respectfully disagree. Thank you for your overly helpful advice.
> -joe
> "Kevin Spencer" <kevin@.takempis.com> wrote in message
> news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> > If it does turn out to be a hardware or installed software issue, I
> believe
> > you will have spent more than the cost of 2 machines in salaries trying
to
> > find it.
> >
> > --
> > HTH,
> > Kevin Spencer
> > .Net Developer
> > Microsoft MVP
> > Big things are made up
> > of lots of little things.
> >
> > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> > > Unforunately, we're a small company and don't have the "luxury" of
> > > duplicating the environment. However, there is plenty of horsepower
> there
> > > to meet our needs. The web server is a Dell PowerEdge 1750 and the
> > database
> > > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage
is
> > > quite light.
> > >
> > > I would love to be able to do what you say and I appreciate the value
it
> > > would bring to solving the problem, unfortunately, it's not realistic
> for
> > us
> > > at this time.
> > >
> > > Thanks
> > > -joe
> > >
> > >
> > > "Kevin Spencer" <kevin@.takempis.com> wrote in message
> > > news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> > > > Have you eliminated hardware or installed software issues by trying
to
> > run
> > > > this on a different pair of machines?
> > > >
> > > > --
> > > > HTH,
> > > > Kevin Spencer
> > > > .Net Developer
> > > > Microsoft MVP
> > > > Big things are made up
> > > > of lots of little things.
> > > >
> > > > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > > > news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> > > > > I've been working with Microsoft support for over 3 weeks now on
an
> > > > > intermittent General Network Error we're seeing in our production
> > > > > environment between our ASP.NET application and SQL Server 2000.
> They
> > > are
> > > > > continuing to work on the issue, but it seems as if our progress
is
> > > > grinding
> > > > > to a halt. I asked this question on the newsgroups before going
to
> MS
> > > but
> > > > > figured I'd give it another shot now that I have more information.
> > > > >
> > > > > The problem occurs intermittently (maybe 10 to 15 times per day).
> It
> > > > seems
> > > > > to be related to queries that return "large" amounts of data from
> SQL.
> > > > The
> > > > > problem started after we made an equipment change. We went from a
> > > single
> > > > > server hosting both our ASP.NET application and SQL Server 2000,
to
> > one
> > > > > server hosting IIS and another machine running SQL. An example of
> the
> > > > > exception thrown appears at the bottom of this post.
> > > > >
> > > > > MS had us perform 3 data captures initially: MPSRPT_MDAC on the
IIS
> > > > machine,
> > > > > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database
server.
> > The
> > > > MS
> > > > > rep found nothing too out of the ordinary with our configuration,
so
> > he
> > > > > asked me to do a network capture on both machines while the error
> > > > occurred.
> > > > >
> > > > > I was able to get a good capture in a small window and sent it off
> to
> > > MS.
> > > > > The verdict is that IIS is basically halting the request. It is
> > > resetting
> > > > > the database connection partway through retrieving the results of
> the
> > > > stored
> > > > > proc. IIS attempts to close the connection for some reason, SQL
> > ignores
> > > > and
> > > > > keeps pumping back data, then IIS raises a reset. MS confirmed
that
> > > there
> > > > > is no packet loss. MS has not determined why this is happening
and
> > has
> > > > not
> > > > > advised me to capture any additional data.
> > > > >
> > > > > If someone has any ideas, I am willing to provide as much detail
as
> > > > > possible. I wanted to keep this initial post as concise as
> possible.
> > > > >
> > > > > Thanks for any assistance you can provide,
> > > > > -joe
> > > > >
> > > > > EXCEPTION:
> > > > > System.Data.SqlClient.SqlException: General network error. Check
> your
> > > > > network documentation.
> > > > > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> > > exception,
> > > > > TdsParserState state)
> > > > > at
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > > exception, TdsParserState state)
> > > > > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > > > > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32
> bytesExpected)
> > > > > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > > > > at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff,
> Int32
> > > > > offset, Int32 len)
> > > > > at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32
length,
> > > > > Encoding encoding)
> > > > > at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData
md,
> > > Int32
> > > > > length)
> > > > > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[]
> > columns,
> > > > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > > > > at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32
i)
> > > > > at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > > > > at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Joe -
At the risk of being 'overly' helpful, I would suggest that you may be
making too many assumptions about the operational data, for example the MS
assertion that no packets are being lost. The monitoring tools are not
infallible and they may in fact be wrong ( it even happened to me once long
ago ;-).
It sounds like MS is looking primarily at configuration data and not
performance data. Interaction under load between IIS and .NET may be
creating contention for resources or devices. If the queries are returning
'large' amounts of data, then the workload is not light, it's heavy and
there may well be a performance bottleneck in the server or network. It
could even be caused by a bad driver for a network device. Find every error
log and run every monitor on the system. There may be a lower level problem
within the apparent problem.
I'd also look very closely at application level performance, particularly
the heavy hitters, to see if you can reduce sudden bursts of demand. If the
heavy hitters are not critical, slow them down and spread out the demand.
If your delivery date is in extreme unction, you may even need to redesign
the queries to work around it.
In any case, I think you may need to fully instrument your server, collect
all the configuration and operation data available and do a more complete
analysis of your system. I've run across problems with complex interactions
in the past and a strictly analytic approach was the only way out.
For what it's worth ...
- Bill Breitmayer
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:OaXit3T$DHA.320@.TK2MSFTNGP10.phx.gbl...
> I respectfully disagree. Thank you for your overly helpful advice.
> -joe
> "Kevin Spencer" <kevin@.takempis.com> wrote in message
> news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> > If it does turn out to be a hardware or installed software issue, I
> believe
> > you will have spent more than the cost of 2 machines in salaries trying
to
> > find it.
> >
> > --
> > HTH,
> > Kevin Spencer
> > .Net Developer
> > Microsoft MVP
> > Big things are made up
> > of lots of little things.
> >
> > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> > > Unforunately, we're a small company and don't have the "luxury" of
> > > duplicating the environment. However, there is plenty of horsepower
> there
> > > to meet our needs. The web server is a Dell PowerEdge 1750 and the
> > database
> > > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage
is
> > > quite light.
> > >
> > > I would love to be able to do what you say and I appreciate the value
it
> > > would bring to solving the problem, unfortunately, it's not realistic
> for
> > us
> > > at this time.
> > >
> > > Thanks
> > > -joe
> > >
> > >
> > > "Kevin Spencer" <kevin@.takempis.com> wrote in message
> > > news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> > > > Have you eliminated hardware or installed software issues by trying
to
> > run
> > > > this on a different pair of machines?
> > > >
> > > > --
> > > > HTH,
> > > > Kevin Spencer
> > > > .Net Developer
> > > > Microsoft MVP
> > > > Big things are made up
> > > > of lots of little things.
> > > >
> > > > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > > > news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> > > > > I've been working with Microsoft support for over 3 weeks now on
an
> > > > > intermittent General Network Error we're seeing in our production
> > > > > environment between our ASP.NET application and SQL Server 2000.
> They
> > > are
> > > > > continuing to work on the issue, but it seems as if our progress
is
> > > > grinding
> > > > > to a halt. I asked this question on the newsgroups before going
to
> MS
> > > but
> > > > > figured I'd give it another shot now that I have more information.
> > > > >
> > > > > The problem occurs intermittently (maybe 10 to 15 times per day).
> It
> > > > seems
> > > > > to be related to queries that return "large" amounts of data from
> SQL.
> > > > The
> > > > > problem started after we made an equipment change. We went from a
> > > single
> > > > > server hosting both our ASP.NET application and SQL Server 2000,
to
> > one
> > > > > server hosting IIS and another machine running SQL. An example of
> the
> > > > > exception thrown appears at the bottom of this post.
> > > > >
> > > > > MS had us perform 3 data captures initially: MPSRPT_MDAC on the
IIS
> > > > machine,
> > > > > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database
server.
> > The
> > > > MS
> > > > > rep found nothing too out of the ordinary with our configuration,
so
> > he
> > > > > asked me to do a network capture on both machines while the error
> > > > occurred.
> > > > >
> > > > > I was able to get a good capture in a small window and sent it off
> to
> > > MS.
> > > > > The verdict is that IIS is basically halting the request. It is
> > > resetting
> > > > > the database connection partway through retrieving the results of
> the
> > > > stored
> > > > > proc. IIS attempts to close the connection for some reason, SQL
> > ignores
> > > > and
> > > > > keeps pumping back data, then IIS raises a reset. MS confirmed
that
> > > there
> > > > > is no packet loss. MS has not determined why this is happening
and
> > has
> > > > not
> > > > > advised me to capture any additional data.
> > > > >
> > > > > If someone has any ideas, I am willing to provide as much detail
as
> > > > > possible. I wanted to keep this initial post as concise as
> possible.
> > > > >
> > > > > Thanks for any assistance you can provide,
> > > > > -joe
> > > > >
> > > > > EXCEPTION:
> > > > > System.Data.SqlClient.SqlException: General network error. Check
> your
> > > > > network documentation.
> > > > > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> > > exception,
> > > > > TdsParserState state)
> > > > > at
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > > exception, TdsParserState state)
> > > > > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > > > > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32
> bytesExpected)
> > > > > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > > > > at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff,
> Int32
> > > > > offset, Int32 len)
> > > > > at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32
length,
> > > > > Encoding encoding)
> > > > > at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData
md,
> > > Int32
> > > > > length)
> > > > > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[]
> > columns,
> > > > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > > > > at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32
i)
> > > > > at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > > > > at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Bill-
I appreciate you taking the time to make such a detailed response. We are
going to take your advice and look at better instrumenting our application
to collect more meaningful data. We've realized that although we'll keep
working with MS on the issue, the solution will probably come from within.
I'll respond back to these groups when we make progress.
Thanks
-joe
"Bill Breitmayer" <billbreitmayer@.worldnet.att.net> wrote in message
news:pM60c.113110$hR.2187923@.bgtnsc05-news.ops.worldnet.att.net...
> Joe -
> At the risk of being 'overly' helpful, I would suggest that you may be
> making too many assumptions about the operational data, for example the MS
> assertion that no packets are being lost. The monitoring tools are not
> infallible and they may in fact be wrong ( it even happened to me once
long
> ago ;-).
> It sounds like MS is looking primarily at configuration data and not
> performance data. Interaction under load between IIS and .NET may be
> creating contention for resources or devices. If the queries are
returning
> 'large' amounts of data, then the workload is not light, it's heavy and
> there may well be a performance bottleneck in the server or network. It
> could even be caused by a bad driver for a network device. Find every
error
> log and run every monitor on the system. There may be a lower level
problem
> within the apparent problem.
> I'd also look very closely at application level performance, particularly
> the heavy hitters, to see if you can reduce sudden bursts of demand. If
the
> heavy hitters are not critical, slow them down and spread out the demand.
> If your delivery date is in extreme unction, you may even need to redesign
> the queries to work around it.
> In any case, I think you may need to fully instrument your server, collect
> all the configuration and operation data available and do a more complete
> analysis of your system. I've run across problems with complex
interactions
> in the past and a strictly analytic approach was the only way out.
> For what it's worth ...
> - Bill Breitmayer
>
> "Joe Ross" <joeross252@.hotmail.com> wrote in message
> news:OaXit3T$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > I respectfully disagree. Thank you for your overly helpful advice.
> >
> > -joe
> >
> > "Kevin Spencer" <kevin@.takempis.com> wrote in message
> > news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> > > If it does turn out to be a hardware or installed software issue, I
> > believe
> > > you will have spent more than the cost of 2 machines in salaries
trying
> to
> > > find it.
> > >
> > > --
> > > HTH,
> > > Kevin Spencer
> > > .Net Developer
> > > Microsoft MVP
> > > Big things are made up
> > > of lots of little things.
> > >
> > > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > > news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> > > > Unforunately, we're a small company and don't have the "luxury" of
> > > > duplicating the environment. However, there is plenty of horsepower
> > there
> > > > to meet our needs. The web server is a Dell PowerEdge 1750 and the
> > > database
> > > > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage
> is
> > > > quite light.
> > > >
> > > > I would love to be able to do what you say and I appreciate the
value
> it
> > > > would bring to solving the problem, unfortunately, it's not
realistic
> > for
> > > us
> > > > at this time.
> > > >
> > > > Thanks
> > > > -joe
> > > >
> > > >
> > > > "Kevin Spencer" <kevin@.takempis.com> wrote in message
> > > > news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> > > > > Have you eliminated hardware or installed software issues by
trying
> to
> > > run
> > > > > this on a different pair of machines?
> > > > >
> > > > > --
> > > > > HTH,
> > > > > Kevin Spencer
> > > > > .Net Developer
> > > > > Microsoft MVP
> > > > > Big things are made up
> > > > > of lots of little things.
> > > > >
> > > > > "Joe Ross" <joeross252@.hotmail.com> wrote in message
> > > > > news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> > > > > > I've been working with Microsoft support for over 3 weeks now on
> an
> > > > > > intermittent General Network Error we're seeing in our
production
> > > > > > environment between our ASP.NET application and SQL Server 2000.
> > They
> > > > are
> > > > > > continuing to work on the issue, but it seems as if our progress
> is
> > > > > grinding
> > > > > > to a halt. I asked this question on the newsgroups before going
> to
> > MS
> > > > but
> > > > > > figured I'd give it another shot now that I have more
information.
> > > > > >
> > > > > > The problem occurs intermittently (maybe 10 to 15 times per
day).
> > It
> > > > > seems
> > > > > > to be related to queries that return "large" amounts of data
from
> > SQL.
> > > > > The
> > > > > > problem started after we made an equipment change. We went from
a
> > > > single
> > > > > > server hosting both our ASP.NET application and SQL Server 2000,
> to
> > > one
> > > > > > server hosting IIS and another machine running SQL. An example
of
> > the
> > > > > > exception thrown appears at the bottom of this post.
> > > > > >
> > > > > > MS had us perform 3 data captures initially: MPSRPT_MDAC on the
> IIS
> > > > > machine,
> > > > > > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database
> server.
> > > The
> > > > > MS
> > > > > > rep found nothing too out of the ordinary with our
configuration,
> so
> > > he
> > > > > > asked me to do a network capture on both machines while the
error
> > > > > occurred.
> > > > > >
> > > > > > I was able to get a good capture in a small window and sent it
off
> > to
> > > > MS.
> > > > > > The verdict is that IIS is basically halting the request. It is
> > > > resetting
> > > > > > the database connection partway through retrieving the results
of
> > the
> > > > > stored
> > > > > > proc. IIS attempts to close the connection for some reason, SQL
> > > ignores
> > > > > and
> > > > > > keeps pumping back data, then IIS raises a reset. MS confirmed
> that
> > > > there
> > > > > > is no packet loss. MS has not determined why this is happening
> and
> > > has
> > > > > not
> > > > > > advised me to capture any additional data.
> > > > > >
> > > > > > If someone has any ideas, I am willing to provide as much detail
> as
> > > > > > possible. I wanted to keep this initial post as concise as
> > possible.
> > > > > >
> > > > > > Thanks for any assistance you can provide,
> > > > > > -joe
> > > > > >
> > > > > > EXCEPTION:
> > > > > > System.Data.SqlClient.SqlException: General network error.
Check
> > your
> > > > > > network documentation.
> > > > > > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> > > > exception,
> > > > > > TdsParserState state)
> > > > > > at
> > System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > > > exception, TdsParserState state)
> > > > > > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > > > > > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32
> > bytesExpected)
> > > > > > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > > > > > at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff,
> > Int32
> > > > > > offset, Int32 len)
> > > > > > at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32
> length,
> > > > > > Encoding encoding)
> > > > > > at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData
> md,
> > > > Int32
> > > > > > length)
> > > > > > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[]
> > > columns,
> > > > > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > > > > > at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32
> i)
> > > > > > at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > > > > > at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

General Network Error - MS Stumped

I've been working with Microsoft support for over 3 weeks now on an
intermittent General Network Error we're seeing in our production
environment between our ASP.NET application and SQL Server 2000. They are
continuing to work on the issue, but it seems as if our progress is grinding
to a halt. I asked this question on the newsgroups before going to MS but
figured I'd give it another shot now that I have more information.
The problem occurs intermittently (maybe 10 to 15 times per day). It seems
to be related to queries that return "large" amounts of data from SQL. The
problem started after we made an equipment change. We went from a single
server hosting both our ASP.NET application and SQL Server 2000, to one
server hosting IIS and another machine running SQL. An example of the
exception thrown appears at the bottom of this post.
MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS machine,
MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server. The MS
rep found nothing too out of the ordinary with our configuration, so he
asked me to do a network capture on both machines while the error occurred.
I was able to get a good capture in a small window and sent it off to MS.
The verdict is that IIS is basically halting the request. It is resetting
the database connection partway through retrieving the results of the stored
proc. IIS attempts to close the connection for some reason, SQL ignores and
keeps pumping back data, then IIS raises a reset. MS confirmed that there
is no packet loss. MS has not determined why this is happening and has not
advised me to capture any additional data.
If someone has any ideas, I am willing to provide as much detail as
possible. I wanted to keep this initial post as concise as possible.
Thanks for any assistance you can provide,
-joe
EXCEPTION:
System.Data.SqlClient.SqlException: General network error. Check your
network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
offset, Int32 len)
at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
Encoding encoding)
at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md, Int32
length)
at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)Have you eliminated hardware or installed software issues by trying to run
this on a different pair of machines?
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
> I've been working with Microsoft support for over 3 weeks now on an
> intermittent General Network Error we're seeing in our production
> environment between our ASP.NET application and SQL Server 2000. They are
> continuing to work on the issue, but it seems as if our progress is
grinding
> to a halt. I asked this question on the newsgroups before going to MS but
> figured I'd give it another shot now that I have more information.
> The problem occurs intermittently (maybe 10 to 15 times per day). It
seems
> to be related to queries that return "large" amounts of data from SQL.
The
> problem started after we made an equipment change. We went from a single
> server hosting both our ASP.NET application and SQL Server 2000, to one
> server hosting IIS and another machine running SQL. An example of the
> exception thrown appears at the bottom of this post.
> MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS
machine,
> MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server. The
MS
> rep found nothing too out of the ordinary with our configuration, so he
> asked me to do a network capture on both machines while the error
occurred.
> I was able to get a good capture in a small window and sent it off to MS.
> The verdict is that IIS is basically halting the request. It is resetting
> the database connection partway through retrieving the results of the
stored
> proc. IIS attempts to close the connection for some reason, SQL ignores
and
> keeps pumping back data, then IIS raises a reset. MS confirmed that there
> is no packet loss. MS has not determined why this is happening and has
not
> advised me to capture any additional data.
> If someone has any ideas, I am willing to provide as much detail as
> possible. I wanted to keep this initial post as concise as possible.
> Thanks for any assistance you can provide,
> -joe
> EXCEPTION:
> System.Data.SqlClient.SqlException: General network error. Check your
> network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
> offset, Int32 len)
> at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
> Encoding encoding)
> at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md, Int32
> length)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] column
s,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
>|||Unforunately, we're a small company and don't have the "luxury" of
duplicating the environment. However, there is plenty of horsepower there
to meet our needs. The web server is a Dell PowerEdge 1750 and the database
server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage is
quite light.
I would love to be able to do what you say and I appreciate the value it
would bring to solving the problem, unfortunately, it's not realistic for us
at this time.
Thanks
-joe
"Kevin Spencer" <kevin@.takempis.com> wrote in message
news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
> Have you eliminated hardware or installed software issues by trying to run
> this on a different pair of machines?
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
> "Joe Ross" <joeross252@.hotmail.com> wrote in message
> news:u55gTVJ$DHA.1796@.TK2MSFTNGP12.phx.gbl...
are
> grinding
but
> seems
> The
single
> machine,
> MS
> occurred.
MS.
resetting
> stored
> and
there
> not
exception,
Int32
>|||If it does turn out to be a hardware or installed software issue, I believe
you will have spent more than the cost of 2 machines in salaries trying to
find it.
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
> Unforunately, we're a small company and don't have the "luxury" of
> duplicating the environment. However, there is plenty of horsepower there
> to meet our needs. The web server is a Dell PowerEdge 1750 and the
database
> server is a Dell PowerEdge 2650 hooked into a PowerVault 220. Usage is
> quite light.
> I would love to be able to do what you say and I appreciate the value it
> would bring to solving the problem, unfortunately, it's not realistic for
us
> at this time.
> Thanks
> -joe
>
> "Kevin Spencer" <kevin@.takempis.com> wrote in message
> news:OVDsMqJ$DHA.2524@.tk2msftngp13.phx.gbl...
run
> are
> but
> single
one
The
he
> MS.
> resetting
ignores
> there
has
> exception,
> Int32
columns,
>|||I respectfully disagree. Thank you for your overly helpful advice.
-joe
"Kevin Spencer" <kevin@.takempis.com> wrote in message
news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> If it does turn out to be a hardware or installed software issue, I
believe
> you will have spent more than the cost of 2 machines in salaries trying to
> find it.
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
> "Joe Ross" <joeross252@.hotmail.com> wrote in message
> news:O1JOAaL$DHA.1732@.TK2MSFTNGP12.phx.gbl...
there
> database
for
> us
> run
They
MS
It
SQL.
> one
the
> The
> he
to
the
> ignores
> has
possible.
your
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
bytesExpected)
Int32
> columns,
>|||> I respectfully disagree. Thank you for your overly helpful advice.
You stated originally that you had already spent 3 weeks on this problem
without a resolution. I don't know what your salaries are like, but 3 weeks
is a lot of man-hours, and Microsoft support is expensive. Maybe you should
disagree later, when and if you get it fixed.
Thank you for your overly defensive reply.
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:OaXit3T$DHA.320@.TK2MSFTNGP10.phx.gbl...
> I respectfully disagree. Thank you for your overly helpful advice.
> -joe
> "Kevin Spencer" <kevin@.takempis.com> wrote in message
> news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> believe
to
> there
is
it
> for
to
an
> They
is
to
> MS
> It
> SQL.
to
> the
IIS
server.
so
> to
> the
that
and
as
> possible.
> your
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> bytesExpected)
> Int32
length,
md,
i)
>|||Joe -
At the risk of being 'overly' helpful, I would suggest that you may be
making too many assumptions about the operational data, for example the MS
assertion that no packets are being lost. The monitoring tools are not
infallible and they may in fact be wrong ( it even happened to me once long
ago ;-).
It sounds like MS is looking primarily at configuration data and not
performance data. Interaction under load between IIS and .NET may be
creating contention for resources or devices. If the queries are returning
'large' amounts of data, then the workload is not light, it's heavy and
there may well be a performance bottleneck in the server or network. It
could even be caused by a bad driver for a network device. Find every error
log and run every monitor on the system. There may be a lower level problem
within the apparent problem.
I'd also look very closely at application level performance, particularly
the heavy hitters, to see if you can reduce sudden bursts of demand. If the
heavy hitters are not critical, slow them down and spread out the demand.
If your delivery date is in extreme unction, you may even need to redesign
the queries to work around it.
In any case, I think you may need to fully instrument your server, collect
all the configuration and operation data available and do a more complete
analysis of your system. I've run across problems with complex interactions
in the past and a strictly analytic approach was the only way out.
For what it's worth ...
- Bill Breitmayer
"Joe Ross" <joeross252@.hotmail.com> wrote in message
news:OaXit3T$DHA.320@.TK2MSFTNGP10.phx.gbl...
> I respectfully disagree. Thank you for your overly helpful advice.
> -joe
> "Kevin Spencer" <kevin@.takempis.com> wrote in message
> news:uW6oBBT$DHA.2476@.TK2MSFTNGP12.phx.gbl...
> believe
to
> there
is
it
> for
to
an
> They
is
to
> MS
> It
> SQL.
to
> the
IIS
server.
so
> to
> the
that
and
as
> possible.
> your
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> bytesExpected)
> Int32
length,
md,
i)
>|||Bill-
I appreciate you taking the time to make such a detailed response. We are
going to take your advice and look at better instrumenting our application
to collect more meaningful data. We've realized that although we'll keep
working with MS on the issue, the solution will probably come from within.
I'll respond back to these groups when we make progress.
Thanks
-joe
"Bill Breitmayer" <billbreitmayer@.worldnet.att.net> wrote in message
news:pM60c.113110$hR.2187923@.bgtnsc05-news.ops.worldnet.att.net...
> Joe -
> At the risk of being 'overly' helpful, I would suggest that you may be
> making too many assumptions about the operational data, for example the MS
> assertion that no packets are being lost. The monitoring tools are not
> infallible and they may in fact be wrong ( it even happened to me once
long
> ago ;-).
> It sounds like MS is looking primarily at configuration data and not
> performance data. Interaction under load between IIS and .NET may be
> creating contention for resources or devices. If the queries are
returning
> 'large' amounts of data, then the workload is not light, it's heavy and
> there may well be a performance bottleneck in the server or network. It
> could even be caused by a bad driver for a network device. Find every
error
> log and run every monitor on the system. There may be a lower level
problem
> within the apparent problem.
> I'd also look very closely at application level performance, particularly
> the heavy hitters, to see if you can reduce sudden bursts of demand. If
the
> heavy hitters are not critical, slow them down and spread out the demand.
> If your delivery date is in extreme unction, you may even need to redesign
> the queries to work around it.
> In any case, I think you may need to fully instrument your server, collect
> all the configuration and operation data available and do a more complete
> analysis of your system. I've run across problems with complex
interactions
> in the past and a strictly analytic approach was the only way out.
> For what it's worth ...
> - Bill Breitmayer
>
> "Joe Ross" <joeross252@.hotmail.com> wrote in message
> news:OaXit3T$DHA.320@.TK2MSFTNGP10.phx.gbl...
trying
> to
> is
value
> it
realistic
trying
> to
> an
production
> is
> to
information.
day).
from
a
> to
of
> IIS
> server.
configuration,
> so
error
off
of
> that
> and
> as
Check
> length,
> md,
> i)
>

General network error

Hi,
I'am working with a merge Replication and a pull Subscription on demand from
the client
I'am getting this message error from a vb.net Windows Application
DATE=2006-03-15 15:18:34
ERROR=SyncJMI.CDatabaseUtils.LoadDataTable failed.
System.Data.SqlClient.SqlException: General network error. Check your
network documentation.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior)
at
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at SyncJMI.CDatabaseUtils.LoadDataTable(SqlCommand cmd, DataTable& dt,
Boolean verifyDb)
This is the first time a get this error
After doing some research on the Web, Ifind that if i put Polling=False in
my connection string this error dont appear anymore.
I'am not very confortable to deactivate the pooling for performance reason
Is this solution the real solution ?
Also by deactivating the pooling, does this deactivationis done on the
client side or server side?
It is a better idea to maximise the size of the pool instead of turn it off?
Thanks in advance!
I'm interested in any articles you can provide which show the connection
between General network error and connection pooling - haven't heard of this
as a solution myself before. Usually these issues concern breaks in
connectivity. If persistant then the network needs to be investigated. If
not, then simply restarting the merge agent suffices.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||My understanding is that connection pooling has advantages for other
connections using the same connection string properties, ie uid, pwd, or
trusted authentication. So the first connection in will spin up the min pool
size connections (default 1) and after it has complete its work subsequenct
connections with the same connection string can use that open connection.
What puzzles me is why are you using ado.net as opposed to the activex merge
replication objects? Its not clear to me that this is replication related or
ADO related. It seems to be barfing on LoadDataTable which doesn't sound
replication related.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"GC" <GC@.discussions.microsoft.com> wrote in message
news:93AF91D3-59F6-4F1A-8DB3-A91C38DEDD57@.microsoft.com...
> Hi,
> I'am working with a merge Replication and a pull Subscription on demand
> from
> the client
> I'am getting this message error from a vb.net Windows Application
> DATE=2006-03-15 15:18:34
> ERROR=SyncJMI.CDatabaseUtils.LoadDataTable failed.
> System.Data.SqlClient.SqlException: General network error. Check your
> network documentation.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
> behavior)
> at
> System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior
> behavior)
> at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand
> command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
> at SyncJMI.CDatabaseUtils.LoadDataTable(SqlCommand cmd, DataTable& dt,
> Boolean verifyDb)
>
> This is the first time a get this error
> After doing some research on the Web, Ifind that if i put Polling=False
> in
> my connection string this error dont appear anymore.
> I'am not very confortable to deactivate the pooling for performance reason
> Is this solution the real solution ?
> Also by deactivating the pooling, does this deactivationis done on the
> client side or server side?
> It is a better idea to maximise the size of the pool instead of turn it
> off?
> Thanks in advance!
>
>
>
>
>
|||Let me explain,
We use a vb.Net application that execute some script,copy files,update
version of my vb.net application and so on.
After all update are up to date I call the pull subscription that update all
the records in the database
My application is there for maintenance purpose and for synchronisation of
the database
So the General Network error could arrive during an the execution of a
script like a store procedure etc... that have nothing to do with the
replication.
Still have the problem with the pooling
We have develop many application for customer and it is the first time i got
this error.
Hope this help you
"Hilary Cotter" wrote:

> My understanding is that connection pooling has advantages for other
> connections using the same connection string properties, ie uid, pwd, or
> trusted authentication. So the first connection in will spin up the min pool
> size connections (default 1) and after it has complete its work subsequenct
> connections with the same connection string can use that open connection.
> What puzzles me is why are you using ado.net as opposed to the activex merge
> replication objects? Its not clear to me that this is replication related or
> ADO related. It seems to be barfing on LoadDataTable which doesn't sound
> replication related.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "GC" <GC@.discussions.microsoft.com> wrote in message
> news:93AF91D3-59F6-4F1A-8DB3-A91C38DEDD57@.microsoft.com...
>
>
|||did you monitor your connection pooling objects? This will reveal what if
your pool is exhausted.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"GC" <GC@.discussions.microsoft.com> wrote in message
news:AE292989-2D5B-4A66-B8CF-EFD222B48808@.microsoft.com...[vbcol=seagreen]
> Let me explain,
> We use a vb.Net application that execute some script,copy files,update
> version of my vb.net application and so on.
> After all update are up to date I call the pull subscription that update
> all
> the records in the database
> My application is there for maintenance purpose and for synchronisation of
> the database
> So the General Network error could arrive during an the execution of a
> script like a store procedure etc... that have nothing to do with the
> replication.
> Still have the problem with the pooling
> We have develop many application for customer and it is the first time i
> got
> this error.
> Hope this help you
>
>
>
>
> "Hilary Cotter" wrote:

General network error

Hi,
I am working on sql server 2000.
We have a job that runs every 30 mins every day. It has
been behaving very well. The only time it failed was
yesterday at 10:00am. When I viewed the job history, it
showed the following message:
Executed as user: blahblah\sql_admin. ConnectionRead (recv
()). [SQLSTATE 01000] (Message 10054) General network
error. Check your network documentation. [SQLSTATE 08S01]
(Error 11). The step failed.
General network error usually indicate that there is a
network connection failure. But this specific job/stored
procedure is not pulling data from any other server but
from local table. (Message 10054) indicating BCP overflow
certain column definition, but we are not doing BCP
either.
Could this message mean that there are too many disk I/O
going on at that time, and this job was waiting too long
in idle and failed?
Or could that be a logon info issue?
Any suggestion will be greatly appreciated.
JJHi JJ,
You might want to check SQL errorrlog and make sure that there is no error
occurred during that time.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

General Database/Query and Form Design question

Currently working on an existing system written using an Access 2002 project
(.adp) and SQL Server 2000 and need to add some ehancements.
The system is a leasing system where a customer leases one or more assets
for a defined term (eg. 24, 36, 48 months...). Each lease may also be
associated with a fixed, or variable monthly repayment regime.
For example a customer wants to lease a Boat for 24 months for the first 12
months (period 1 - 12) they pay $50 per month, for period 13 - 18 they pay
$35 per month, and for the last 6 months (period 19 - 24) they pay $25 per
month.
The proposed table design is as follows:
tblLease
LeaseId int (identity) PK
CustomerId FK
TermId FK
...
tblLeaseAsset (1:M relationship to tblLease)
AssetId int PK
LeaseId int PK/FK to tblLease
AssetDescription
...
tblLeaseAssetRate (Intersection table - 1:M relationship to tblLeaseAsset,
1:M relationship to tblLeaseTerm)
AssetId int PK/FK
TermPeriodId int PK/FK
Payment decimal (19,4)
...
tblLeasePeriodTerm (1:M relationship to tblLease)
TermPeriodId int (identity) PK
LeaseId int FK to tblLease
FromTermPeriod small int
ToTermPeriod small int
...
Whilst the users are happy to enter the initial lease and period/term
information as a Parent/Main form and Child/Subform combination. They would
like to be able to enter the Asset and payment information together as a
single Child/Subform:
Period Period Period
Asset Description 1 - 12 13 - 18 19 - ...
A Boat $50 $35 $25
The problem is that this requires a pivot table/cross tabulation type view
of the data and these types of queries are not generally updatable.
Does anyone have any ideas how I might achieve the objective either in terms
of database, query or form design so that users can insert, update, delete
and view records?
Your assistance apreciated
Guy HortonWell, for each "asset", you got
AssetName AssetCost WherePurchased
Boat $15,000 WalMart
Car $5,000 MacDonalds
etc.
Now, just put another sub-form to the "right" of a above where you can enter
"many" values for each of the above.
If your cursor is in Boat, then you can enter:
Period Amount
1 - 12 $50
13 - 18 $35
etc.
I can think of "many" cases where you got a detail line, and need "many" for
that details. consider the QuickBooks when you write a single check, and a
split amount, you need to "split" out the funds to "many" values. So, the
solution is to make two side by side sub-forms.
Take a look at the following screen shots, and especially the last one where
I have a "classic" cheque "distribution" screen (for each check/person on
the left, I can enter "many" split values for that particlar amount
(donation in this example) on the right side...
http://www.members.shaw.ca/AlbertKa...ticles/Grid.htm
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@.msn.com
http://www.members.shaw.ca/AlbertKallal|||I'd strongly recommend Albert's way, but if you're absolutely forced to
doing it on the same line, you can try a few different things that I can
think of:
1. Play with Access' PivotTable features. I've never found them all that
useful, and very klunky to use, but it may get you where you're trying to
go. Don't ask me for more detailed info on how to do that, though, I
generally avoid PivotTables like the plague.
2. Implement a temporary table that goes across as you'd like it to, then
as each record is read/updated, transfer the values to/from the "real" table
in the OnCurrent and Before/AfterUpdate events.
3. Use an embedded control of some kind (Hierarchical FlexGrid?) to display
the data instead.
Good luck,
Rob
"Guy Horton" <guy.horton@.nospam.bigpond.com> wrote in message
news:%23RueVVwwFHA.2064@.TK2MSFTNGP09.phx.gbl...
> Currently working on an existing system written using an Access 2002
> project (.adp) and SQL Server 2000 and need to add some ehancements.
> The system is a leasing system where a customer leases one or more assets
> for a defined term (eg. 24, 36, 48 months...). Each lease may also be
> associated with a fixed, or variable monthly repayment regime.
> For example a customer wants to lease a Boat for 24 months for the first
> 12 months (period 1 - 12) they pay $50 per month, for period 13 - 18 they
> pay $35 per month, and for the last 6 months (period 19 - 24) they pay $25
> per month.
> The proposed table design is as follows:
> tblLease
> LeaseId int (identity) PK
> CustomerId FK
> TermId FK
> ...
> tblLeaseAsset (1:M relationship to tblLease)
> AssetId int PK
> LeaseId int PK/FK to tblLease
> AssetDescription
> ...
> tblLeaseAssetRate (Intersection table - 1:M relationship to tblLeaseAsset,
> 1:M relationship to tblLeaseTerm)
> AssetId int PK/FK
> TermPeriodId int PK/FK
> Payment decimal (19,4)
> ...
> tblLeasePeriodTerm (1:M relationship to tblLease)
> TermPeriodId int (identity) PK
> LeaseId int FK to tblLease
> FromTermPeriod small int
> ToTermPeriod small int
> ...
> Whilst the users are happy to enter the initial lease and period/term
> information as a Parent/Main form and Child/Subform combination. They
> would like to be able to enter the Asset and payment information together
> as a single Child/Subform:
> Period Period Period
> Asset Description 1 - 12 13 - 18 19 - ...
> A Boat $50 $35 $25
> The problem is that this requires a pivot table/cross tabulation type view
> of the data and these types of queries are not generally updatable.
> Does anyone have any ideas how I might achieve the objective either in
> terms of database, query or form design so that users can insert, update,
> delete and view records?
> Your assistance apreciated
> Guy Horton
>|||Albert,
Thank you for your excellent response. I reviewed your article and screen
shots and have to say they look very professional.
I briefly considered side by side subforms and agree with you that this is a
very workable option, and probably the option I will go with. Although, it
doesn't allow the users to view all lease rates for all the currently
visible leased assets, and they think of periods as running across as
opposed to down the form.
Your thoughts appreciated.
Best Regards,
Guy
"Albert D.Kallal" <PleaseNOOOsPAMmkallal@.msn.com> wrote in message
news:ukKGPmwwFHA.460@.TK2MSFTNGP15.phx.gbl...
> Well, for each "asset", you got
>
> AssetName AssetCost WherePurchased
> Boat $15,000 WalMart
> Car $5,000 MacDonalds
> etc.
> Now, just put another sub-form to the "right" of a above where you can
> enter "many" values for each of the above.
> If your cursor is in Boat, then you can enter:
> Period Amount
> 1 - 12 $50
> 13 - 18 $35
> etc.
> I can think of "many" cases where you got a detail line, and need "many"
> for that details. consider the QuickBooks when you write a single check,
> and a split amount, you need to "split" out the funds to "many" values.
> So, the solution is to make two side by side sub-forms.
> Take a look at the following screen shots, and especially the last one
> where I have a "classic" cheque "distribution" screen (for each
> check/person on the left, I can enter "many" split values for that
> particlar amount (donation in this example) on the right side...
> http://www.members.shaw.ca/AlbertKa...ticles/Grid.htm
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@.msn.com
> http://www.members.shaw.ca/AlbertKallal
>|||Robert,
Thank you for your response. I agree that Albert's solution is the probably
the most sensible way to go, and that PivotTable features are klunky to use.
Your thoughts appreciated
Guy
"Robert Morley" <rmorley@.magma.ca.no.freakin.spam> wrote in message
news:eYrGDpxwFHA.3756@.tk2msftngp13.phx.gbl...
> I'd strongly recommend Albert's way, but if you're absolutely forced to
> doing it on the same line, you can try a few different things that I can
> think of:
> 1. Play with Access' PivotTable features. I've never found them all that
> useful, and very klunky to use, but it may get you where you're trying to
> go. Don't ask me for more detailed info on how to do that, though, I
> generally avoid PivotTables like the plague.
> 2. Implement a temporary table that goes across as you'd like it to, then
> as each record is read/updated, transfer the values to/from the "real"
> table in the OnCurrent and Before/AfterUpdate events.
> 3. Use an embedded control of some kind (Hierarchical FlexGrid?) to
> display the data instead.
>
> Good luck,
> Rob
> "Guy Horton" <guy.horton@.nospam.bigpond.com> wrote in message
> news:%23RueVVwwFHA.2064@.TK2MSFTNGP09.phx.gbl...
>

General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL

I am working on two versions of an application, one of which will be a
windows forms application (which will need to be redistributable) and
the other will be a web application.

I have MS Visual Studio 2005 (along with the developer's edition of MS
SQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun's
application server, Tomcat and Apache web server. I am working on
Windows XP Pro, and have installed the .NET 3 SDK and all relevant
related products I could find (e.g. 2 extensions packages for Visual
Studio).

I have one MS Access database, to which my users should have read only
access. I have, and have used, a tool for importing MS Access
databases into MySQL. I expect that SQL Server has a similar utility
hidden somewhere (where I haven't yet looked, though I HAVE been
looking - obviously in the wrong places). I have located a similar
utility for importing MS Access databases into PostgreSQL. I have not
yet decided which servers to use for the web version, but that is
another story, for which I may raise another thread in due course (but
I welcome suggestions which may reduce the effort required given
required effort for the windows forms app).

My problem is for the windows form aplication (intended for use by a
single family). I expect to use ADO.NET. The question is, should I
import the Access database into MS SQL, and redistribute it, along with
MS SQL Server Express (or is that necessary), or distribute it just as
an Access database and use the jet engine to access it. A related
question is, "Does ADO.NET support creating new databases for a given
engine?" Imagine a recipe database. It is easy enough to create a SQL
script that creates all the required tables, indices, foreign keys,
&c., but can I submit that SQL script to an ADO.NET object, along with
a file name, and have it create, e.g., an Access database with the
supplied name. Or do I have to create a database file with nothing in
it other than the schema?

I have more questions, but they'll have to wait.

Thanks

Ted
On 13 Nov, 20:40, "Ted" <r.ted.by...@.rogers.comwrote:

Quote:

Originally Posted by

I am working on two versions of an application, one of which will be a
windows forms application (which will need to be redistributable) and
the other will be a web application.

Hi there

I've come across something similar before in the days of VB6 but not
sure how well ADO.NET can deal with it, might require alot of coding.

My recommendation would be to have a common business layer which is
shared by the winforms and web applications. You can slap the two
different UIs on top which should be fairly simple. On the data side,
you can create some interfaces which will allow you to communicate with
your data using the same methods and create data access code for Access
and your other choice of server

Shout if you have any questions

Sam|||Hi Sam,

My first question is this: "If you were in my place, and wanted to
simplify deployment, would you use some of the ADO.NET classes to copy
the MS Access database to SQL Server, and then deploy SQL Server 2005
Express with your application, or use the Jet engine for both the
existing Access database and the new recipe database, or leave the
Access database as it is and create a SQL Server Express database for
the new database?"

I ask this first because a) I don't have Access so working with an
Access database is a PITA except within my Visual Studio 2005
application projects, b) IIRC the Jet engine is included with all
recent versions of Windows (at least the ones I'll support), and c)
based on my reading, I can deploy the SQL Server 2005 Express with my
application (or is this necessary - am I mistaken in assuming the SQL
Server 2005 Express is not included in the latest versions of Windows)

A second question is this: "Is the dialect of SQL used by Access the
same as that used by SQL Server 2005?" In other words, can I create a
DDL SQL script in SQL Server 2005's Management Studio that will create
my recipe database and then use ADO.NET 2 or ADO.NET 3 to submit it to
the Jet engine, along with a file name ending in mdb and have the
application properly create a NEW Access database? I ask because, with
my current suite of tools, it is trivially easy to create my new
database in SQL Server (and in a form entirely supported by the
capabilities of SQL Server Express - this db doesn't need the
capabilities in the other editions of SQL Server), but I am concerned
about how to deploy it or to make a distribution that will install
everything my application requires on a new machine (or a client's
machine). When I bought Visual Studio v6 oh so many eons ago, it came
with a utility for building distribution images that could be placed on
floppies of CDs, but I can't find the counterpart for Visual Studio
2005.

Thanks

Ted.|||Hi Ted

I dont know enough about your situation to make a suggestion yet. A
couple of questions from me:
Why do you need to use Access if you're going to install SQL Server
Express?
Is this a client requirement?
Is there alot of information? Could you use XML?

Not sure Jet is actually included with XP, think you have to install
it.

With regards to your second question, I'm afraid I dont know. I do
remember Access having a subset of commands, not sure about the latest
versions

Sam

Ted wrote:

Quote:

Originally Posted by

Hi Sam,
>
My first question is this: "If you were in my place, and wanted to
simplify deployment, would you use some of the ADO.NET classes to copy
the MS Access database to SQL Server, and then deploy SQL Server 2005
Express with your application, or use the Jet engine for both the
existing Access database and the new recipe database, or leave the
Access database as it is and create a SQL Server Express database for
the new database?"
>
I ask this first because a) I don't have Access so working with an
Access database is a PITA except within my Visual Studio 2005
application projects, b) IIRC the Jet engine is included with all
recent versions of Windows (at least the ones I'll support), and c)
based on my reading, I can deploy the SQL Server 2005 Express with my
application (or is this necessary - am I mistaken in assuming the SQL
Server 2005 Express is not included in the latest versions of Windows)
>
A second question is this: "Is the dialect of SQL used by Access the
same as that used by SQL Server 2005?" In other words, can I create a
DDL SQL script in SQL Server 2005's Management Studio that will create
my recipe database and then use ADO.NET 2 or ADO.NET 3 to submit it to
the Jet engine, along with a file name ending in mdb and have the
application properly create a NEW Access database? I ask because, with
my current suite of tools, it is trivially easy to create my new
database in SQL Server (and in a form entirely supported by the
capabilities of SQL Server Express - this db doesn't need the
capabilities in the other editions of SQL Server), but I am concerned
about how to deploy it or to make a distribution that will install
everything my application requires on a new machine (or a client's
machine). When I bought Visual Studio v6 oh so many eons ago, it came
with a utility for building distribution images that could be placed on
floppies of CDs, but I can't find the counterpart for Visual Studio
2005.
>
Thanks
>
Ted.

|||samuelhon wrote:

Quote:

Originally Posted by

Hi Ted
>

Hi Sam,

Quote:

Originally Posted by

I dont know enough about your situation to make a suggestion yet. A
couple of questions from me:
Why do you need to use Access if you're going to install SQL Server
Express?
Is this a client requirement?
Is there alot of information? Could you use XML?
>

The one database I am using is an MS Access database that has been
placed in the public domain by the USDA. It has about 80 MB of
nutrition data. I use it to allow a user to enter a recipe and obtain
an analysis of the nutrition in the prodct of the recipe, either per
serving or per 100 grams, and I support storing the recipes entered by
the user. The schema for both the USDA's nutrition database and my
recipe database is very simple. I suppose I could use XML, but I am
not sure what that buys me. The recipe database will initially be
small (actually it will be empty unless I create a few recipes and
store them as samples of what can be done). The remainder of the
application is smple. It supports creating a weeklong meal plan,
assessing the meal plans entered for how well it meets the nutritional
requirements for each member of the family (there is a window that
allows the user to enter these requirements for each member of the
family), and maintain a health diary, including what has actually been
eaten, any of the user's family's ailments and medications/remedies
used to deal with them. So, if Dad has a heart condition, Mom has
diabetes, and junior has colitis, each of their special nutritional
needs can be satisfied without Dad ;-) having to prepare three
different meals. Additionally, they can assess how well their diet and
medications or remedies serve their respective needs.

The idea of the web application is to extend this to create a global
recipe database, and opportunities for anyone who knows how to cook
earn a little money by contributing their favourite recipes to the
database and supporting people paying a pittance each time they wish to
use someone else's recipe. Of course, the option will be available for
a recipe's author to place his recipes in the public domain. This
would empower all users to try foods they may never have seen before.
I could, for example, try a desert made from lychees and longans (I'm
not sure I have the right spelling for these asian fruits) and 1) know
how to prepare it and 2) know what impact it will have on the
nutritional aspects of that week's meal plan. I don't know about you,
but I see a lot of fresh produce in the supermarkets these days that I
don't know anything about, so I don't buy them. If I had a resource of
the sort I'm trying to create, I could try them in safety.

Here you have the rationale for two versions, one accessable on the web
and the other distributable on CD and usable without access to the web.

As I see it, I either use Access databases for both the USDA data and
mine, or I use Jet to use the USDA data and SQL Server Express for my
recipe database, or I find a way to import the USDA data into SQL
Server Express and use SQL Server Express to access both the USDA data
and mine. Dealing with the web application is fairly straight forward
since I'd be running any server I'd need. But I want to make creation
of the distribution on CDs, or an image that can be downloaded from a
website, as simple as possible.

Quote:

Originally Posted by

Not sure Jet is actually included with XP, think you have to install
it.
>

I am running the 64 bit version of Windows XP Pro, and it has Jet;
either that or the professional edition of MS Visual Studio installed
it. This I know because I have already used it within a test program
that looks at the USDA data. While my application uses this to analyse
foods and recipes, my end user will never need to look at the raw
nutritional data.

Quote:

Originally Posted by

With regards to your second question, I'm afraid I dont know. I do
remember Access having a subset of commands, not sure about the latest
versions
>

Thanks

Ted|||Ted wrote:

Quote:

Originally Posted by

Hi Sam,
>
My first question is this: "If you were in my place, and wanted to
simplify deployment, would you use some of the ADO.NET classes to copy
the MS Access database to SQL Server, and then deploy SQL Server 2005
Express with your application, or use the Jet engine for both the
existing Access database and the new recipe database, or leave the
Access database as it is and create a SQL Server Express database for
the new database?"

Yes, I would have utilities or procedures that could read data in
various formats, but would store and deploy all my data in one standard
database format(such as SQL Server 2005 Express), if possible, to
simplify application development and maintenance.

Quote:

Originally Posted by

A second question is this: "Is the dialect of SQL used by Access the
same as that used by SQL Server 2005?"

No, not by a long shot. Different built-in functions (such as IIF() and
CStr() in Access vs CASE statement and CAST() in SQL Server), different
wild cards (* in Access vs % in SQL Server - and completely different
regular expressions for the LIKE statement), different data types, etc.

Some overviews of the differences:
http://sqlserver2000.databases.aspf...sql-server.html
http://www.mssqlcity.com/Articles/C...r_vs_access.htmsql