HTML
Javascript
Flash Actionscript
PHP
mySQL
ASP
MS-SQL
Linux
Others
Ziwoo Board
Portfolio
About
ASP
ÀÛ¼º  2007-03-20 14:33:30   Ãßõ: 80   Á¶È¸: 3829
Á¦¸ñ  ¿¡·¯¹ß»ýÀ» ¹«½ÃÇÏ´Â On Error Resume Next
À̸§(ID)  Áö¿ì (ziwoo)
<%
'On Error Resume Next¸¦ »ç¿ëÇÏ¿© ¿¡·¯Ã³¸®¸¦ °¡´ÉÇÏ°Ô ÇÑ´Ù.
On Error Resume Next
Dim Dbconn
Set DbConn = Server.CreateObject("ADODB.Connection")
DbConn.Provider = "SQLOLEDB"
DbConn.ConnectionString = "SERVER=(¼­¹ö¸í); Database=(DB¸í); UID=(ID); PWD=(ºñºô¹øÈ£)"
DbConn.Open

'¿¡·¯°¡ ³ª¸é Secondry DB·Î ¿¬°áÀ» ½ÃµµÇÑ´Ù.
If Err.Number <> 0 Then
  Err.Clear
  DbConn. ConnectionString = "SERVER=(¼­¹ö¸í); Database=(DB¸í); UID=(ID); PWD=(ºñºô¹øÈ£)"
  DbConn.Open
End If

'Secondry DBÀÇ ¿¬°áµµ ½ÇÆÐÇÒ°æ¿ì ¿¡·¯ ¸Þ½ÃÁö¸¦ Ãâ·ÂÇÑ´Ù.
'´Ù¸¥ ¼­¹ö°¡ ´õÁ¸ÀçÇϸé Secondry ·çƾÀ» ´Ù½Ã ¸¸µç´Ù.
If Err.Number <> 0 Then
  '¿¡·¯ ¸Þ½ÃÁö Ãâ·Â
  Response.write "DB ¼­¹ö ¿¡·¯ ¹ß»ý"
  Response.End
End If


'On Error Goto 0 ¸¦ ÀÌ¿ëÇÏ¿© ¿¡·¯ 󸮸¦ ºÒ°¡´ÉÇÏ°Ô ÇÑ´Ù.
On Error Goto 0
%>
µ¡±Û (1)
¿ìŰ(220.93.111.230) 2009-03-04 15:52:06
ÇÊ¿äÇÑ ÀÚ·áÀε¥ Àß »ç¿ëÇϰڽÀ´Ï´Ù.. ±î¸ÔÀ»¼öµµ ÀÖÀ¸´Ï Á¦ ºí·Î±×¿¡ ÆÛ°¥²²¿ä^^ °¨»çÇÕ´Ï´Ù~
¹øÈ£ Á¦¸ñ À̸§ ³¯Â¥ Ãßõ Á¶È¸
13 ¹è¿­ÀÌ ÁøÂ¥, Á¤¸», È®½ÇÈ÷ Null ÀÎÁö üũ.. Áö¿ì 2010-05-20 66 7622
12 ¿¡µðÆ®Ç÷¯½º Á¤±Ô½Ä Àϰý ġȯ Áö¿ì 2010-03-21 63 3106
11 ASP¿ë md5 ÀÎÄÚµù ÇÔ¼öÀÔ´Ï´Ù.ÆÄÀÏ Áö¿ì 2007-09-19 98 6861
10 ¿¡·¯¹ß»ýÀ» ¹«½ÃÇÏ´Â On Error Resume Next[1] Áö¿ì 2007-03-20 80 3829
9 Redim() ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ µ¿Àû¹è¿­ »ç¿ë[1] Áö¿ì 2007-03-19 85 11321
8 RegExp.Test() ¸Þ¼Òµå¿Í RegExp.Execute.. Áö¿ì 2007-03-19 90 4674
7 ÄíŰ »ç¿ë¹ý Áö¿ì 2007-03-18 74 2549
6 ABC ¾÷·Îµå ÄÄÆÛ³ÍÆ® V4.1 ÆÄÀÏ ¹× »ùÇÃÆÄÀÏ Áö¿ì 2007-03-15 95 6852
5 Re: ABC ¾÷·Îµå ÄÄÆÛ³ÍÆ®[2] Áö¿ì 2007-03-16 91 13939
4 ÀÚµ¿¸µÅ© ÇÔ¼ö Áö¿ì 2007-03-14 78 2134
3 ¹«·á À̹ÌÁö ¸®»çÀÌÁî(GDI) - ³ª´©¹Ì ÄÄÆÛ..ÆÄÀÏ Áö¿ì 2007-03-13 75 17093
2 Dictionnary °´Ã¼, Scripting °´Ã¼ Áö¿ì 2007-03-08 79 3007
1 Á¦3»ç Äí۰¡ ±¸¿öÁöÁö ¾ÊÀ»¶§ °­Á¦ ¼³Á¤ÇÏ.. Áö¿ì 2006-05-11 93 6618
[1]
Á¦¸ñ ³»¿ë À̸§  
ziwooboard v1.0
Contact Phone Number
Bank Account number
ns1.ziwoo.net (119.199.174.18)
ns2.ziwoo.net (119.199.174.18)
Naver BLOG : http://blog.ziwoo.net
Family Homepage : http://home.ziwoo.net
Copyright ¨Ï 2006 By Ziwoo.net All right reserved. Administrator.ziwoonet@naver.com