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

¹ØÓÚ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


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

asp³õѧÎÊÌâ - Web ¿ª·¢ / ASP

Microsoft JET Database Engine '80040e07' 
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£ 
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......

asp.net Ò³ÃæÏÞʱÌá½» ÈçºÎʵÏÖ - .NET¼¼Êõ / ASP.NET

1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£

js ......

aspÍøÕ¾°²È«ÎÊÌâ - Web ¿ª·¢ / ASP

¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡
ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º
sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´
³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿
×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹
±©¿â©¶´Ôõô·ÀÖ¹
»¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif
ÕâÖÖ©¶´Ôõôȥ± ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ