JSEMTS搜尋引擎
 

¥ÎASP³sµ²¸ê®Æ®w¦³«Ü¦hºØ¤èªk¡C¥Ñ©ó¤£¦PÃþ«¬ªº¸ê®Æ®w¡A©Ò¥H§Ú­Ì»Ý­n¥Î¦U¦Ûªº³sµ²»yªk¨Ó²£¥Í¹ï¸ê®Æ®wªº³s±µ¡C

¦b¦Û¤vªº¹q¸£¡A§Ú­Ì¥i¥H¨Ï¥ÎDSN(Data Source Name)¨Ó³s±µ¡A¤èªk¬O¦b±±¨î¥x³]©wODBC ³s½u¡A¦A¦bASP¥Î¸ÓDSN§@¶}±Ò§Y¥i¡C¦ý¦b¤@¨Ç§K¶OªÅ¶¡¡A§Ú­Ì«h¶·¥ÎDSN-lessªº¤è¦¡³s±µ¸ê®Æ®w¡A§Ú­Ì­n¦bASP¤¤¦C¥XÅX°Êµ{¦¡¦WºÙ¤Î¸ê®Æ®w¦ì¸m¡C

³q±`«ü¥X¸ê®Æ®w¦ì¸m¬O»Ý­n¨Ï¥Îµ´¹ï¸ô®|ªº¡A¦ý§Ú­Ì¨Ã¤£ª¾¹D§Ú­Ìªº¸ê®Æ§¨ªº¦ì¸m¨s³º¦b­þùØ¡A©Ò¥H§Ú­Ì·|¥ÎServer.MapPath("¸ê®Æ®w¦WºÙ")¨Ó¨ú±oµ´¹ï¸ô®|¡C

¦]À³¦UºØ¸ê®Æ®w¡A§Ú¦C¥X¥H¤U¸ê®Æ®wªº³s±µ»yªk¦p¤U¡G
µù¡G¤£¥i¤À¦æ(°£«D¨Ï¥Î & _ ³sµ²¨â¦æ¦r¦ê¤~¥i¤À¦æ)¡C¦b³oùؤÀ¦æ¬O¬°¤F¤è«K¾\Ū¡C
¡@¡@[ ] ¤ºªºªF¦è­Y³]¤F±K½X¤~»Ý­n¥Î¨ì¡A¨S³]±K½X«h¥²¶·§R°£¡C¨Ï¥Î³s½u¦r¦ê®É½Ð§R°£¡u[¡v©M¡u]¡v¡C
(¸ê®Æ¨Ó·½¡Ghttp://www.class2u.com/book/ultradev4/connection.htm)

Microsoft Access
1.Driver={Microsoft Access Driver (*.mdb)};Dbq=¸ê®Æ®w;[Uid=¨Ï¥ÎªÌ¦WºÙ;Pwd=±K½X;]
2.Provider=Microsoft.Jet.OLEDB.4.0;Data Source=¸ê®Æ®w;[User Id=¨Ï¥ÎªÌ¦WºÙ;Password=±K½X;]

Oracle
1. Driver={Microsoft ODBC for Oracle};Server=¸ê®Æ®w;[Uid=¨Ï¥ÎªÌ¦WºÙ;Pwd=±K½X;]
2. Provider=OraOLEDB.Oracle;Data Source=¸ê®Æ®w;[User Id=¨Ï¥ÎªÌ¦WºÙ;Password=±K½X;]

dBase
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=¸ê®Æ®w;

Microsoft Text Driver
1. Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=¸ê®Æ®w;Extensions=asc,csv,tab,txt;
¡@Persist Security Info=False;
2. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=¸ê®Æ®w;
¡@Extended Properties='text;FMT=Delimited'

Microsoft SQL Server
1. Driver={SQL Server};Server=¦øªA¾¹;Database=¸ê®Æ®w;
¡@[Uid=¨Ï¥ÎªÌ¦WºÙ(¹w³]±b¤á¬°sa);Pwd=±K½X;]
2. Provider=SQLOLEDB;Data Source=¦øªA¾¹;Initial Catalog=¸ê®Æ®w;
¡@[User Id=¨Ï¥ÎªÌ¦WºÙ(¹w³]±b¤á¬°sa);Password=±K½X;]

MySQL
driver={mysql};database=¸ê®Æ®w;option=16386;[uid=¨Ï¥ÎªÌ¦WºÙ;pwd=±K½X;]

Visual Foxpro
Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;
¡@SourceDB=¸ê®Æ®w;Exclusive=No;

«Ø¥ß³s½u®É¡A§Ú­Ì¥²¶·¥ý«Ø¥ß³s½u¤¸¥ó¡A¨Ã¦]À³¸Ó¸ê®Æ®wÃþ«¬¥H¤W­z³s½u¤è¦¡³s±µ¸ê®Æ®w¡C
°²³]¸ê®Æ®w¸ô®|¬°¦bºô­¶©³¤Uªº abc.mdb (Access¸ê®Æ®w)¡A¨Ï¥ÎªÌ¦WºÙ¬° abc ¡B±K½X¬° test ¡A§A¥i¥H³o¼Ë§@¡G
<%
Set objDBConn=Server.Createobject("ADODB.connection") '«Ø¥ß³s½u¤¸¥ó
objDBConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("abc.mdb") & _
";User Id=abc;Password=test;"
'¥Î³sµ²¦r¦ê¶}±ÒOLE DBªºAccess¸ê®Æ®w¡Cª`·N¡A­Y±zªº¸ê®Æ®w¨S³]¨Ï¥ÎªÌ¦WºÙ¤Î±K½X¡A«h¤£»ÝUser Id¤ÎPasswordÄÝ©Ê¡C
'¦¹®É¸ê®Æ®w¤w¸g¶}±Ò¡A§Ú­Ì¥i¥H°õ¦æSQL«ü¥O©Î¬O«Ø¥ß¸ê®Æ¶°¤¸¥ó¡A½Ð°Ñ¾\¨ä¥L¬ÛÃö¤å³¹¡C
'·í°õ¦æ§¹SQL«ü¥O©Î¨ä¥L¬ÛÃö¾Þ§@¡A§Ú­Ì¥i¥H¥s¨º¤¸¥ó¡u¦^®aºÎı¡v¤F¡C
objDBConn.Close
Set objDBConn=Nothing
'Ãö³¬¸ê®Æ®w¤¸¥ó³s±µ¡AÄÀ©ñ¨t²Î¸ê·½¡A¡u¦^®aºÎı¡v¥h
%>
SN:JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY






搜尋引擎讓我們程式搜尋結果更加完美
  • 如果您覺得該文件有幫助到您,煩請按下我
  • 如果您覺得該文件是一個一無是處的文件,也煩請按下我

  • 搜尋引擎該文件您看起來是亂碼嗎?您可以切換編碼方式試試看!ISO-8859-1 | latin1 | euc-kr | euc-jp | CP936 | CP950 | UTF-8 | GB2312 | BIG5 |
    搜尋引擎本文件可能涉及色情、暴力,按我申請移除該文件

    搜尋引擎網址長?按我產生分享用短址

    ©2024 JSEMTS

    https://tw.search.yahoo.com/search;_ylt=A8tUwYgkQU1YcXoAUE9r1gt.;_ylc=X1MDMjExNDcwNTAwMwRfcgMyBGZyA3lmcC10LTkwMC10dwRncHJpZAMxWU5tY2FYMVFGQ2ZvUXZGN1N0bzVBBG5fcnNsdAMwBG5fc3VnZwMwBG9yaWdpbgN0dy5zZWFyY2gueWFob28uY29tBHBvcwMwBHBxc3RyAwRwcXN0cmwDBHFzdHJsAzQ4BHF1ZXJ5AyVFNiVBRCVBMSVFNiVBRCU4QyUyMCVFNSVCMCU4OCVFNiU4MyU4NSVFNSU5QyU5OAR0X3N0bXADMTQ4MTQ1Nzk3Ng--?p=%E6%AD%A1%E6%AD%8C+%E5%B0%88%E6%83%85%E5%9C%98&fr2=sb-top-tw.search&fr=yfp-t-900-tw&rrjfid=2389865 https://tw.search.yahoo.com/search;_ylt=A8tUwYgkQU1YcXoAUE9r1gt.;_ylc=X1MDMjExNDcwNTAwMwRfcgMyBGZyA3lmcC10LTkwMC10dwRncHJpZAMxWU5tY2FYMVFGQ2ZvUXZGN1N0bzVBBG5fcnNsdAMwBG5fc3VnZwMwBG9yaWdpbgN0dy5zZWFyY2gueWFob28uY29tBHBvcwMwBHBxc3RyAwRwcXN0cmwDBHFzdHJsAzQ4BHF1ZXJ5AyVFNiVBRCVBMSVFNiVBRCU4QyUyMCVFNSVCMCU4OCVFNiU4MyU4NSVFNSU5QyU5OAR0X3N0bXADMTQ4MTQ1Nzk3Ng--?p=%E6%AD%A1%E6%AD%8C+%E5%B0%88%E6%83%85%E5%9C%98&fr2=sb-top-tw.search&fr=yfp-t-900-tw&rrjfid=1441514 https://tw.search.yahoo.com/search;_ylt=A8tUwYgkQU1YcXoAUE9r1gt.;_ylc=X1MDMjExNDcwNTAwMwRfcgMyBGZyA3lmcC10LTkwMC10dwRncHJpZAMxWU5tY2FYMVFGQ2ZvUXZGN1N0bzVBBG5fcnNsdAMwBG5fc3VnZwMwBG9yaWdpbgN0dy5zZWFyY2gueWFob28uY29tBHBvcwMwBHBxc3RyAwRwcXN0cmwDBHFzdHJsAzQ4BHF1ZXJ5AyVFNiVBRCVBMSVFNiVBRCU4QyUyMCVFNSVCMCU4OCVFNiU4MyU4NSVFNSU5QyU5OAR0X3N0bXADMTQ4MTQ1Nzk3Ng--?p=%E6%AD%A1%E6%AD%8C+%E5%B0%88%E6%83%85%E5%9C%98&fr2=sb-top-tw.search&fr=yfp-t-900-tw&rrjfid=8479275 https://tw.search.yahoo.com/search;_ylt=A8tUwYgkQU1YcXoAUE9r1gt.;_ylc=X1MDMjExNDcwNTAwMwRfcgMyBGZyA3lmcC10LTkwMC10dwRncHJpZAMxWU5tY2FYMVFGQ2ZvUXZGN1N0bzVBBG5fcnNsdAMwBG5fc3VnZwMwBG9yaWdpbgN0dy5zZWFyY2gueWFob28uY29tBHBvcwMwBHBxc3RyAwRwcXN0cmwDBHFzdHJsAzQ4BHF1ZXJ5AyVFNiVBRCVBMSVFNiVBRCU4QyUyMCVFNSVCMCU4OCVFNiU4MyU4NSVFNSU5QyU5OAR0X3N0bXADMTQ4MTQ1Nzk3Ng--?p=%E6%AD%A1%E6%AD%8C+%E5%B0%88%E6%83%85%E5%9C%98&fr2=sb-top-tw.search&fr=yfp-t-900-tw&rrjfid=3503146 https://tw.search.yahoo.com/search;_ylt=A8tUwZJ2QE1YaVcAUmFr1gt.;_ylc=X1MDMjExNDcwNTAwMwRfcgMyBGZyA3lmcC10LTkwMC1zLXR3BGdwcmlkAwRuX3JzbHQDMARuX3N1Z2cDMARvcmlnaW4DdHcuc2VhcmNoLnlhaG9vLmNvbQRwb3MDMARwcXN0cgMEcHFzdHJsAwRxc3RybAM4NARxdWVyeQMlRTglQjYlODUlRTUlOEYlQUYlRTYlODQlOUIlRTclOUElODQlRTUlQUYlQjYlRTUlQUYlQjYlMjAlRTglODMlQTElRTUlQUUlODklRTUlQTglOUMEdF9zdG1wAzE0ODE0NTc3OTM-?p=%E8%B6%85%E5%8F%AF%E6%84%9B%E7%9A%84%E5%AF%B6%E5%AF%B6+%E8%83%A1%E5%AE%89%E5%A8%9C&fr2=sb-top-tw.search&fr=yfp-t-900-s-tw&rrjfid=2068684 https://tw.search.yahoo.com/search;_ylt=A8tUwZJ2QE1YaVcAUmFr1gt.;_ylc=X1MDMjExNDcwNTAwMwRfcgMyBGZyA3lmcC10LTkwMC1zLXR3BGdwcmlkAwRuX3JzbHQDMARuX3N1Z2cDMARvcmlnaW4DdHcuc2VhcmNoLnlhaG9vLmNvbQRwb3MDMARwcXN0cgMEcHFzdHJsAwRxc3RybAM4NARxdWVyeQMlRTglQjYlODUlRTUlOEYlQUYlRTYlODQlOUIlRTclOUElODQlRTUlQUYlQjYlRTUlQUYlQjYlMjAlRTglODMlQTElRTUlQUUlODklRTUlQTglOUMEdF9zdG1wAzE0ODE0NTc3OTM-?p=%E8%B6%85%E5%8F%AF%E6%84%9B%E7%9A%84%E5%AF%B6%E5%AF%B6+%E8%83%A1%E5%AE%89%E5%A8%9C&fr2=sb-top-tw.search&fr=yfp-t-900-s-tw&rrjfid=1953667