¹ØÓÚSQLºÍASPÁ¬½ÓÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
¸÷λ´óϺÏÂÎçºÃ¹þ£¬ÎÒÓÖÀ´ÂÛ̳Çë½Ì´ó¼ÒÁË¡£ÎÒÃǹ«Ë¾×î½üÒª¸ü»»·þÎñÆ÷£¬Òª°ÑÀÏ·þÎñÆ÷ÉϵÄÒ»¸öWebÕ¾µãÒÆµ½Ð·þÎñÆ÷ÉÏ¡£Ð¡µÜÏȰÑÀÏ»úÆ÷ÉϵÄasp³ÌÐò¿½µ½Ð·þÎñÆ÷ÉÏ£¬ÓÃIIS´´½¨ÁËWEBÕ¾µã£¬ÓÖÓÃSQL»¹ÔÁ˱¸·ÝÊý¾Ý¿â£¨Îļþ¼ÐÀïÃæÃ»µÃ.mdfÎļþ£©ÏÖÔھͲ½¨SQLºÍASPµÄÁ¬½ÓÁË£¬ÎÒÔÚÍøÉÏ¿´µ½¼¸ÖÖ·½·¨£¬µ«ÊǾ¹ýʵ¼ù¶¼ÎÞ·¨³É¹¦¡£ÎÊÌâ¶¼ÊÇÔÚÃüÁîÁ¬½ÓÊý¾Ý¿âʱºò±¨´í£¬ÌáʾÔÚµÚ1ÐÐ<´¦ÓÐÓï·¨´íÎó¡£Ð¡µÜÔÚÕâÀïÇë¸÷λ´óϺÔÙÏêϸ½éÉÜÏÂSQLºÍASPµÄÁ¬½Ó·½·¨£¬Èç¹ûÓÐÍêÕû´úÂë¸üºÃ¡£¶àлÁË~
Â¥ÉϺνⰡ~~ Set cnn = Server.CreateObject("ADODB.Connection") strcnn = "Driver={SQL Server};Server=.;Database=pubs;UID=sa;PWD=;" cnn.Open strcnn Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT * from Authors",strcnn ,1,1 rs.Close ÒýÓà ¸÷λ´óϺÏÂÎçºÃ¹þ£¬ÎÒÓÖÀ´ÂÛ̳Çë½Ì´ó¼ÒÁË¡£ÎÒÃǹ«Ë¾×î½üÒª¸ü»»·þÎñÆ÷£¬Òª°ÑÀÏ·þÎñÆ÷ÉϵÄÒ»¸öWebÕ¾µãÒÆµ½Ð·þÎñÆ÷ÉÏ¡£Ð¡µÜÏȰÑÀÏ»úÆ÷ÉϵÄasp³ÌÐò¿½µ½Ð·þÎñÆ÷ÉÏ£¬ÓÃIIS´´½¨ÁËWEBÕ¾µã£¬ÓÖÓÃSQL»¹ÔÁ˱¸·ÝÊý¾Ý¿â£¨Îļþ¼ÐÀïÃæÃ»µÃ.mdfÎļþ£©ÏÖÔھͲ½¨SQLºÍASPµÄÁ¬½ÓÁË£¬ÎÒÔÚÍøÉÏ¿´µ½¼¸ÖÖ·½·¨£¬µ«ÊǾ¹ýʵ¼ù¶¼ÎÞ·¨³É¹¦¡£ÎÊÌâ¶¼ÊÇÔÚÃüÁîÁ¬½ÓÊý¾Ý¿âʱºò±¨´í£¬ÌáʾÔÚµÚ1ÐÐ<´¦ÓÐÓï·¨´íÎó¡£Ð¡µÜÔÚÕâÀïÇë¸÷λ´ó¡¡ Show us your code that connects to SQL Server. ÊäÈë4Â¥Ìṩ´úÂë cnn.Open strcnn Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT * from Authors",strcn
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
Microsoft JET Database Engine '80040e07' ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£ \wwwroot\update.asp, line 20 -------------------------------------------------------------------------------- Ho ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼· ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ 2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ лл ÓÃjs·½·¨À´¿ØÖÆ »Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£ js ......
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡ ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´ ³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿ ×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹ ±©¿â©¶´Ôõô·ÀÖ¹ »¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif ÕâÖÖ©¶´Ôõôȥ± ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......