Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL 2000ÉèÖÃ - MS-SQL Server / »ù´¡Àà

ÎÒÃÇ ·þÎñÆ÷ ֨װÁËϵͳ£¬ÔÚ×°Íêsql2000Ö®ºó£¬webconfigÁ¬½ÓÊý¾Ý¿â ÊÇ IPµØÖ·ÐÎʽ£¬ÒÔǰ±¾µØÊÇ£¨localhost£©£¬ÔõôÅäÖÃÔ¶³ÌÁ¬½Ó£¿


ÔÚÏß µÈ£¬±È½Ï¼±

û¿´¶®£¬
Ô¶³Ì¾Íдip»ò¼ÆËã»úÃû


ÒýÓÃ
û¿´¶®£¬
Ô¶³Ì¾Íдip»ò¼ÆËã»úÃû
¡£¡£

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ³öÏÖÁËÕâ¸ö´íÎó


ÒýÓÃ
±¾µØÊÇÓÃ127.0.0.1
Ô¶³Ì¾Í¸Ä³ÉÔ¶³ÌµÄµØÖ·¿©
±ÈÈç:Data Source=192.168.0.0;Initial Catalog=Êý¾Ý¿âÃû³Æ;Persist Security Info=True;User ID=Õ˺Å;Password ID=ÃÜÂë;
»¹¿ÉÒÔÔÚIPºóÃæ¸úÉ϶˿Ú
°´Õâ configÀï ¸ÃÊý¾Ý¿â,ÒòΪ ÐèÒªÔ¶³Ì·ÃÎÊ

ÄãÃÇ·þÎñÆ÷ÏÖÔÚÊǶàÉÙip,webconfigÀïÃæ¾Íµ÷ÓöàÉÙip¾Í¿ÉÒÔÁË

connectionString="Data Source=60.217.22*.***; configÀïµÄÉèÖà ,ºÍ·þÎñÆ÷µÄIPÊÇÒ»ÑùµÄ

ÒýÓÃ
ÄãÃÇ·þÎñÆ÷ÏÖÔÚÊǶàÉÙip,webconfigÀïÃæ¾Íµ÷ÓöàÉÙip¾Í¿ÉÒÔÁË
µ«ÊÇÆóÒµ¹ÜÀíÆ÷ ÀïÏÔʾ Êý¾Ý ¿âÊÇlocalhost ,¸Ð¾õÉÏ Ó¦¸Ã ÊǸöÔ¶³ÌIPµØÖ· ²Å¶Ô£¬Ó¦¸ÃÊÇ60.217.22*.*** Õâ¸öIP,¸Ð¾õÉÏ

°Ñ£¨localhost£©¸Ä³ÉÏÂÃæ

127.0.0.1
»ò
ÄãÍø¿¨µÄʵ¼ÊipµØÖ·

¶à¸öÍø¿¨Ê±£¬×¢Òâ¿´ÊDz»ÊÇÿ¸öÍø¿¨¶¼ÔÊÐísqlserverµÄÊý¾Ý¿âÁ¬½Ó


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»ÌõSQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

Ô­SQLÓï¾äSQL code:

SELECT t6.FName '²Ù×÷¹¤',t1.FDate 'ÈÕÆÚ',t5.FName 'ÖÆµ¥ÈË',t3.FName 'É豸',t4.FName '°àÖÆ',
t7.FBillNo '¹¤ÒÕÖ¸Áîµ¥ºÅ',t8.FName '¸Úλ',t2. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ