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

SQLÔ¶³ÌÁ¬½ÓÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÎÒÔÚ±¾»úÁ¬½ÓÊý¾Ý¿âÔËÐгÌÐòûÓÐÎÊÌâ,¿ÉÊÇÎҰѳÌÐò¸ÄΪÁ¬½ÓÔ¶³Ì·þÎñÆ÷ÔËÐоͳöÏÖ((ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) ))Õâ¸ö´íÎó!ÎÒÓõÄÊÇsql2005 EXPRESS£¬ÎÒÒѾ­°´ÕÕÍøÉÏ˵µÄÆôÓÃSQLServer ä¯ÀÀÆ÷·þÎñÁË£¬»¹ÊÇͬÑùµÄÎÊÌ⣡£¡£¡£¡
ÔõôûÈ˰¡£¿Ç§ÍòÒª°ï°ïæ°¡£¡£¡£¡¶¥Ò»ÏÂ

ÅäÖùÜÀí¹¤¾ß-¡·SQL Server ÍâΧӦÓÃÅäÖÃÆ÷-¡··þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷-¡·Database Engine-¡·Ô¶³ÌÁ¬½Ó-¡·Ñ¡ÖС®±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó¡¯-¡·ÖØÆô·þÎñ¡£ ÓÐ×ö¹ýÉÏÊöµÄÅäÖÃÂð£¿

Did you enable remote connection for TCP and Named Pipe?

Look under SQL Server 2005 Surface Area Configuration for Services and Connections -> Instance Name -> Database Engine -> Remote Connection

ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊǰ´ÕÕÕâ¸öÉÏÃæ×öµÄhttp://wanjianfei.javaeye.com/blog/439658£¬ÇÒ·À»ðǽҲ¹ØÁË£¬ÐéÄâ·þÎñÆ÷ÓõÄÊÇ»¨Éú¿Ç;Ôõô°ì°¡£¿ºÜÓôÃÆ


ÒýÓÃ
ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊǰ´ÕÕÕâ¸öÉÏÃæ×öµÄhttp://wanjianfei.javaeye.com/blog/439658£¬ÇÒ·À»ðǽҲ¹ØÁË£¬ÐéÄâ·þÎñÆ÷ÓõÄÊÇ»¨Éú¿Ç;Ôõô°ì°¡£¿ºÜÓôÃÆ


Firstly, are you sure your SQL Server is running on the port you expect it to. Check out this post http://topic.csdn.net/u/20100520/16/6cf306aa-e2d5-423b-94fb-2a6f4694d908.html

ÒѾ­¿ªÁËÕâ¸ö1433¶Ë¿Ú£¬ÔËÐÐ->cmd->netstat –ano ÖÐÏÔʾÓÐTCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 440

ÎÒµÄÁ¬½Ó×Ö·û


Ïà¹ØÎÊ´ð£º

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

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

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ