Discussion:
[求助]將asp.net站台的數據庫由MS SQL轉換為ACCESS
(时间太久无法回复)
Tony
2006-09-22 12:26:51 UTC
Permalink
œÐ±ÐŠUŠì:

¥Ø«e§Ú€wžg°µŠn€@­Óasp.net¯žÂI,ŠýŒÆŸÚ®w¬°MS SQL,²{Šb·Q§âŒÆŸÚ®w§ïŠšACCESS.
1.§Ú€wžgŠ³­×§ï³s±µ»y¥y
connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XX.mdb"
2.€wžgŠ³±NSql€€ªºTable¶×¥XŠÜACCESS.
ŠýSQL€€ªºView­n«ç€\¶×¥XŠÜACCESSªº¬džß(°£€F€â°ÊŠbACCESS€€«Ø¥ß¥~).Šp
vw_aspnet_Profilesµ¥.
¥t¥~.³oŒËÂàŽ«ŠZ.¯žÂIªº¥Î€áºÞ²z€Î¥Ø¿ýÅv­­RolerºÞ²z¥i¥H¥¿±`¹B§@¶Ü.

ÁÂÁÂ!
璉璉
2006-09-23 03:43:05 UTC
Permalink
Access ÂàŠš SQL Server €ñžûšS°ÝÃD¡C
SQL Server ¥\¯à€ñžûŠh¡A­nÂàŠš Access ¥i¯à·|Š³ÂI°ÝÃD¡A¯S§O¬O View €Î¹wÀxµ{§Çªº»yªk¡AAccess €äŽ© VBA ¡ASQL Server €£€äŽ©¡A·|Š³«ÜŠh­nœÕŸã¡C
©ó news:OtfE5Jk3GHA.5024%40TK2MSFTNGP02.phx.gbl µoªí
1.§Ú€wžgŠ³­×§ï³s±µ»y¥y
connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XX.mdb"
2.€wžgŠ³±NSql€€ªºTable¶×¥XŠÜACCESS.
ŠýSQL€€ªºView­n«ç€\¶×¥XŠÜACCESSªº¬džß(°£€F€â°ÊŠbACCESS€€«Ø¥ß¥~).Šp
vw_aspnet_Profilesµ¥.
ÁÂÁÂ!
--
­·¬ê¬ì§ÞÅçÃÒŠ³­­€œ¥q ASP.NET Web News Reader 0.2.3 UTF-8 Beta
ºô¯žŠa¹Ï http://tlcheng.twbbs.org/wwwmap.htm
¬y°ìšŸ¬x/°Ï°ì€ôžê·œ/®}ª@ºô/ªŽºÀ¹Ï/»y­µ³q°T €å³¹»Pµ{Š¡
Basic/Fortran/Windows API/.Net/»²§U»¡©úÀÉ ­ì©lœX¡B€å³¹»P°Qœ×
·L³nµ{Š¡³]­p·s°Qœ×°Ï MSDN §Þ³Nœ×ŸÂ¡Aºô€ÍŠ^ÂЫá§Y®É²°T¡B¹q€l¶l¥ó³qªŸ¡G
http://forums.microsoft.com/msdn-cht/default.aspx?siteid=14
--
ASPNET News Reader http://tlcheng.twbbs.org/News/Reader.aspx
RSS 2.0 http://tlcheng.twbbs.org/News/rss2.aspx?Action=List&Newsgroup=microsoft.public.tw.dotnet.framework.aspnet
Loading...