Hi-FiÀu½èI.Tºô¡GSQL Server ?ˆï¿½ï¿???forum_id=43-°Q½×°Ï
±z©|¥¼µn¤J...
±b¸¹:
±K½X:

§Ñ°O±K½X¡@
°Q½×°Ï>>SQL Server ?ˆï¿½ï¿???forum_id=43<<

 
 
µo°_¤H¡G
admin
¤¤¯Å·|­û
±i¶K®É¶¡¡G2004//1/16-14:23:06
   ÀËÁ|

¡@¥DÃD¡GHOW TO¡G³]©w SQL Server ¥HÀx¦s ASP.NET ¤u§@¶¥¬qª¬ºA

³]©w SQL Server ªº ASP.NET SQL Server ¤u§@¶¥¬qª¬ºA
¤U¦C¨BÆJ±N§i¶D±z¡A¦p¦ó°õ¦æ InstallSqlState.sql ¤Î UninstallSqlState.sql «ü¥O½XÀɮסA¥H³]©w SQL Server ¼Ò¦¡¤u§@¶¥¬qª¬ºAºÞ²z¡C 1. ¦b [SQL Query Analyzer] ¤¤¡A«ö¤@¤U [ÀÉ®×] ¥\¯àªí¤Wªº [¶}±Ò]¡C
2. ¦b [¶}±Ò¬d¸ßÀÉ®×] ¹ï¸Ü¤è¶ô¤¤¡AÂsÄý¦Ü InstallSqlState.sql «ü¥O½XÀɮסAµM«á«ö¤@¤U [¶}±Ò]¡C¨Ì¹w³]¡AInstallSqlState.sql ·|¦ì©ó¤U¦C¨ä¤¤¤@­Ó¸ê®Æ§¨¤¤¡G
system drive\WINNT\Microsoft.NET\Framework\version\

system drive\Windows\Microsoft.NET\Framework\version\
3. ¦b SQL Query Analyzer ¤¤¶}±Ò InstallSqlState.sql ¤§«á¡A«ö¤@¤U [¬d¸ß] ¥\¯àªí¤Wªº [°õ¦æ]¡A¥H°õ¦æ«ü¥O½X¡C
4. ¦b±z°õ¦æ UninstallSqlState.sql «ü¥O½XÀɮסA¥H¸Ñ°£¦w¸Ë SQL Server ¼Ò¦¡¤u§@¶¥¬qª¬ºAºÞ²z³]©w¤§«e¡A¥²¶·¥ý°±¤î w3svc ³B²zµ{§Ç¡C¦pªG­n°õ¦æ³o¶µ¾Þ§@¡A½Ð¨Ì·Ó¤U¦C¨BÆJ°õ¦æ¡G a. ¦b Windows [¶}©l] ¥\¯àªí¤W¡A«ö¤@¤U [°õ¦æ]¡A¿é¤J cmd¡A¦A«ö [½T©w]¡A¥H¶}±Ò©R¥O´£¥Ü¦r¤¸¡C
b. ¦b©R¥O´£¥Ü¦r¤¸¤¤¡A¿é¤J net stop w3svc¡C±z·|¦¬¨ì w3svc ³B²zµ{§Ç¤w¸g°±¤îªº½T»{°T®§¡C

5. ¦b [SQL Query Analyzer] ¤¤¡A«ö¤@¤U [ÀÉ®×] ¥\¯àªí¤Wªº [¶}±Ò]¡C
6. ¦b [¶}±Ò¬d¸ßÀÉ®×] ¹ï¸Ü¤è¶ô¤¤¡AÂsÄý¦Ü UninstallSqlState.sql «ü¥O½XÀɮסAµM«á«ö¤@¤U [¶}±Ò]¡C¨Ì¹w³]¡AUninstallSqlState.sql ·|¦ì©ó¤U¦C¨ä¤¤¤@­Ó¸ê®Æ§¨¤¤¡G
system drive\WINNT\Microsoft.NET\Framework\version\

system drive\Windows\Microsoft.NET\Framework\version\
7. ¦b SQL Query Analyzer ¤¤¶}±Ò UninstallSqlState.sql ¤§«á¡A«ö¤@¤U [¬d¸ß] ¥\¯àªí¤Wªº [°õ¦æ]¡A¥H°õ¦æ«ü¥O½X¡C
8. ¸Ñ°£¦w¸Ë SQL Server ¼Ò¦¡¤u§@¶¥¬qª¬ºAºÞ²z³]©w¤§«á¡A±z¥²¶·­«·s±Ò°Ê w3svc ªA°È¡C¦pªG­n­«·s±Ò°Ê w3svc ³B²zµ{§Ç¡A½Ð¦b©R¥O´£¥Ü¦r¤¸¤¤¿é¤J net start w3svc¡C
¦^¨ì­¶­º
­×§ïÀ³¥Îµ{¦¡ªº Web.config ÀÉ®×
¦pªG­n¹ê§@ ASP.NET SQL Server ¼Ò¦¡¤u§@¶¥¬qª¬ºAºÞ²z¡A±z¥²¶·¨Ì·Ó¤U¦C«ü¥Ü¡A­×§ïÀ³¥Îµ{¦¡¤¤ Web.config Àɮתº ¶µ¥Ø¡G 1. ±N ¶µ¥Øªº mode Äݩʳ]©w¬° SQLServer¡A¥H«ü¥X¤u§@¶¥¬qª¬ºA¬OÀx¦s¦b SQL Server ¤¤¡C
2. ³]©w sqlConnectionString ÄݩʡA¥H«ü©w SQL Server ªº³s±µ¦r¦ê¡C¨Ò¦p¡GsqlConnectionString="data source=MySQLServer;user id=;password="


ª`·N ¨Ï¥ÎªÌ ¥²¶·¾Ö¦³Åv­­¡A¤~¯à¦b¸ê®Æ®w¤W°õ¦æ³o¶µ¾Þ§@¡C

­×§ïªº ¶µ¥Ø·|Åã¥Ü¦p¤U¡G mode="SQLServer"
sqlConnectionString="data source=127.0.0.1;user id=;password="
cookieless="false"
timeout="20"
/>

ª`·N ·í±z«ü©w ¶µ¥Ø¤Î¬ÛÃöªºÄݩʭȮɡA½Ð½T»{±z¨Ï¥Î¥¿½Tªº¤j¤p¼g¡C¦¹µ{¦¡½X°Ï¤À¤j¤p¼g¡C

ñ¦W
-===== ¸ô¬O¤H¨«¥X¨Óªº=====-

 



 

Hi-FiÀu½èI.Tºô”¯¸¤º©Ò¦³¤å³¹¡B¹Ï¤ù°£¯S§O¥[µù¥~§¡ÄÝ¥»¯¸©Ò¦³,¦p¦³¥ô¦ó°ÝÃD½Ð¨Ó«H§iª¾
½Ð¤ä«ù¨¥½×¦Û¥Ñ¡A°Q½×°Ï©Òµoªí¤§¨¥½×¤£¥Nªí¥»¯¸¥ß³õ
Hi-FiÀu½èI.Tºô”ª©Åv©Ò¦³2004©
---³Ì¨ÎÅã¥Ü®ÄªG1024*768---