Network error.

Hi,
I am facing a weird network problem. I am running a SQL 2000 SP2
enterprise edition over a Windows 2003 enterprise edition machine.
I am getting the network error messages (see below) while trying to
connect to the server. However if i am connected to the server before
the problem occurs i can continue running queries from the query
analyzer but cannot use the object browser to view the tables/ views
etc.
The problem is temporarily fixed if i restart the sql server service
but reappears after some times.
Seems to me it is is not a network problem otherwise the connection
would have broken.
Error 1:
[ODBC SQL Server Driver][DBNETLIB]General network error. Check your
network documentation.
Error 2:
[ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Any idea why this is happening?
Thanks in advance
Taw.
Consider applying SP4, or at least SP3a, to your SQL 2000 instance.
Hope this helps.
Dan Guzman
SQL Server MVP
"Taw" <tawfiq.choudhury@.grameenphone.com> wrote in message
news:1185800793.766706.9030@.l70g2000hse.googlegrou ps.com...
> Hi,
> I am facing a weird network problem. I am running a SQL 2000 SP2
> enterprise edition over a Windows 2003 enterprise edition machine.
> I am getting the network error messages (see below) while trying to
> connect to the server. However if i am connected to the server before
> the problem occurs i can continue running queries from the query
> analyzer but cannot use the object browser to view the tables/ views
> etc.
> The problem is temporarily fixed if i restart the sql server service
> but reappears after some times.
> Seems to me it is is not a network problem otherwise the connection
> would have broken.
> Error 1:
> [ODBC SQL Server Driver][DBNETLIB]General network error. Check your
> network documentation.
> Error 2:
> [ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
> Any idea why this is happening?
> Thanks in advance
> Taw.
>

Network error.

Hi,
I am facing a weird network problem. I am running a SQL 2000 SP2
enterprise edition over a Windows 2003 enterprise edition machine.
I am getting the network error messages (see below) while trying to
connect to the server. However if i am connected to the server before
the problem occurs i can continue running queries from the query
analyzer but cannot use the object browser to view the tables/ views
etc.
The problem is temporarily fixed if i restart the sql server service
but reappears after some times.
Seems to me it is is not a network problem otherwise the connection
would have broken.
Error 1:
[ODBC SQL Server Driver][DBNETLIB]General network error. Check your
network documentation.
Error 2:
[ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Any idea why this is happening?
Thanks in advance
Taw.Consider applying SP4, or at least SP3a, to your SQL 2000 instance.
Hope this helps.
Dan Guzman
SQL Server MVP
"Taw" <tawfiq.choudhury@.grameenphone.com> wrote in message
news:1185800793.766706.9030@.l70g2000hse.googlegroups.com...
> Hi,
> I am facing a weird network problem. I am running a SQL 2000 SP2
> enterprise edition over a Windows 2003 enterprise edition machine.
> I am getting the network error messages (see below) while trying to
> connect to the server. However if i am connected to the server before
> the problem occurs i can continue running queries from the query
> analyzer but cannot use the object browser to view the tables/ views
> etc.
> The problem is temporarily fixed if i restart the sql server service
> but reappears after some times.
> Seems to me it is is not a network problem otherwise the connection
> would have broken.
> Error 1:
> [ODBC SQL Server Driver][DBNETLIB]General network error. Check you
r
> network documentation.
> Error 2:
> [ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
> Any idea why this is happening?
> Thanks in advance
> Taw.
>

Network error.

Hi,
I am facing a weird network problem. I am running a SQL 2000 SP2
enterprise edition over a Windows 2003 enterprise edition machine.
I am getting the network error messages (see below) while trying to
connect to the server. However if i am connected to the server before
the problem occurs i can continue running queries from the query
analyzer but cannot use the object browser to view the tables/ views
etc.
The problem is temporarily fixed if i restart the sql server service
but reappears after some times.
Seems to me it is is not a network problem otherwise the connection
would have broken.
Error 1:
[ODBC SQL Server Driver][DBNETLIB]General network error. Check your
network documentation.
Error 2:
[ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Any idea why this is happening?
Thanks in advance
Taw.Consider applying SP4, or at least SP3a, to your SQL 2000 instance.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Taw" <tawfiq.choudhury@.grameenphone.com> wrote in message
news:1185800793.766706.9030@.l70g2000hse.googlegroups.com...
> Hi,
> I am facing a weird network problem. I am running a SQL 2000 SP2
> enterprise edition over a Windows 2003 enterprise edition machine.
> I am getting the network error messages (see below) while trying to
> connect to the server. However if i am connected to the server before
> the problem occurs i can continue running queries from the query
> analyzer but cannot use the object browser to view the tables/ views
> etc.
> The problem is temporarily fixed if i restart the sql server service
> but reappears after some times.
> Seems to me it is is not a network problem otherwise the connection
> would have broken.
> Error 1:
> [ODBC SQL Server Driver][DBNETLIB]General network error. Check your
> network documentation.
> Error 2:
> [ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
> Any idea why this is happening?
> Thanks in advance
> Taw.
>

Network error when running a query

Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I receive
an error very often
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead())
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation."
How can I fix it?Hi,
Do you have SQL Server on Windows 2003?
If you do, try removing Named Pipes from Enabled Network Libraries in Server
Network Utility.
--
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
> Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
> receive
> an error very often
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead())
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation."
> How can I fix it?
>|||Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows Server
2003 machine. But how will removing Named Piies influence application
performance? Do I need to stop and restart production server after
reconfiguration?
Elena
"Danijel Novak" wrote:
> Hi,
> Do you have SQL Server on Windows 2003?
> If you do, try removing Named Pipes from Enabled Network Libraries in Server
> Network Utility.
> --
> Danijel Novak
>
> "Elena" <Elena@.discussions.microsoft.com> wrote in message
> news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
> > Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
> > receive
> > an error very often
> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> > (WrapperRead())
> > Server: Msg 11, Level 16, State 1, Line 0
> > General network error. Check your network documentation."
> > How can I fix it?
> >
>
>|||Hi,
removing Named Pipes should not influence application performance. Just keep
TCP/IP in there.
I'm not sure about restarting the service but I think you don't have to
restart SQL Server for that.
--
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:0CD3D9ED-DA33-4D7B-BDD3-C3C486158A68@.microsoft.com...
> Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows
> Server
> 2003 machine. But how will removing Named Piies influence application
> performance? Do I need to stop and restart production server after
> reconfiguration?
> Elena
> "Danijel Novak" wrote:
>> Hi,
>> Do you have SQL Server on Windows 2003?
>> If you do, try removing Named Pipes from Enabled Network Libraries in
>> Server
>> Network Utility.
>> --
>> Danijel Novak
>>
>> "Elena" <Elena@.discussions.microsoft.com> wrote in message
>> news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
>> > Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
>> > receive
>> > an error very often
>> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
>> > (WrapperRead())
>> > Server: Msg 11, Level 16, State 1, Line 0
>> > General network error. Check your network documentation."
>> > How can I fix it?
>> >
>>

Network error when running a query

Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I receive
an error very often
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead())
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation."
How can I fix it?
Hi,
Do you have SQL Server on Windows 2003?
If you do, try removing Named Pipes from Enabled Network Libraries in Server
Network Utility.
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
> Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
> receive
> an error very often
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead())
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation."
> How can I fix it?
>
|||Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows Server
2003 machine. But how will removing Named Piies influence application
performance? Do I need to stop and restart production server after
reconfiguration?
Elena
"Danijel Novak" wrote:

> Hi,
> Do you have SQL Server on Windows 2003?
> If you do, try removing Named Pipes from Enabled Network Libraries in Server
> Network Utility.
> --
> Danijel Novak
>
> "Elena" <Elena@.discussions.microsoft.com> wrote in message
> news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
>
>
|||Hi,
removing Named Pipes should not influence application performance. Just keep
TCP/IP in there.
I'm not sure about restarting the service but I think you don't have to
restart SQL Server for that.
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:0CD3D9ED-DA33-4D7B-BDD3-C3C486158A68@.microsoft.com...[vbcol=seagreen]
> Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows
> Server
> 2003 machine. But how will removing Named Piies influence application
> performance? Do I need to stop and restart production server after
> reconfiguration?
> Elena
> "Danijel Novak" wrote:

Network error when running a query

Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I receive
an error very often
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (Wr
apperRead())
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation."
How can I fix it?Hi,
Do you have SQL Server on Windows 2003?
If you do, try removing Named Pipes from Enabled Network Libraries in Server
Network Utility.
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
> Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
> receive
> an error very often
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead())
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation."
> How can I fix it?
>|||Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows Server
2003 machine. But how will removing Named Piies influence application
performance? Do I need to stop and restart production server after
reconfiguration?
Elena
"Danijel Novak" wrote:

> Hi,
> Do you have SQL Server on Windows 2003?
> If you do, try removing Named Pipes from Enabled Network Libraries in Serv
er
> Network Utility.
> --
> Danijel Novak
>
> "Elena" <Elena@.discussions.microsoft.com> wrote in message
> news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
>
>|||Hi,
removing Named Pipes should not influence application performance. Just keep
TCP/IP in there.
I'm not sure about restarting the service but I think you don't have to
restart SQL Server for that.
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:0CD3D9ED-DA33-4D7B-BDD3-C3C486158A68@.microsoft.com...[vbcol=seagreen]
> Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows
> Server
> 2003 machine. But how will removing Named Piies influence application
> performance? Do I need to stop and restart production server after
> reconfiguration?
> Elena
> "Danijel Novak" wrote:
>

network error

Hi,
Running a stored procedure in query analyser returns data but when running the asp.net page which uses that stored procedure returns an exception which is:
General network error. Check your network documentation

Do you know what the problem could be please?
ThanksNetwork errors are your SQL Server is installed with the local systems account which leaves SQL Server Agent without Network permissions. The solution you have to install SQL Server with a service account. Hope this helps.

Kind regards,
Gift Peddie|||Hi,
Are you sure this is the solution?
It's just that the query works for some and not for all of the queries that are passed through the network.
Thanks|||Installing SQL Server with a service account is good practice in all but free standing developer boxes because after SQL Server Service, SQL Server Agent is the next most important service in SQL Server. Some distributed queries will fail and you cannot run Replication because the Local Systems account leaves SQL Server Agent without Network permissions. Hope this helps.

Kind regards,
Gift Peddie

Network Connects to Wrong SQL Instance

I have a server running Windows Server 2003 with two instances of SQL Server
2000 - a default instance and a named instance I shall call "INSTANCE_A".
Locally, SQL Server works correctly. Query Analyzer connects to both
instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
network, when I connect to default instance SERVER it actually connects to
SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is unchange
d
and works correctly. Port numbers are set correctly to 1433 and 1226
respectively. The server has been rebooted several times - no change. All
network clients are behaving the same - they all see SERVER\INSTANCE_A when
pointed to SERVER. Any ideas on what's gone wrong?"Jonno" <Jonno@.discussions.microsoft.com> wrote in message
news:57B7981D-0750-43F9-8BB5-F39B4A581570@.microsoft.com...
>I have a server running Windows Server 2003 with two instances of SQL
>Server
> 2000 - a default instance and a named instance I shall call "INSTANCE_A".
> Locally, SQL Server works correctly. Query Analyzer connects to both
> instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
> network, when I connect to default instance SERVER it actually connects to
> SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is
> unchanged
> and works correctly. Port numbers are set correctly to 1433 and 1226
> respectively. The server has been rebooted several times - no change. All
> network clients are behaving the same - they all see SERVER\INSTANCE_A
> when
> pointed to SERVER. Any ideas on what's gone wrong?
Validate that the remote clients are connecting over TCP/IP.
Validate the ports the instances are using by looking into the log file for
each intance.
David|||Thanks David
Both instances have TCP/IP only.
Log files show that both instances are listening on TCP, with default
instance listening on port 1433, and INSTANCE_A listening on port 1226.
Is it possible the publishing of the default instance has become corrupted?
I've tried re-registering from the client side, but the problem persists.
"David Browne" wrote:

> "Jonno" <Jonno@.discussions.microsoft.com> wrote in message
> news:57B7981D-0750-43F9-8BB5-F39B4A581570@.microsoft.com...
>
> Validate that the remote clients are connecting over TCP/IP.
> Validate the ports the instances are using by looking into the log file fo
r
> each intance.
>
> David
>
>

Network Connects to Wrong SQL Instance

I have a server running Windows Server 2003 with two instances of SQL Server
2000 - a default instance and a named instance I shall call "INSTANCE_A".
Locally, SQL Server works correctly. Query Analyzer connects to both
instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
network, when I connect to default instance SERVER it actually connects to
SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is unchanged
and works correctly. Port numbers are set correctly to 1433 and 1226
respectively. The server has been rebooted several times - no change. All
network clients are behaving the same - they all see SERVER\INSTANCE_A when
pointed to SERVER. Any ideas on what's gone wrong?"Jonno" <Jonno@.discussions.microsoft.com> wrote in message
news:57B7981D-0750-43F9-8BB5-F39B4A581570@.microsoft.com...
>I have a server running Windows Server 2003 with two instances of SQL
>Server
> 2000 - a default instance and a named instance I shall call "INSTANCE_A".
> Locally, SQL Server works correctly. Query Analyzer connects to both
> instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
> network, when I connect to default instance SERVER it actually connects to
> SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is
> unchanged
> and works correctly. Port numbers are set correctly to 1433 and 1226
> respectively. The server has been rebooted several times - no change. All
> network clients are behaving the same - they all see SERVER\INSTANCE_A
> when
> pointed to SERVER. Any ideas on what's gone wrong?
Validate that the remote clients are connecting over TCP/IP.
Validate the ports the instances are using by looking into the log file for
each intance.
David|||Thanks David
Both instances have TCP/IP only.
Log files show that both instances are listening on TCP, with default
instance listening on port 1433, and INSTANCE_A listening on port 1226.
Is it possible the publishing of the default instance has become corrupted?
I've tried re-registering from the client side, but the problem persists.
"David Browne" wrote:
> "Jonno" <Jonno@.discussions.microsoft.com> wrote in message
> news:57B7981D-0750-43F9-8BB5-F39B4A581570@.microsoft.com...
> >I have a server running Windows Server 2003 with two instances of SQL
> >Server
> > 2000 - a default instance and a named instance I shall call "INSTANCE_A".
> > Locally, SQL Server works correctly. Query Analyzer connects to both
> > instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
> > network, when I connect to default instance SERVER it actually connects to
> > SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is
> > unchanged
> > and works correctly. Port numbers are set correctly to 1433 and 1226
> > respectively. The server has been rebooted several times - no change. All
> > network clients are behaving the same - they all see SERVER\INSTANCE_A
> > when
> > pointed to SERVER. Any ideas on what's gone wrong?
>
> Validate that the remote clients are connecting over TCP/IP.
> Validate the ports the instances are using by looking into the log file for
> each intance.
>
> David
>
>

Network Backup

I want to backup up one of my Database running on SQL
Server 2000 on to
another machine on the network. I already have a Database
Maintenace plan
set up which backs up the database on the same box. But
now I want to back
it up on a different machine as a disaster recovery
measure. Under the
Enterprise Managerin SQL Server I only have the option to
back it up on
a device and cant seem to do it over the Network. Anyone
has any ideas on
how to do this without using a 3rd party software?
I was told to just specify the UNC path
(\\servername\share for example) and
make sure the
account used by the sql server service has privileges on
that network share
but when I try to do that the Database Maintanence plan
chucks back with an
error "The complete database backup
directory"\\servername\share" is
invalid. Are you sure this is what you want?"
I havent actually tried clicking YES to that as yet...is
it really an error
message? I have also looked at the following article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q304261
this article talks about turning on
trace flag 1807 to by pass the default setting of not
being able to create a
database file on a mapped or UNC network location.
Im new to SQL Server so havent got a clue where to turn on
these flags from.
Im assuming its a commandline option, but where to do it
from Iam
stuck...will anyone will be able to help me with this?
Thanks in advance
AdnanHi
You can use a UNC as the filename or create a device that uses one.
John
"Adnan" <adnan@.clara.net> wrote in message
news:070f01c354fc$f7dea040$a101280a@.phx.gbl...
> I want to backup up one of my Database running on SQL
> Server 2000 on to
> another machine on the network. I already have a Database
> Maintenace plan
> set up which backs up the database on the same box. But
> now I want to back
> it up on a different machine as a disaster recovery
> measure. Under the
> Enterprise Managerin SQL Server I only have the option to
> back it up on
> a device and cant seem to do it over the Network. Anyone
> has any ideas on
> how to do this without using a 3rd party software?
> I was told to just specify the UNC path
> (\\servername\share for example) and
> make sure the
> account used by the sql server service has privileges on
> that network share
> but when I try to do that the Database Maintanence plan
> chucks back with an
> error "The complete database backup
> directory"\\servername\share" is
> invalid. Are you sure this is what you want?"
> I havent actually tried clicking YES to that as yet...is
> it really an error
> message? I have also looked at the following article
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q304261
> this article talks about turning on
> trace flag 1807 to by pass the default setting of not
> being able to create a
> database file on a mapped or UNC network location.
> Im new to SQL Server so havent got a clue where to turn on
> these flags from.
> Im assuming its a commandline option, but where to do it
> from Iam
> stuck...will anyone will be able to help me with this?
> Thanks in advance
> Adnan
>|||Make sure you set the destination folder on the other server to allow
sharing.
Otherwise, the folder will not appear available for access.
"Adnan" <adnan@.clara.net> wrote in message
news:070f01c354fc$f7dea040$a101280a@.phx.gbl...
> I want to backup up one of my Database running on SQL
> Server 2000 on to
> another machine on the network. I already have a Database
> Maintenace plan
> set up which backs up the database on the same box. But
> now I want to back
> it up on a different machine as a disaster recovery
> measure. Under the
> Enterprise Managerin SQL Server I only have the option to
> back it up on
> a device and cant seem to do it over the Network. Anyone
> has any ideas on
> how to do this without using a 3rd party software?
> I was told to just specify the UNC path
> (\\servername\share for example) and
> make sure the
> account used by the sql server service has privileges on
> that network share
> but when I try to do that the Database Maintanence plan
> chucks back with an
> error "The complete database backup
> directory"\\servername\share" is
> invalid. Are you sure this is what you want?"
> I havent actually tried clicking YES to that as yet...is
> it really an error
> message? I have also looked at the following article
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q304261
> this article talks about turning on
> trace flag 1807 to by pass the default setting of not
> being able to create a
> database file on a mapped or UNC network location.
> Im new to SQL Server so havent got a clue where to turn on
> these flags from.
> Im assuming its a commandline option, but where to do it
> from Iam
> stuck...will anyone will be able to help me with this?
> Thanks in advance
> Adnan
>sql

Netscape Support

Can someone give me the status of Reporting Services support for
Netscape 7.1? I'm running sp1, and the report toolbar features
such as Export and Paging won't work in Netscape. Also
the formatting is all messed up. Books online
says Netscape 7.1 is supported- what's the deal?
Is there a patch or a workaround?
thanks,
Thomson Developer
Thomson LearningThere is a patch, and it is called IE6! ;-)))
"thomsonDeveloper" <thomsonDeveloper@.discussions.microsoft.com> wrote in
message news:4F568713-FFD2-42F0-B938-E43C0CD7441B@.microsoft.com...
> Can someone give me the status of Reporting Services support for
> Netscape 7.1? I'm running sp1, and the report toolbar features
> such as Export and Paging won't work in Netscape. Also
> the formatting is all messed up. Books online
> says Netscape 7.1 is supported- what's the deal?
> Is there a patch or a workaround?
> thanks,
> Thomson Developer
> Thomson Learning|||I'm not sure about the rest of you, but I consider Microsoft's lack of
support for Netscape / Mozilla / Opera a little shortsighted. What if you
plan on deploying to your outside clients? This will be a big issue. I
don't understand how keeping all of this IE specific helps MS or your
organization...
JD
On Fri, 22 Oct 2004 13:35:48 +0200, Marcus Phass wrote:
> There is a patch, and it is called IE6! ;-)))
> "thomsonDeveloper" <thomsonDeveloper@.discussions.microsoft.com> wrote in
> message news:4F568713-FFD2-42F0-B938-E43C0CD7441B@.microsoft.com...
>> Can someone give me the status of Reporting Services support for
>> Netscape 7.1? I'm running sp1, and the report toolbar features
>> such as Export and Paging won't work in Netscape. Also
>> the formatting is all messed up. Books online
>> says Netscape 7.1 is supported- what's the deal?
>> Is there a patch or a workaround?
>> thanks,
>> Thomson Developer
>> Thomson Learning|||Sorry Marcus but your answer is not good enough.
As a vendor I can not dictate to my clients which browser to use. In actual
fact I dont think that making the report viewer cross browser capable is a
lot of work but rather microsofts decision not to.
Reporting Services have so much potential to be a great solution but the
lack of plain simple RTF support and cross browser /platform support is 2
small issues that I rate extremly high for a basic report service.|||Simply I have a solution to the Netscape / Non IE browser
incompatibilites in the toolbar.
On the note of Netscape / Firefox / Safari support on Report Server it
has been nearly the bane on of my Reporting Services experience for the
last 5 months.
I have tried nearly everything possible to make Reporting Services WORK
Correctly with Netscape. (even at one point coming up with a hack to
have RS Load MY Javascript files instead of the ones MS Weeds into the
Resouces Files of the assembely)
The problem as most of you are aware (that are familiar with the
Netscape - Non -IE ) the MAIN Problem lies in the Toolbar
2 days ago I decided to resolve this once an for all, as I have a
client that uses all macs (safari and IE) And since Drill Down /
Export dosent work readily on Mac IE I had to do something drastic
(Although I do have a hack to make this work as well.
What I did was write my own toolbar component. The only thing it lacks
is the "FIND" And I doubt I will add it as nearly all our reports (Of
75 only 1 is multi page)
The neat part is it isnt a hack, its clean and slick , and Export
works, and Paging works , and Zoom works, on ANY Browser, better Yet I
am not using ANY Javascipt and it all works just fine with IE TOO !!!
Now all that said I have tried to think of what to do with what I have
come up with , since MS is too lazy (I'm pretty sure they simply choose
not to acknowledge other browsers as that would be some kind of
recognition or validation in the strange land of MS)
What I have done has value to me first of all, since I can now aside
from a very few cosmetic issues in NS deploy reports cross browser
without fear.
But does it have value (yes cash value) to others of you out there , as
either a custom control, or as a thrid party product ?
Or as some kind of source liscencing deal with other developers and
Reporting Services users ?
I have not seen this elsewhere and have looked and looked so I wrote
it, if you have interest in such an item drop me a line, or post here I
am curious to find out if there is interest.
Chris Wertman
Gideon wrote:
> Sorry Marcus but your answer is not good enough.
> As a vendor I can not dictate to my clients which browser to use. In
actual
> fact I dont think that making the report viewer cross browser capable
is a
> lot of work but rather microsofts decision not to.
> Reporting Services have so much potential to be a great solution but
the
> lack of plain simple RTF support and cross browser /platform support
is 2
> small issues that I rate extremly high for a basic report service.|||I would be interested in how you got it to work. I like to use quality apps first when available and why I use Firefox. I HAVE to use reporting services although the amount of problems I have run into it would have been far cheaper in the long run to have just purchased ActiveReports. In alot easier to develop reports with. sigh...
java_cruise
--
Message posted via http://www.sqlmonster.com|||Not to be terse, I am really not, but lots of reading.
And a little custom voddoo
Start with reading all the XML and URL Access info, I actually use a
combination webservice and HTML Utl access to get what I want and do
what I want, then mix those up, kill Cookie Based Sessions (This will
enable the drill down to work from with the frameset even on IE
(Without this it will only work on NS), Create a new frameset and do
some parsing of the report as it is being passed through the server to
capture (80% of the hard part) the pagecount for the pager to work.
I am prettying it up with a .Net 2.0 "Look" toolbar and I will post
some shots next week, I am also writing a custom FORM Based Security
mechanism for report based access that will work against the .Net 2.0
authentication provider (at least within a client)
I have seen and been mailed a ton of time on how I actually got mine to
work (the form based auth) so I figured I would post at least that, I
am still thinking if its better to provide it as a paid item, or charge
for it (It seems that even when I release something free I spend MORE
time supporting those who would implement it)
Chris
java cruise via SQLMonster.com wrote:
> I would be interested in how you got it to work. I like to use
quality apps first when available and why I use Firefox. I HAVE to use
reporting services although the amount of problems I have run into it
would have been far cheaper in the long run to have just purchased
ActiveReports. In alot easier to develop reports with. sigh...
>
> java_cruise
> --
> Message posted via http://www.sqlmonster.com|||Chris,
Were you able to fix the non-IE browser formatting issues as well as
the toolbar? We would be very interested in your solution if this is
the case.
TIA,
Greg
greg @. adsys dot com|||I didnt because it wast an issue for me.
You could "re-render" the report as it passes throught the toolbar (the
replacment toolbar) swapping out MS specific code that causes problems
in Netscape.
Generally for me at least the only thing that happens is the reports
get a little "squished" width wise , so when writing them I have the
report guys make em wider :)
Now we do only a very simple (visually) report thats are tables in a
grid like arrangment so I wouldnt know of other issues.
And like I said you could easily swap out the offending code at runtime
, assuming it is a tag or combination of tags that are casuing the
grief.
Chris
ghesla@.gmail.com wrote:
> Chris,
> Were you able to fix the non-IE browser formatting issues as well as
> the toolbar? We would be very interested in your solution if this is
> the case.
> TIA,
> Greg
> greg @. adsys dot com|||I didnt because it wast an issue for me.
You could "re-render" the report as it passes throught the toolbar (the
replacment toolbar) swapping out MS specific code that causes problems
in Netscape.
Generally for me at least the only thing that happens is the reports
get a little "squished" width wise , so when writing them I have the
report guys make em wider :)
Now we do only a very simple (visually) report thats are tables in a
grid like arrangment so I wouldnt know of other issues.
And like I said you could easily swap out the offending code at runtime
, assuming it is a tag or combination of tags that are casuing the
grief.
Chris
ghesla@.gmail.com wrote:
> Chris,
> Were you able to fix the non-IE browser formatting issues as well as
> the toolbar? We would be very interested in your solution if this is
> the case.
> TIA,
> Greg
> greg @. adsys dot com|||I am interested. If you can give me a proof of concept or demo of some sort,
we can talk money. I don't care to develop this nor am I all that interested
how it works, I'd just rather pay for it and be done with it.
"WertmanTheMad" wrote:
> Simply I have a solution to the Netscape / Non IE browser
> incompatibilites in the toolbar.
> On the note of Netscape / Firefox / Safari support on Report Server it
> has been nearly the bane on of my Reporting Services experience for the
> last 5 months.
> I have tried nearly everything possible to make Reporting Services WORK
> Correctly with Netscape. (even at one point coming up with a hack to
> have RS Load MY Javascript files instead of the ones MS Weeds into the
> Resouces Files of the assembely)
> The problem as most of you are aware (that are familiar with the
> Netscape - Non -IE ) the MAIN Problem lies in the Toolbar
> 2 days ago I decided to resolve this once an for all, as I have a
> client that uses all macs (safari and IE) And since Drill Down /
> Export dosent work readily on Mac IE I had to do something drastic
> (Although I do have a hack to make this work as well.
> What I did was write my own toolbar component. The only thing it lacks
> is the "FIND" And I doubt I will add it as nearly all our reports (Of
> 75 only 1 is multi page)
> The neat part is it isnt a hack, its clean and slick , and Export
> works, and Paging works , and Zoom works, on ANY Browser, better Yet I
> am not using ANY Javascipt and it all works just fine with IE TOO !!!
> Now all that said I have tried to think of what to do with what I have
> come up with , since MS is too lazy (I'm pretty sure they simply choose
> not to acknowledge other browsers as that would be some kind of
> recognition or validation in the strange land of MS)
> What I have done has value to me first of all, since I can now aside
> from a very few cosmetic issues in NS deploy reports cross browser
> without fear.
> But does it have value (yes cash value) to others of you out there , as
> either a custom control, or as a thrid party product ?
> Or as some kind of source liscencing deal with other developers and
> Reporting Services users ?
> I have not seen this elsewhere and have looked and looked so I wrote
> it, if you have interest in such an item drop me a line, or post here I
> am curious to find out if there is interest.
> Chris Wertman
>
>
>
>
> Gideon wrote:
> > Sorry Marcus but your answer is not good enough.
> >
> > As a vendor I can not dictate to my clients which browser to use. In
> actual
> > fact I dont think that making the report viewer cross browser capable
> is a
> > lot of work but rather microsofts decision not to.
> >
> > Reporting Services have so much potential to be a great solution but
> the
> > lack of plain simple RTF support and cross browser /platform support
> is 2
> > small issues that I rate extremly high for a basic report service.
>|||You can solve this by writing your own Rendering method. See the microsoft
link below.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_intro_1pia.asp
If the image get squished, write a small javascript to disable the style
attribute of images. It worked for me.
Kanchana Eramudugoda
"Eddie" wrote:
> I am interested. If you can give me a proof of concept or demo of some sort,
> we can talk money. I don't care to develop this nor am I all that interested
> how it works, I'd just rather pay for it and be done with it.
>
> "WertmanTheMad" wrote:
> > Simply I have a solution to the Netscape / Non IE browser
> > incompatibilites in the toolbar.
> >
> > On the note of Netscape / Firefox / Safari support on Report Server it
> > has been nearly the bane on of my Reporting Services experience for the
> > last 5 months.
> >
> > I have tried nearly everything possible to make Reporting Services WORK
> > Correctly with Netscape. (even at one point coming up with a hack to
> > have RS Load MY Javascript files instead of the ones MS Weeds into the
> > Resouces Files of the assembely)
> >
> > The problem as most of you are aware (that are familiar with the
> > Netscape - Non -IE ) the MAIN Problem lies in the Toolbar
> >
> > 2 days ago I decided to resolve this once an for all, as I have a
> > client that uses all macs (safari and IE) And since Drill Down /
> > Export dosent work readily on Mac IE I had to do something drastic
> > (Although I do have a hack to make this work as well.
> >
> > What I did was write my own toolbar component. The only thing it lacks
> > is the "FIND" And I doubt I will add it as nearly all our reports (Of
> > 75 only 1 is multi page)
> >
> > The neat part is it isnt a hack, its clean and slick , and Export
> > works, and Paging works , and Zoom works, on ANY Browser, better Yet I
> > am not using ANY Javascipt and it all works just fine with IE TOO !!!
> >
> > Now all that said I have tried to think of what to do with what I have
> > come up with , since MS is too lazy (I'm pretty sure they simply choose
> > not to acknowledge other browsers as that would be some kind of
> > recognition or validation in the strange land of MS)
> >
> > What I have done has value to me first of all, since I can now aside
> > from a very few cosmetic issues in NS deploy reports cross browser
> > without fear.
> >
> > But does it have value (yes cash value) to others of you out there , as
> > either a custom control, or as a thrid party product ?
> >
> > Or as some kind of source liscencing deal with other developers and
> > Reporting Services users ?
> >
> > I have not seen this elsewhere and have looked and looked so I wrote
> > it, if you have interest in such an item drop me a line, or post here I
> > am curious to find out if there is interest.
> >
> > Chris Wertman
> >
> >
> >
> >
> >
> >
> >
> >
> > Gideon wrote:
> > > Sorry Marcus but your answer is not good enough.
> > >
> > > As a vendor I can not dictate to my clients which browser to use. In
> > actual
> > > fact I dont think that making the report viewer cross browser capable
> > is a
> > > lot of work but rather microsofts decision not to.
> > >
> > > Reporting Services have so much potential to be a great solution but
> > the
> > > lack of plain simple RTF support and cross browser /platform support
> > is 2
> > > small issues that I rate extremly high for a basic report service.
> >
> >

NetApp Filers - Does MS support them, and do they work?

I've posed this before, but never seem to get a concrete answer:
1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
running iSCSI supported by MS for SQL 2000 implementations?
2) Does anyone run a similar configuration and run into problems?
Thanks everyone1) A snip from the KB below
Windows Hardware Quality Lab (WHQL) Qualified Devices
Microsoft Windows servers and networked servers or NAS storage servers that
are Windows Hardware Quality Lab (WHQL) certified automatically meet the
data write ordering and write-through guarantees required to support a SQL
Server storage device. Microsoft supports both application and
storage-related issues in these configurations.
Other Devices
If you use a non-WHQL qualified storage device with SQL Server that supports
the I/O guarantees for transactional database use described in this article,
Microsoft will provide full support for SQL Server and SQL Server-based
applications.
INF: Support for Network Database Files
http://support.microsoft.com/?kbid=304261
You can check the status of the exact model here
http://www.microsoft.com/windows/catalog/server/
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gary Klohouse" <fastman@.earthlink.net> wrote in message
news:OfDHJUjfEHA.2812@.tk2msftngp13.phx.gbl...
> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>|||they are not great with Sequential Reads.
We use a NetApp filer and are not totally satisfied.
we are moving off to a Hitachi SAN.
Cheers,
Greg Jackson
PDX, Oregon

NET2 and Reporting Services

Is it possible to get Reporting Services running on a server wtih .NET2 beta1
installed?
thanksNot sure if order of install makes a difference but right now i'm
running XP Pro SP1, VS2002, VS2003, .NET1.0, .NET1.1, and .NET2.0 on
my machine with reporting services and i have no probs. .NET 2.0 was
the last thing i installed.
"marv" <marv@.discussions.microsoft.com> wrote in message news:<45C73938-019C-4402-A50D-87B6510CF5C8@.microsoft.com>...
> Is it possible to get Reporting Services running on a server wtih .NET2 beta1
> installed?
> thanks

NET Framwork version

How can I check .NET Framwork version on my SQL Server ?
I am running two Servers on windows 2000 and 2003
Thanks
Probably easiest way is to create CLR SP or UDF, which puts into pipe
Environment.Version.ToString()
HTH
Alex
<msnews.microsoft.com> wrote in message
news:end3y7UqHHA.3248@.TK2MSFTNGP03.phx.gbl...
> How can I check .NET Framwork version on my SQL Server ?
> I am running two Servers on windows 2000 and 2003
> Thanks
>

NET Framwork version

How can I check .NET Framwork version on my SQL Server ?
I am running two Servers on windows 2000 and 2003
ThanksProbably easiest way is to create CLR SP or UDF, which puts into pipe
Environment.Version.ToString()
HTH
Alex
<msnews.microsoft.com> wrote in message
news:end3y7UqHHA.3248@.TK2MSFTNGP03.phx.gbl...
> How can I check .NET Framwork version on my SQL Server ?
> I am running two Servers on windows 2000 and 2003
> Thanks
>

NET Framwork version

How can I check .NET Framwork version on my SQL Server ?
I am running two Servers on Windows 2000 and 2003
ThanksProbably easiest way is to create CLR SP or UDF, which puts into pipe
Environment.Version.ToString()
HTH
Alex
<msnews.microsoft.com> wrote in message
news:end3y7UqHHA.3248@.TK2MSFTNGP03.phx.gbl...
> How can I check .NET Framwork version on my SQL Server ?
> I am running two Servers on Windows 2000 and 2003
> Thanks
>

Nested views

When running reports from data, is it faster using nested views approx 4 levels deep, or writing data to a temp tables then running the report?

When you say "4 levels deep" do you mean 4 joins? you might want to test it out. There will be an overhead of creating a temp table, inserting data into it, followed by a SELECT from the temp table. If your report will be run by thousands of users simultaneously you might even see a degradation in performance due to tempdb contention.

|||

By 4 levels deep I mean View1 is a query of 6 tables and several joins, then view2 use view1 with some more tables and joins or calculations etc etc.

Basically the end result in view4 is too complex to write in 1 query or 1 view so you go as far as you can in view1, then expand that result using view2 etc.

So any ideas on performance??

|||

Off the top of the head, since its not a simple query, I cant think of any, so your best bet is to test it out quickly. You can fire up profiler or use SET STATS IO ON and some others like TIME etc and see if there is any improvement/degradation in performance.

Nested Set Model: Excluding Branches...

I'm using the nested set model on to manage a sitemap index in my CMS application. The one issue I'm running in to is how to dynamically remove branches from the tree. I can get specific nodes to be removed from the querying, but their children really need removed as well. Currently the only way I've found to do this, is to use a cursor and go copy the "good" nodes to a temp table. Has anyone found a way to do this?

Here's an example:
- Item 1
- Child 1
- Child 2
- Sub 1
- Sub 2
- Sub 3
- Child 3
- Item 2
- Item 3
- Child 1
- Sub 1
- Child 2
- Item 4

In the above tree, let's say I need to temporarily remove the "Item 3" node and it's children. I can remove "Item 3" easily enough, but the children items remain. Nothing I've come up with will exclude *all* the children (regarding of the depth of the nodes.)

Anyone have any ideas?

Thanks,
DanThis should work:

SELECT *
FROM ns
WHERE ns_id NOT IN (
SELECT n1.ns_id
FROM ns n1, ns n2
WHERE n1.ns_left >= n2.ns_left
AND n1.ns_right <= n2.ns_right
AND n2.ns_id = 10 -- ie. primary key of 'item 3'
)

First, you need to get a list of primary keys which represent the rows you don't want - ie. item3 and all of its children. You then use a subquery to remove these from the result set.

macka.|||Originally posted by macka
This should work:

SELECT *
FROM ns
WHERE ns_id NOT IN (
SELECT n1.ns_id
FROM ns n1, ns n2
WHERE n1.ns_left >= n2.ns_left
AND n1.ns_right <= n2.ns_right
AND n2.ns_id = 10 -- ie. primary key of 'item 3'
)

First, you need to get a list of primary keys which represent the rows you don't want - ie. item3 and all of its children. You then use a subquery to remove these from the result set.

macka.

Perfect! I played around w/combinations that were close yesterday, but I was seriously overly complicating the process.

Thanks a million!
-Dan

Nested Loop Join - need help :)

i'm running the following code on Ms SQL Server 2000, Query Analyzer to analyze the result of Nested Loop Join.

SET STATISTICS PROFILE ON
GO
SELECT pdN.ProductID, pdN.ProductName,
spN.CompanyName, spN.ContactName
FROM dbo.ProductsNew pdN
INNER JOIN dbo.SuppliersNew spN
ON pdN.SupplierId = spN.SupplierId
GO

but the execution plan give me the following result :-

http://i31.photobucket.com/albums/c366/i3lu3fun/executionplan.jpg

instead of using nested, why does it using hash join? is there anything wrong with my code?Hi

Welcome to the forum :D

Nowt wrong with your query. I didn't enlarge your image however the optimiser will select the best plan it can (within certain provisos e.g. it selects the best plan within a time limit, it bases it's plan on available statistics etc.). As such - it is probable for this query that a hash join is better than a nested loop join. BOL illustrates such cases:

A nested loops join is particularly effective if the outer input is quite small and the inner input is preindexed and quite large. In many small transactions, such as those affecting only a small set of rows, index nested loops joins are far superior to both merge joins and hash joins. In large queries, however, nested loops joins are often not the optimal choice.

Short of using hints (which is a bad idea unless you really know what you are doing and, arguably, not even then) all you can do is make sure that you write good, efficient SQL (as you have), ensure statistics are up to date and indexes are optimal. SQL Server does the rest.

HTH|||Thank you for replying :D

Is it possible for me to still get the result of using nested loop join because i need to make a comparison between the execution time of using nested loop, hash & merge join. Will i get the result that i want if i use FORCE option?|||You can force these using Join Hints - check the BOL entries for "FROM" and "Hints".|||BTW - out of curiosity - how come you want to compare the three rather than leave it up to the optimiser?|||hehe, thanks.
I'm doing my FYP, and i need this results to be included in the report. Plus, i need to come up with a better algorithm, to retrieve data in distributed database. Thanks again for ur help.|||where is it the BOL entries :p, sorry newbie here i couldn't find it.|||I'm doing my FYP, and i need this results to be included in the report.
Aw - an RFH.

Ah well - I noticed a little gotcha that I didn't know re hints (unsurprising as you can probably tell I don't tend to use them) - see if you can spot it. Having reread BOL I think that it is referred to but it is rather under stated...|||where is it the BOL entries :p, sorry newbie here i couldn't find it.Well - you are looking for Join Hints so I guess you need to search for... :rolleyes:

Nested Distributed Transactions?

Hi All,

Is it possible to have a Distributed Transaction running within another distributed transaction and so on.

I have 3 servers(Servers A, B, and C). Server A has a linked server to Server B and Server B has a linked server to Server C. I have two triggers. One that resides on Server A and Updates Server B and Another on Server B that updates Server C. Trigger on Server A invokes a distributed transaction with Server B to Update it which in turn fires the trigger on Server B which invokes another distributed transaction with Server C.

Now is this possible?? If not how can I get Around this?? I can not just a distributed transaction on the trigger which resides on server A as the one on Server B can fire on its own and not always because of Server A.

Is it possible to have nested distributed transactions like Begin/Ends??

Thanks
AnthonyShould be OK.

Every trigger runs within a transaction and this should be automatically upgraded to a distributed transaction for cross server operations so you shouldn't have to do any coding aprt from the set xact_abort on.