https://docs.microsoft.com/ko-kr/sql/ssms/download-sql-server-management-studio-ssms


SQLSERVER 2008~2017까지 커버됩니다.


필요에따라 링크에 포함된 보안패치를 설치해야할 필요가 있습니다.

iframe 내부에서 사용하는 php에


header('P3P: CP="NOI CURa ADMa DEVa TAIa OUR DELa BUS IND PHY ONL UNI COM NAV INT DEM PRE"');


를 추가하면됨

--------------- 1.  DB 분리하기

 

sp_detach_db DB명

 

-- 혹시 사용중이라고 나오면 로그인 사용자 kill
-- sp_who -- 로그인 사용자 확인
-- kill spid--로그인 사용자 쥑이기
-- 그리고 SMS DB같은 경우 문자보내기 서비스가 실행중이므로 서비스를 중지 시키고,
-- 로그인사용자 kill 시키고 분리

 

----------------- 1. 분리 끝

 

 

-----------------  2. DB 연결
-- 로그 파일이 있는 경우 sp_attach_db 사용
 sp_attach_db @dbname='DB명', @filename1='파일경로\ball.mdf', @filename2='파일경로\ball_log.ldf'

 

--데이터 파일만 있은 경우 sp_attach_single_file_db 사용
sp_attach_single_file_db @dbname='DB명', @physname='파일경로\baseball.mdf'

-----------------  2. DB 연결 끝


1. read

 Properties ini = new Properties();
 String mode="";
 ini.load(new FileInputStream("/sdcard/init.ini")); 
 mode=ini.getProperty("version"); 


2.write

Properties ini = new Properties();
ini.put("version", "default"); // property Add
ini.setProperty("version", "single"); 
ini.store(new FileOutputStream("/sdcard/FTPTemp/init.ini",true), "Initialize"); //save

installing service pack 5 for Visual Basic 6 was problematic in windows 7. The installer checks the MDAC version and gives the warning that MDAC 2.5 should be installed as a minimum (I am sure a higher version of MDAC is installed in windows 7). After the warning it quits the setup procedure. 

 

To get around this issue the following worked for me: 

In the enu folder edit the following file: sp598ent.stf  

 

From the following line remove the number 36: 

Old line: 13 Group 28 36 38 29 30 32 26 27 14 25 16 17 20 18 19 15 39 21 22 24 23 43 

New line: 13 Group 28 38 29 30 32 26 27 14 25 16 17 20 18 19 15 39 21 22 24 23 43  

 

Delete the following 2 lines replacing them with just carriage returns: 

36 Depend "27 ? : 37" 

37 IsWin95 CustomAction "sp598ent.dll,CheckForMDAC"  

 

Save the file and run the installer again. 



rdcm27.zip


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

    + Recent posts