|
|
|
|
 |
|
소피아 / 2002-01-25 / 오후 6:00:37 / 211.237.95.214
조회수 : 128
|
| [질문] 왜 다들 답변이 없죠..흐흐(제가 싫으신가요 ^^) |
> [벌레]
> Login failed for user '????????'.
> ????? <----UID이름입니다.
>
> [SP]
> SELECT_1: -- 홈페이지 계약자 체크
> DECLARE @NAME CHAR(10)
>
> SELECT @NAME = CLINAME
> FROM BCACNTB0
> WHERE CDSITE = @CDSITE
> AND DONG = @DONG
> AND HO = @HO
> AND CLIJUMIN = @JUMIN
>
> SELECT CASE WHEN @NAME IS NULL THEN 'N' ELSE @NAME END
> RETURN
>
>
> [ASP]
> <% Option Explicit %>
> <%
> '개체 생성
> Dim cn
> Dim strConnection
>
>
>
> Set cn = Server.CreateObject("ADODB.Connection")
> strConnection="Provider=SQLOLEDB;Data Source=***.***.***.**;Initial Catalog=*******;UID=*******;Password=******;"
> cn.Open strConnection
>
>
>
> Set com = Server.CreateObject("ADODB.Command")
>
> With com
> .ActiveConnection = cn
> .CommandText = "user_paysearch"
> .CommandType = adCmdStoredProc
>
> .Parameters.Append .CreateParameter ("@TYPE", adChar, adParamInput, 4, "SEL1")
> .Parameters.Append .CreateParameter ("@SITENAME", adVarChar, adParamInput, 30, "갈월동오피스텔")
> .Parameters.Append .CreateParameter ("@DONG", adChar, adParamInput, 4, "508")
> .Parameters.Append .CreateParameter ("@HO", adSmallInt, adParamInput, 0, "bu1032")
> .Parameters.Append .CreateParameter ("@JUMIN", adChar, adParamInput, 14, "******-*******") <---주민등록번호
> .Parameters.Append .CreateParameter ("@PAYDATE", adChar, adParamInput, 8, "bu1032")
> .Parameters.Append .CreateParameter ("@SIDO", adChar, adParamInput, 1, "bu1032")
>
>
>
> End With
>
> Set rs = Server.CreateObject ("ADODB.Recordset")
> rs.Open com,, adOpenStatic, adLockReadOnly, adCmdStoredProc
>
>
>
> %>어쩌구 저쩌구...
>
> SP에서 SQL을 첨으로 찍어보는데 이런 에러가
> 나네요..
> SQL2000계정문제 같은데 혹시 저가 잘못 선언한
> 것이 있나요...
> 도와주세요...살려주세요...(^^)
>
>
-----------------------------------------------------------
|
|
|
|