HTML
Javascript
Flash Actionscript
PHP
mySQL
ASP
MS-SQL
Linux
Others
Ziwoo Board
Portfolio
About
ASP
ÀÛ¼º  2007-03-20 14:33:30   Ãßõ: 81   Á¶È¸: 3840
Á¦¸ñ  ¿¡·¯¹ß»ýÀ» ¹«½ÃÇÏ´Â 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 67 7637
12 ¿¡µðÆ®Ç÷¯½º Á¤±Ô½Ä Àϰý ġȯ Áö¿ì 2010-03-21 63 3112
11 ASP¿ë md5 ÀÎÄÚµù ÇÔ¼öÀÔ´Ï´Ù.ÆÄÀÏ Áö¿ì 2007-09-19 99 6867
10 ¿¡·¯¹ß»ýÀ» ¹«½ÃÇÏ´Â On Error Resume Next[1] Áö¿ì 2007-03-20 81 3840
9 Redim() ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ µ¿Àû¹è¿­ »ç¿ë[1] Áö¿ì 2007-03-19 86 11332
8 RegExp.Test() ¸Þ¼Òµå¿Í RegExp.Execute.. Áö¿ì 2007-03-19 91 4685
7 ÄíŰ »ç¿ë¹ý Áö¿ì 2007-03-18 76 2560
6 ABC ¾÷·Îµå ÄÄÆÛ³ÍÆ® V4.1 ÆÄÀÏ ¹× »ùÇÃÆÄÀÏ Áö¿ì 2007-03-15 95 6873
5 Re: ABC ¾÷·Îµå ÄÄÆÛ³ÍÆ®[2] Áö¿ì 2007-03-16 92 13970
4 ÀÚµ¿¸µÅ© ÇÔ¼ö Áö¿ì 2007-03-14 79 2143
3 ¹«·á À̹ÌÁö ¸®»çÀÌÁî(GDI) - ³ª´©¹Ì ÄÄÆÛ..ÆÄÀÏ Áö¿ì 2007-03-13 76 17367
2 Dictionnary °´Ã¼, Scripting °´Ã¼ Áö¿ì 2007-03-08 79 3016
1 Á¦3»ç Äí۰¡ ±¸¿öÁöÁö ¾ÊÀ»¶§ °­Á¦ ¼³Á¤ÇÏ.. Áö¿ì 2006-05-11 94 6621
[1]
Á¦¸ñ ³»¿ë À̸§  
ziwooboard v1.0
Contact Phone Number
Bank Account number
ns1.ziwoo.net (115.160.123.41)
ns2.ziwoo.net (115.160.123.41)
Naver BLOG : http://blog.ziwoo.net
Family Homepage : http://home.ziwoo.net
Copyright ¨Ï 2006 By Ziwoo.net All right reserved. Administrator.ziwoonet@naver.com