http://www.hackerschool.org/HS_Boards/zboard.php?id=QNA_programming&no=1966 [º¹»ç]
¾È³çÇϼ¼¿ä.. asp¸¦ óÀ½À¸·Î °øºÎÇÏ°í ÀÖ½À´Ï´Ù.
ȸ¿ø°¡ÀÔ ÆäÀÌÁö¿¡¼ ÀúÀå ¹öÆ°À» Ŭ¸¯ÇßÀ» °æ¿ì
DB Ä¿³Ø¼Ç ºÎºÐ(db_conn.asp)¿¡¼ ¿À·ù°¡ ¹ß»ýÇÏ¿© ¿©Âã´Ï´Ù.
db_conn.asp ¼Ò½ºÀÇ DB¿¬°á ºÎºÐ¿¡ ¼ÂÆÃÇØÁà¾ß ÇÏ´Â °ªµéÀÌ À߸øµÈ °ÍÀΰ¡¿ä?
¾Æ·¡ ¼Ò½º¿¡¼ strConnÀÇ °¢ Ç׸ñµéÀÌ ¹«¾ó ¸»Çϴ°ÇÁö.. ¾î¶² °ÍÀ» ÀÔ·ÂÇØ¾ß Çϴ°ÇÁö.. ÀÔ·ÂÇØ¾ß ÇÒ °ªÀ» ¼¹ö»ó¿¡¼ ¾îµð¼ È®ÀÎÇÒ ¼ö Àִ°ÇÁö ºÎŹµå¸®°Ú½À´Ï´Ù.
¾Æ·¡´Â ¿À·ù³»¿ëºÎÅÍ ¼¹öȯ°æ, ±×¸®°í ¹®Á¦°¡ µÇ´Â ASP ¼Ò½º ÀÔ´Ï´Ù.
<¿À·ù³»¿ë>
-------------------------------------------------------------------------------
¿À·ù Çü½Ä:
Microsoft OLE DB Provider for SQL Server (0x80004005)
'sa' »ç¿ëÀÚ°¡ ·Î±×ÀÎÇÏÁö ¸øÇß½À´Ï´Ù. ÀÌÀ¯: Æ®·¯½ºÆ®µÈ SQL Server ¿¬°á°ú °ü·ÃµÇÁö ¾Ê¾Ò½À´Ï´Ù.
-------------------------------------------------------------------------------
<¼¹öȯ°æ>
-------------------------------------------------------------------------------
1. OS : Win2000 server(IIS 5.0)
2. DBMS : MS SQL ¼¹ö(window °èÁ¤ ÀÎÁõ)
-------------------------------------------------------------------------------
<db_conn.asp ÀϺÎ>
-------------------------------------------------------------------------------
<»ý·«>
Dim Conn, strConn
Set Conn = Server.CreateObject("ADODB.Connection")
strConn = "Provider=sqloledb; Data Source=localhost; Initial Catalog =skey; user id=sa; "
'strConn = "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;"
'strConn = strConn & "User ID=sa;Initial Catalog=DSDB;Data Source=127.0.0.1"
Conn.ConnectionString = strConn
Conn.Open strConn
<»ý·«>
------------------------------------------------------------------------------- |
Hit : 2931 Date : 2009/04/05 05:45
|