ISA·À»ðǽ¿Í»§¶ËºÍSQLSERVER¿Í»§¶ËµÄÎÊÌâ
ÓÐÍâÀ´³ÌÐò°²×°»ùÓÚ.NET FRAMEWORK 3.5µÄÓ¦ÓóÌÐòÔÚÄÚÍøµÄPCÉÏ£¬ÐèҪͨ¹ýISA·À»ðǽ¿Í»§¶Ë¾¹ý·þÎñÆ÷ÉϵÄISA2006 SP1·ÃÎÊÍâÍøµÄSQLSERVER2005Êý¾Ý¿â¡£
°´ÕÕÒÔÍù¾Ñ飬ÐèÒªÅäÖÃÒ»ÌõSQLSERVER2005·þÎñÆ÷ËùÔÚµÄIPµØÖ·µÄ³öÕ¾¹æÔò£¬²¢ÇÒ²¢²»ÐèÒªÉèÖÃÒ»Ìõ»ùÓÚÓòÃûµÄ¹æÔò¡£
¸ÃÓ¦ÓóÌÐòͨ¹ýÓòÃû·ÃÎÊÄ¿±êÊý¾Ý¿âÒ»ÇÐÕý³£¡£
µ«ÎÒÔÚͬһ̨»úÆ÷ÉÏÓÃSQLSERVER 2005 MANAGEMENT STUDIOͬÑùÓÃÓòÃû·ÃÎÊÄ¿±êÊý¾Ý¿âÔòʧ°ÜÁË£º³¬Ê±Ê±¼äÒѵ½¡£ÔÚ²Ù×÷Íê³É֮ǰ³¬Ê±Ê±¼äÒѹý»ò·þÎñÆ÷δÏìÓ¦¡£ÓÚÊÇÎÒÓÃIPµØÖ··ÃÎÊÄ¿±êÊý¾Ý¿â£¬Ôò³É¹¦ÁË¡£
²é¿´ISA·þÎñÆ÷µÄÈÕÖ¾£¬¶àÁ˼¸Ìõ¼Ç¼£¬µäÐ͵ÄÒ»Ìõ¾ÍÊÇ0x80074e21 FWX_E_ABORTIVE_SHUTDOWN¡£
ΪÁËÕÒµ½ÔÒòÎÒ¿ªÊ¼ÓÃVS2008×Ô¼ºÐ´³ÌÐò²âÊÔ£º
sqlConn = new SqlConnection(@"Data Source=IPµØÖ·;Initial Catalog=***;User ID=***;Password=***");
³É¹¦!
sqlConn = new SqlConnection(@"Data Source=ÓòÃû;Initial Catalog=***;User ID=***;Password=***");
»¹ÊÇʧ°Ü!
Îҷdz£À§»ó£¬ÎªÊ²Ã´ÍâÀ´µÄ³ÌÐòÓÃÓòÃû·ÃÎÊÄܹ»³É¹¦ÄØ¡£
ÓÚÊÇ´ò¿ª¿ØÖÆÃæ°åÖеÄÊý¾ÝÔ´ (ODBC)£¬½¨Á¢Ò»¸öSQLSERVERµÄÁ¬½Ó£¬Õâ¸öʱºò·¢¾õÓÃIPµØÖ·Ò²²»Äܳɹ¦£¬Ææ¹ÖÖп´ÁËÏ¿ͻ§¶ËÅäÖÃÈ¥µôÁ˶¯Ì¬¾ö¶¨¶Ë¿Ú£¬Ö¸¶¨µÄ¶Ë¿ÚΪ1433£¬ÓÚÊÇÓÃIPÁ¬½Ó£¬³É¹¦ÁË¡£½Ó×ÅÓÃÓòÃû²âÊÔÒ²³É¹¦ÁË¡£ÁªÏëµ½ÔÚÕû¸ö²âÊÔ¹ý³ÉÖÐѯÎʹýÆäËûÈËÓÃPB×öµÄ³ÌÐòÊÇÄܳɹ¦·ÃÎÊÔ¶³ÌÊý¾Ý¿âµÄ£¬ÓÚÊÇ»ÐÈ»´óÎò£¬³É¹¦Óë²»³É¹¦ÔÒòÔÚÓëSQLSERVERµÄÇý¶¯ÉÏÃ棬³É¹¦µÄ¶¼ÊÇʹÓÃSQLOLEDBµÄÇý¶¯µÄ¡£
ÓÚÊÇÔÚC#ÖÐдµ½£º
OleDbConnection cnn = null;
¡¡string cnnstr="Provider=SQLOLEDB.1;Initial Catalog=***;Data Source=ÓòÃû,1433;User ID=***; Password=***";
cnn = new
Ïà¹ØÎĵµ£º
Oracle±Ê¼Ç
l ¹ØÓÚTRUNCº¯Êý
SELECT
RELATED_ID ,
DOC_ID ,
CAT_ID ,
CAT_CODE ,
RELEASE_DATE ,
&n ......
ÓÉÓÚÒÔÇ°¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1); //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
Object o = rs1.getObject(1);
&nbs ......
ÎÒÔÚ°ÑoracleÊý¾Ýµ¼ÈësqlserverÖÐʱ£¬·¢ÏÖÔÚoracleÖÐ×ֶζ¨ÒåΪΨһË÷Òýʱ£¬²»Í¬¼Ç¼µÄ´Ë×Ö¶ÎÈç¹ûΪ¿Õ²»±»ÈÏΪÊÇÖظ´µÄ£¬µ«ÔÚsqlserverÖÐÈç¹û´Ë×Ö¶ÎΪΨһË÷Òý×ֶΣ¬²»ÔÊÐíÓÐ2¸öÒÔÉϵĿÕÖµ¡£ÓôÃÆ¡£ËùÒÔÖ»ºÃ½«sqlserverÖеÄΨһË÷Òý×Ö¶ÎÊÖ¹¤ÐÞ¸ÄΪ¼¸¸ö·Ç¿ÕµÄÖµ£¬µ«ÕâÑù³ÌÐò¿Ï¶¨Òª½øÐÐÐÞ¸ÄÁË¡£ÐèÒªÔÚ³ÌÐòÖÐΪ´Ë×Ö¶ÎÉèÖò»Öظ´ ......
ÈçºÎ²é¿´SQL SERVERÊý¾Ý¿âµ±Ç°Á¬½ÓÊý
1.ͨ¹ý¹ÜÀí¹¤¾ß
¿ªÊ¼->¹ÜÀí¹¤¾ß->ÐÔÄÜ£¨»òÕßÊÇÔËÐÐÀïÃæÊäÈë mmc£©È»ºóͨ¹ýÌí¼Ó¼ÆÊýÆ÷Ìí¼Ó SQL µÄ³£ÓÃͳ¼Æ È»ºóÔÚÏÂÃæÁгöµÄÏîÄ¿ÀïÃæÑ¡ÔñÓû§Á¬½Ó¾Í¿ÉÒÔʱʱ²éѯµ½Êý¾Ý¿âµÄÁ¬½ÓÊýÁË¡£²»¹ý´Ë·½·¨µÄ»°ÐèÒªÓзÃÎÊÄÇ̨¼ÆËã»úµÄȨÏÞ£¬¾ÍÊÇҪͨ¹ýWindowsÕË»§µÇ½½øÈ¥²Å¿ÉÒÔÌí¼Ó´Ë¼ÆÊ ......
SQLserver×Ö·û´®·Ö¸îº¯Êý
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËظöÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·ûº ......