What are the challenges you face when working across database platforms? Take the survey
Options

General Network Error

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited April 6, 2004 12:58PM in SQL Compare Previous Versions
Hi Aaron,

Does this happen when trying to connect initially to a SQL server? If
so, it might just be an average every-day timeout causing the problem.

Yours,

Brian Donahue
Red Gate Technical Support

"Aaron A. Anderson" <aaron@skypoint.com> wrote in message
news:rScw$2P4DHA.1248@server53...
> I got SQL compare to work a total of one time. I currently keep getting
> this error and can't seem to get past it.
>
> General network error. Check your network documentation.
> Server stack trace:
> 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.ReadString(Int32 length)
> at System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32
length)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
> connectionProperties, Options options)
> at ?.?()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met
> hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMess
> age msg, IMessageSink replySink)
> Exception rethrown at [0]:
> at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message
reqMsg,
> Boolean bProxyCase)
> at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed,
> MessageData& msgData)
> at System.Windows.Forms.MethodInvoker.EndInvoke(IAsyncResult result)
> at RedGate.SQL.Controls.ProgressDialog.?(IAsyncResult )
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
>

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Aaron,

    Can you see if it helps to go into your Client Network Utility and
    create an alias to the remote server using only TCP/IP and connecting with
    SQL Compare using the alias?

    The SQL Connection settings that SQL Compare uses do not specify a
    network library, but SQL Compare seems to work a whole lot better over
    TCP/IP, so maybe it would help to force the connection to use TCP/IP.

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Aaron A. Anderson" <aaron@skypoint.com> wrote in message
    news:VQmuiqT$DHA.700@server53...
    > No, it occurs after the compare button is hit...specifically right after
    the
    > "Reading permissions" message on the compare.
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:Aip4HCc4DHA.1600@server53...
    > > Hi Aaron,
    > >
    > > Does this happen when trying to connect initially to a SQL server?
    If
    > > so, it might just be an average every-day timeout causing the problem.
    > >
    > > Yours,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Aaron A. Anderson" <aaron@skypoint.com> wrote in message
    > > news:rScw$2P4DHA.1248@server53...
    > > > I got SQL compare to work a total of one time. I currently keep
    getting
    > > > this error and can't seem to get past it.
    > > >
    > > > General network error. Check your network documentation.
    > > > Server stack trace:
    > > > 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.ReadString(Int32 length)
    > > > at System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32
    > > length)
    > > > at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
    > > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
    > > > at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
    > > > at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
    > > > at System.Data.SqlClient.SqlDataReader.get_Item(String name)
    > > > at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > connectionProperties, Options options)
    > > > at ?.?()
    > > > at
    > > >
    > >
    >
    System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met
    > > > hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean
    > > > fExecuteInContext, Object[]& outArgs)
    > > > at
    > > >
    > >
    >
    System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMess
    > > > age msg, IMessageSink replySink)
    > > > Exception rethrown at [0]:
    > > > at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message
    > > reqMsg,
    > > > Boolean bProxyCase)
    > > > at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object
    NotUsed,
    > > > MessageData& msgData)
    > > > at System.Windows.Forms.MethodInvoker.EndInvoke(IAsyncResult result)
    > > > at RedGate.SQL.Controls.ProgressDialog.?(IAsyncResult )
    > > > For more information, see Help and Support Center at
    > > > http://go.microsoft.com/fwlink/events.asp.
    > > >
    > > >
    > >
    > >
    >
    >
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Mike,

    The window title of the registration window is called 'registering
    dbname', not 'registering <the name of your database>'? That might be a
    clue.
    What is the name of the database you're trying to register?

    Regards,

    Brian Donahue
    Red Gate Technical Support


    "MikeD" <none> wrote in message news:vA6kY3VEEHA.1204@server53...
    > I get this error message too
    >
    > The software hangs after logging in and selecting a local db and then
    > selecting the remote db. it does retrieve the list of db's at both
    > locations correctly. both locations are setup in sql 2k client network
    util
    > and have been tested in isqlw. both local and remote servers are sql 2k
    > instances. new d/l install of .net framework 1.1 directly from ms.com,
    sql
    > compare 3.1.0.151.
    > local system in win2k sp4
    >
    > click the compare button, and it checks the columns etc (pretty quick) and
    > then in the dialog that is titled "Registering dbname" it just sits at the
    > "Connecting to server" prompt, the progress bar never shows any progress
    >
    > clicking cancel changes the title of the window to "Cancelling
    registration"
    > but nothing happens until it times out with a network error.
    >
    > I get an alert dialog with red X and "General network error. Check your
    > network documentation" a minute or 2 after hitting cancel
    >
    > Application log shows:
    >
    > General network error. Check your network documentation.
    >
    > Server stack trace:
    >
    > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
    > cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
    >
    > at System.Data.SqlClient.SqlCommand.ExecuteReader()
    >
    > at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > connectionProperties, Options options)
    >
    > at ?.?()
    >
    > at
    >
    System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met
    > hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean
    > fExecuteInContext, Object[]& outArgs)
    >
    > at
    >
    System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMess
    > age msg, IMessageSink replySink)
    >
    > Exception rethrown at [0]:
    >
    > at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message
    reqMsg,
    > Boolean bProxyCase)
    >
    > at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed,
    > MessageData& msgData)
    >
    > at System.Windows.Forms.MethodInvoker.EndInvoke(IAsyncResult result)
    >
    > at RedGate.SQL.Controls.ProgressDialog.?(IAsyncResult )
    >
    >
    >
    >
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Mike,

    I was just curious if the database or server name had something to do
    with this... Sometimes things seem irregular if your database name has
    non-alpha characters in it. This happened in an older version, and since,
    we've tested with Hebrew, Swedish and other languages, but you never know if
    there might still be a bug lurking there somewhere...

    Regards,
    Brian Donahue
    Red Gate Technical Support


    "MikeD" <none> wrote in message news:EHSc$XyGEHA.1484@server53...
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:OKmL6wnFEHA.1520@server53...
    > > The window title of the registration window is called 'registering
    > > dbname', not 'registering <the name of your database>'? That might be a
    > > clue.
    >
    > not sure what point you're trying to make here, i copied the title of the
    > window in verbatim
    >
    > > What is the name of the database you're trying to register?
    >
    > mri_book_db
    >
    >
    >
    >
This discussion has been closed.