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

C#Á¬½ÓSQLÊý¾Ý¿âÁ¬²»ÉÏ£¿

SqlConnection conn = new SqlConnection("server = (local)\\sqlexpress;integrated security = SSPI;database = Northwind");
            conn.Open();
Á¬½Ó²»ÉÏ£¬Ìáʾ£º

Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'hp-326-PC\hp-326'.
³õѧ£¬ÇëÖ¸µã
Óû§ÃûºÍÃÜÂëûÓÐ

SqlConnection conn = new SqlConnection(
"Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;");

ÕÒµ½loginµÄusertºÍpsssword,²¹Éϼ´¿É¡£

requested by the login. The login failed
ÒªÇóµÇ½,µ«µÇ½ʧ°Ü.
NorthwindÒ»°ãÊÇûÓÐÓÃÃÜÂëµÄ


        string conn = System.Configuration.ConfigurationManager.ConnectionStrings["ÄãµÄÁ¬½Ó×Ö·û´®"].ToString();


http://blog.csdn.net/clzdl/archive/2009/07/10/4338284.aspx

SqlConnection conn = new SqlConnection("server = (local)\\sqlexpress;database = Northwind" uid=sa; pwd=123);

uid ÊǵǽÃû
pwd ÊÇÃÜÂë

ÊÔһϿÉÒÔ²»


»òÕßÓÃsql×Ô¼º´øµÄĬÈϵÄÕË»§Á¬½ÓÒ²¿ÉÒԵģ¡

uid
pwd
¿ÉÄÜÄãÁ¬½ÓÊý¾Ý¿âÊÇûÓÐдÃÜÂëºÍÓû§¡£

ÄãÓÃvsÀïÃæµÄServer ExplorerÁ¬½ÓÒ»ÏÂÊý¾Ý¿âµÄ£¬Èç¹ûÄÜÁ¬ÉÏ£¬°ÑÁ¬½Ó×Ö·û´®¿½Ò»ÏµľͿÉÒÔÁË

¿ÉÄÜÄãÁ¬½ÓÊý¾Ý¿âÊÇûÓÐдÃÜÂëºÍÓû§¡£

»òÕßÊÇsqlexpress·þÎñδÆô¶¯

ÓûìºÏģʽ ×Ö·û´®ÊÇ


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

sql¸üÐÂ×ֶη¾¶

Èç¹ûÓÃsqlÓï¾ä¸ü¸Älj×ֶεÄ·¾¶£¬ÈçÏ£º
lj
7/200781616183095962.jar
8/f_200812111413292.jar
8/f_200812111413291.jar

µÃµ½µÄ½á¹ûÈçÏ£º
lj
1/7/200781616183095962.jar
1/8/f_20081 ......

c# µ¼³ö´¿Õæip¿âµ½sqlserver

ÎÒÏë°Ñ´¿Õæip¿âµ¼³öµ½sqlserver£¬ÎÒÓÃϱߵĽéÉÜ·½·¨£¬£¨ËüÖ÷ÒªÊǵ¥¸öIP²éѯµÄ£©
http://www.cnblogs.com/njnudt/archive/2007/04/08/704524.html
¸ÄÁËÒ»ÏÂÄܹ»µÃµ½ËùÓеĹú¼ÒºÍµØÇøÐÅÏ¢£¬µ«ÊDz»Äܵõ½ipµØÖ·µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ