显示标签为“company”的博文。显示所有博文
显示标签为“company”的博文。显示所有博文

2012年3月9日星期五

Fix DBNETLIB General Network Error

I have a friend at another company that is getting this error:

03/07/2007 16:03:49 Version 21.00.69 - UID - xxx - Error -2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

I have checked around and found two potential fixes for this problem. The first one describes this as a problem specific to the Named Pipes protocol. The fix is listed as available from this site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452

The second fix is listed as making an additional entry to the registry like this:

The problem arises on a busy SQL system and some requests will randomly seem
to be dropped with a General Network Error.

To fix:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters
Add a new DWORD key SynAttackProtect with value of 0. Restart server.

Can someone tell me if either or both of these approaches is correct?

I guess I will be trying the registry fix.

Fix DBNETLIB General Network Error

I have a friend at another company that is getting this error:

03/07/2007 16:03:49 Version 21.00.69 - UID - xxx - Error -2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

I have checked around and found two potential fixes for this problem. The first one describes this as a problem specific to the Named Pipes protocol. The fix is listed as available from this site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452

The second fix is listed as making an additional entry to the registry like this:

The problem arises on a busy SQL system and some requests will randomly seem
to be dropped with a General Network Error.

To fix:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters
Add a new DWORD key SynAttackProtect with value of 0. Restart server.

Can someone tell me if either or both of these approaches is correct?

I guess I will be trying the registry fix.

2012年3月7日星期三

first SQL conn

Hi forum, thought about time I updated from OleDB to SqlClient.

My remote host company supports MS SQL Server 2005, I have created a testsql.mdf, now I want to connect to that database,( im used to writing Access conn like below and have updated my OleDB code to Sql ).

<%@. Import Namespace="System.Data"%>
<%@. Import Namespace="System.Data.OleDb" %>

strAccessConn ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\\inetpub\\vhosts\\blablabla\\httpdoc\\App_Data\\testdb1.mdb";

How do I write the SQL connection string?

<%@. Import Namespace="System.Data"%>
<%@. Import Namespace="System.Data.SqlClient" %>

strSqlConn =?? this bit ???

This is the remote host path

LocalSqlServer

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

This my first SQL data application so need some help thanks Paul

Check outhttp://www.connectionstrings.com/

2012年2月19日星期日

Firefox browser support

Hi all,
We are trying to use SQL RS 2005 at our Company. We have a mix of MAC and
Windows users and I am trying to see whether RS 2005 can work with FireFox. I
created a simple matrix report and the rendering is quite bad, fields dont
have the right widths (IE shows correctly).
How do I get the matrix reports to show correctly in Firefox? Even if it is
extra code that needs to be written somewhere, thats fine. I just want to
have an idea of where to write the code (to show right widths for fields) and
how to implement the code? Any suggestions?
I know the firefox support for RS 2005 has become a FAQ, but I would like to
explore the work-arounds that can be done.
ThanksSeventhSense wrote:
> Hi all,
> We are trying to use SQL RS 2005 at our Company. We have a mix of MAC and
> Windows users and I am trying to see whether RS 2005 can work with FireFox. I
> created a simple matrix report and the rendering is quite bad, fields dont
> have the right widths (IE shows correctly).
> How do I get the matrix reports to show correctly in Firefox? Even if it is
> extra code that needs to be written somewhere, thats fine. I just want to
> have an idea of where to write the code (to show right widths for fields) and
> how to implement the code? Any suggestions?
> I know the firefox support for RS 2005 has become a FAQ, but I would like to
> explore the work-arounds that can be done.
> Thanks
I am having the same problem. I could tell that the data are shown in
firefox, however, it is so tiny that it is not legible, but they show
up nicely in IE.
Any good solution? Thanks.