! kƒà ï ï ugv º h t ï s p w Connection g o Ç hâe Connection g à t ï u k ï o Ãh Ý ƒà mv tj ï s mv t SQL Server Access ïë mv t Exce ÌÞ 3-1 mv t SQL Server t SQL Server SQL Server.NET Framework ï ± SqlConnection y m Ú È á yá  n u SqlConnection ysž h  n Âe SqlConnection g SqlConnection() p }gv  n Ç Â n  nâe SqlConnection gk œ gv º ConnectionString Database DataSource à Ç mu "" s ConnectionTimeout àºç 15 Ø p  n Âe ƒà kâe SqlConnection g à œ ConnectionString Æœ mu m d±zç ' Âe á SqlConnection g Dim myconnection As New SqlConnection() ' Æœ SQL Server ïë mu myconnection.connectionstring = _ "Persist Security Info=False;Integrated Security=SSPI; " & _ "Database=Northwind;Server=(local);Connect Timeout=30" Try ' myconnection.open() ' ï n kp 3-2
mv t ï Catch ex As Exception MessageBox.Show(" «t ï ") Finally ' myconnection.close() End Try SqlConnection(ByVal connectionstring As String) pâ nç á muwî m d±zç h ' À ámu m mu Dim myconnectstring As String = _ "Persist Security Info=False;Integrated Security=SSPI; " & _ "Database=Northwind;Server=(local);Connect Timeout=30" ' mu Âe á SqlConnection g Dim myconnection As New SqlConnection(myConnectString) Try ' myconnection.open() ' ï n kp Catch ex As Exception MessageBox.Show(" «t ï ") Finally ' myconnection.close() End Try kpú é SqlConnection gk à SqlConnection g Close Dispose «Close «ãp ð e à kh ± m h n lp Close p «3-3
! k y Finalize «Connection DataReader g v Managed g Close Dispose «k o y p Unmanaged m y pgv Unmanaged Ú Finalize «Æk yœ 3-2 SqlConnection g mu º Âe SqlConnection gð Ç m u mu } t á ï ð j Ú tå á ïëw å á ïë ð mh n mu já œ d Î m Keyword «ónm d m œà o «m œà á t º "keyword1 value;keyword2 value;keyword3 value " d±ç á Ž mu "Persist Security Info=False;Integrated Security=SSPI; " & _ "Database=Northwind;Server=(local);Connect Timeout=30" mu }å m à yp s mv œ Î ˆ é ± y 3-1 h k mu œ m 3-4
Application Name mv t ï m à Úˆ n j pî m Ú ñçå á n k p m m p nj º àî.net SqlClient Data Provider p m Æœ Ú ï.mdf ë dº ïë Attach t SQL Server à ïë j AttachDBFilename Extended Properties Initial File Name Connect Timeout Connection Timeout Current Language Data Source Server Address Addr Network Address 15 mu Database m Æœ m Æœ ïë SQL Server ºp m m SQL Server ïë w Ç Ú ï ± w SQL Server 2000 h SqlConnection y Ãw k ð v Ô m ð ww k k á «p m œ SQL Server Ž Ú SQL Server uá j v~ m Ú t SQL Server 2000 Server m œo (local) m Ú t MSDE 2000 s p MSDE 2000 uá j Î NetSDK º Server m œo (local)\netsdk 3-5
! Encrypt Initial Catalog Database m à m p m œî true s w m á º SQL Server k w False p ï SSL Encryption p m œàî true false yes no Integrated Security Trusted_Connection Network Library Net False Dbmssocn Æœ ÃÚ ïëj k à ChangeDatabase «dº ïë m p m œî false m u Æœ ± y User ID Password m p m œî True º d dº Windows u ez g Windows p m œàî true false yes no sspi ƒà  sspi ï true Òi Æœ SQL Server n ë SQL Server 2000 sž h h në dbnmpntw j j Named Pipe w uá j s m w œî Listen á º œî dbmsrpcn lý œ jnmh p në ãkç SQL Server 2000 j uá s Ú l á RPC 3-6
mv t ï m à dbmsadsn Apple Talk t Apple dbmsgnet VIA VIA ÚÇÚ i ï j áw ìì m á Network Library Net Dbmssocn þ wî lá Internet Information Services nw lá u SQL Server ïëw VIA Ç áy wþ p Windows NT Server Advanced Server Windows 2000 Server Advanced Server Data Center w SQL Server VIA në dbmsipcn h h k Windows 98 Windows 2000 Professional Œ t m SQL Server 2000 ð p ï h œ kp pï ïë dbmsspxn IPX/SPX p në SQL Server NWLink IPX/SPX œ u dbmssocn TCP/IP p në Windows wî TCP/IP œ IPC «o SQL Server k pw Œ p Microsoft SQL Server 2000 m ~ TCP/IP në á WAN t á w ð p œ ï 3-7
! m à p y ˆs në {º TCP/IP t SQL Server 2000 ï ÇÎ Microsoft SQL Server 2000 m ~ TCP/IP w Dbmssocn Î në Ò DLL m k Ú Œ m pæœ w m "." "(local)" h SQL Server uá Á Packet Size 8192 Network Library Net Password Pwd Persist Security Info false User ID Workstation ID j v v m SQL Server SQL Server uá p m Æœ SQL Server mh ƒà  SQL Server SQL Server u á Î p ÿ mh  Integrated Security Trusted_Connection m m p m œî false no Â ð º ð mh Ò m w g k p m œàî true false yes no m SQL Server SQL Server uá p m Æœ SQL Server j mh ƒà  SQL Server SQL Server u á Î p ÿ mh  Integrated Security Trusted_Connection m t SQL Server wþj 3-1 3-8
Æœ muð ª h mv t ï mu ónç m œà o «m œà á t º m œà } º p œà } m œàið } m º p œà } m œàç Ò k m œàç m œàið}p m º } œà m p k œà ð o á ØÚkmuà }º à d º œà } àh àºã gvº à d z }k Ç s mu à String Literal m œà d ù.net Framework 1.1 ð œà á à ám Ç m {º k mu s Ú m Data Source= my'server Data Source= my"server m Úk m œà } = º kºþ á m d musž mî key=word s œà Î value "key==word=value" m Èá mk mu l p à p œ m m œàç à 'yes' 'true' 'no' 'false' à dîmu m SQL Server.NET Framework ï ± t œ SQL Server p ODBC kp t SQL Server ð á ODBC ï j DSN 3-9