1. Import 후 우측 하단에 UTF-8누르고 more를 눌러서 x-windows-949 클릭



2.Reload 클릭




=================================================================================================

혹은 File - Import Settings에서 아래와 같이 설정







저작자표시 비영리 동일조건
  • Before proceeding with the installation process below, create a zero-byte file in C:\Windows called MSJAVA.DLL. The setup process will look for this file, and if it doesn't find it, will force an installation of old, old Java, and require a reboot. By creating the zero-byte file, the installation of moldy Java is bypassed, and no reboot will be required. Turn off UAC.
  • Insert Visual Studio 6 CD.
  • Exit from the Autorun setup.
  • Browse to the root folder of the VS6 CD.
  • Right-click SETUP.EXE, select Run As Administrator.
  • On this and other Program Compatibility Assistant warnings, click Run Program.
  • Click Next.
  • Click "I accept agreement", then Next.
  • Enter name and company information, click Next.
  • Select Custom Setup, click Next.
  • Click Continue, then Ok.
  • Setup will "think to itself" for about 2 minutes. Processing can be verified by starting Task Manager, and checking the CPU usage of ACMSETUP.EXE.
  • On the options list, select the following:
    • Microsoft Visual Basic 6.0
    • ActiveX
    • Data Access
    • Graphics
    • All other options should be unchecked.
  • Click Continue, setup will continue.
  • Finally, a successful completion dialog will appear, at which click Ok. At this point, Visual Basic 6 is installed.
  • If you do not have the MSDN CD, clear the checkbox on the next dialog, and click next. You'll be warned of the lack of MSDN, but just click Yes to accept.
  • Click Next to skip the installation of Installshield. This is a really old version you don't want anyway.
  • Click Next again to skip the installation of BackOffice, VSS, and SNA Server. Not needed!
  • On the next dialog, clear the checkbox for "Register Now", and click Finish.
  • The wizard will exit, and you're done. You can find VB6 under Start, All Programs, Microsoft Visual Studio 6. Enjoy!

    •  

     

    --설치이후--


    1.vb6.exe를 찾아 속성에서 관리자 권한으로 실행 체크

    2.sp6만 설치해도 된다.



    --오류--

     

    1.개체 라이브러리가 등록되지 않았습니다. 라고 뜰때

    patch.bat

    다운로드 후 실행


    2.컴파일했을때 실행파일이 XP에서 구동되지 않는다면

    ado.zip

    다운로드 후 progrom files\common\system\ado 에 덮어씌우기


    3.MSCOMCTL.OCX 가 등록해도 제대로 작동되지 않는다면

    vbp파일을 메모장으로 열어 버전을 2.1 -> 2.0으로 바꾸고 저장

    저작자표시 비영리 동일조건

    http://developer.android.com/google/gcm/gs.html#next

    저작자표시 비영리 동일조건

    select 

    case when (money - cashys) > 0 then '앞' 

    when (money - cashys) = 0 then '중' 

    else '뒤' 

    end  as 'DIFF_CHK' ,money,cashys

    from mem_Cashs

    저작자표시 비영리 동일조건
    service httpd graceful


    저작자표시 비영리 동일조건

    다른 서버의 동일한 조건의 테이블에 대량의 데이터를 옮겨야 할 때가 가끔 있다.

    그때 BULK INSERT를 사용하면 한방에 슉~ 넣어줄 수 있다.

     

    나는 다른 서버 DB의 데이터를 csv로 저장하여 가져왔다.

    그냥 select 하고 나온 결과에 마우스 우클릭해서 다른이름저장 눌러서 csv 로 저장할 수 있다!

     

      1 use DB_name 
  2 BULK INSERT [table_name] 
  3 from 'C:\test.csv' 
  4 with ( 
  5     CODEPAGE = 'RAW', 
  6     FIRSTROW = 2, 
  7     MAXERRORS = 0, 
  8     FIELDTERMINATOR = ',', 
  9     ROWTERMINATOR = '\n', 
 10     tablock 
 11     ) 
 12

     

    csv 파일 위치 잘 지정해주시고

    FirstRow = 2  는 첫번째 컬럼명 라인 짤라내기 위해 2번째 줄부터 입력하라 입니다.

    FIELDTerminator = ','  필드 구분자는 콤마

    ROWTerminator = '\n' 라인 구분자는 뉴라인

    [출처] [MSSQL] BULK INSERT |작성자 종벌


    저작자표시 비영리 동일조건

    해당 테이블에 존재하는 Identity 필드의 누적값을 알 수 있다.


    SELECT IDENT_CURRENT('테이블명') 

    저작자표시 비영리 동일조건

    response.write "ALL_HTTP"&Request.ServerVariables("ALL_HTTP")&"<br>"
    response.write "ALL_RAW"&Request.ServerVariables("ALL_RAW")&"<br>"
    response.write "APPL_MD_PATH"&Request.ServerVariables("APPL_MD_PATH")&"<br>"
    response.write "APPL_PHYSICAL_PATH"&Request.ServerVariables("APPL_PHYSICAL_PATH")&"<br>"
    response.write "AUTH_TYPE"&Request.ServerVariables("AUTH_TYPE")&"<br>"
    response.write "AUTH_USER"&Request.ServerVariables("AUTH_USER")&"<br>"
    response.write "AUTH_PASSWORD"&Request.ServerVariables("AUTH_PASSWORD")&"<br>"
    response.write "LOGON_USER"&Request.ServerVariables("LOGON_USER")&"<br>"
    response.write "REMOTE_USER"&Request.ServerVariables("REMOTE_USER")&"<br>"
    response.write "CERT_COOKIE"&Request.ServerVariables("CERT_COOKIE")&"<br>"
    response.write "CERT_FLAGS"&Request.ServerVariables("CERT_FLAGS")&"<br>"
    response.write "CERT_ISSUER"&Request.ServerVariables("CERT_ISSUER")&"<br>"
    response.write "CERT_KEYSIZE"&Request.ServerVariables("CERT_KEYSIZE")&"<br>"
    response.write "CERT_SECRETKEYSIZE"&Request.ServerVariables("CERT_SECRETKEYSIZE")&"<br>"
    response.write "CERT_SERIALNUMBER"&Request.ServerVariables("CERT_SERIALNUMBER")&"<br>"
    response.write "CERT_SERVER_ISSUER"&Request.ServerVariables("CERT_SERVER_ISSUER")&"<br>"
    response.write "CERT_SERVER_SUBJECT"&Request.ServerVariables("CERT_SERVER_SUBJECT")&"<br>"
    response.write "CERT_SUBJECT"&Request.ServerVariables("CERT_SUBJECT")&"<br>"
    response.write "CONTENT_LENGTH"&Request.ServerVariables("CONTENT_LENGTH")&"<br>"
    response.write "CONTENT_TYPE"&Request.ServerVariables("CONTENT_TYPE")&"<br>"
    response.write "GATEWAY_INTERFACE"&Request.ServerVariables("GATEWAY_INTERFACE")&"<br>"
    response.write "HTTPS"&Request.ServerVariables("HTTPS")&"<br>"
    response.write "HTTPS_KEYSIZE"&Request.ServerVariables("HTTPS_KEYSIZE")&"<br>"
    response.write "HTTPS_SECRETKEYSIZE"&Request.ServerVariables("HTTPS_SECRETKEYSIZE")&"<br>"
    response.write "HTTPS_SERVER_ISSUER"&Request.ServerVariables("HTTPS_SERVER_ISSUER")&"<br>"
    response.write "HTTPS_SERVER_SUBJECT"&Request.ServerVariables("HTTPS_SERVER_SUBJECT")&"<br>"
    response.write "INSTANCE_ID"&Request.ServerVariables("INSTANCE_ID")&"<br>"
    response.write "INSTANCE_META_PATH"&Request.ServerVariables("INSTANCE_META_PATH")&"<br>"
    response.write "LOCAL_ADDR"&Request.ServerVariables("LOCAL_ADDR")&"<br>"
    response.write "PATH_INFO"&Request.ServerVariables("PATH_INFO")&"<br>"
    response.write "PATH_TRANSLATED"&Request.ServerVariables("PATH_TRANSLATED")&"<br>"
    response.write "QUERY_STRING"&Request.ServerVariables("QUERY_STRING")&"<br>"
    response.write "REMOTE_ADDR"&Request.ServerVariables("REMOTE_ADDR")&"<br>"
    response.write "REMOTE_HOST"&Request.ServerVariables("REMOTE_HOST")&"<br>"
    response.write "REMOTE_PORT"&Request.ServerVariables("REMOTE_PORT")&"<br>"
    response.write "REQUEST_METHOD"&Request.ServerVariables("REQUEST_METHOD")&"<br>"
    response.write "SCRIPT_NAME"&Request.ServerVariables("SCRIPT_NAME")&"<br>"
    response.write "SERVER_NAME"&Request.ServerVariables("SERVER_NAME")&"<br>"
    response.write "SERVER_PORT"&Request.ServerVariables("SERVER_PORT")&"<br>"
    response.write "SERVER_PORT_SECURE"&Request.ServerVariables("SERVER_PORT_SECURE")&"<br>"
    response.write "SERVER_PROTOCOL"&Request.ServerVariables("SERVER_PROTOCOL")&"<br>"
    response.write "SERVER_SOFTWARE"&Request.ServerVariables("SERVER_SOFTWARE")&"<br>"
    response.write "URL"&Request.ServerVariables("URL")&"<br>"
    response.write "HTTP_CONNECTION"&Request.ServerVariables("HTTP_CONNECTION")&"<br>"
    response.write "HTTP_ACCEPT"&Request.ServerVariables("HTTP_ACCEPT")&"<br>"
    response.write "HTTP_ACCEPT_ENCODING"&Request.ServerVariables("HTTP_ACCEPT_ENCODING")&"<br>"
    response.write "HTTP_ACCEPT_LANGUAGE"&Request.ServerVariables("HTTP_ACCEPT_LANGUAGE")&"<br>"
    response.write "HTTP_COOKIE"&Request.ServerVariables("HTTP_COOKIE")&"<br>"
    response.write "HTTP_HOST"&Request.ServerVariables("HTTP_HOST")&"<br>"
    response.write "HTTP_USER_AGENT"&Request.ServerVariables("HTTP_USER_AGENT")&"<br>"

    [출처] ASP 각종 헤더값 모음..|작성자 likeclay


    저작자표시 비영리 동일조건
    Option Explicit
    Public cnDB As ADODB.Connection
    Public dbRS As ADODB.Recordset
    Public dbRS2 As ADODB.Recordset
    Public Function MySQL_Conn() As Boolean
        On Error Resume Next
     
        Dim ip, dbname, uuser, upwd As String
        Dim CnString  As String
     
        Set cnDB = New ADODB.Connection
        CnString = "DRIVER={MySQL ODBC 5.2 ANSI Driver};" & _
                               "SERVER = 서버의 아이피 주소;" & _
                               "PORT=3306" & _
                               "DATABASE = 데이타베이스명;" & _
                               "UID=아이디;PASSWORD=비밀번호;OPTION=3"
     
        With cnDB
            .ConnectionString = CnString
            .CursorLocation = adUseClient
            .ConnectionTimeout = 30
            .Open
        End With
     
        If cnDB.State <> adStateOpen Then
            MsgBox cnDB.Errors.item(cnDB.State), vbExclamation, "데이터베이스 연결 오류"
            MySQL_Conn = False
        Else
            MySQL_Conn = True
        End If


    저작자표시 비영리 동일조건



    위 처럼 추가한 후 서비스에서 FTP를 재시작하고 방화벽에서 해당 포트를 열어주는 수 밖에 없다.

    기본 패시브포트는 50여개쯤 되는거 같음;;

    저작자표시 비영리 동일조건

    + Recent posts

    티스토리툴바