DB 연결문자열 쉽게 만들기 [UDL] | DataBase

DB 연결문자열 쉽게 만들기 [UDL] | DataBase
2004-05-10 오전 11:42:03

senosora senosora님께 메시지 보내기senosora님을 내 주소록에 추가합니다.senosora님의 개인게시판 가기
번호: 6840  / 읽음:11,854

많은 분들이 아시지만 모르시는 분들도 계시기에 남겨봅니다.

1.아무 txt파일을 만드시고 이름을 XXXX.udl로 변경해 주십시요.

2.아이콘이 컴퓨터와 폴더모양으로 변경되었으면 더블클릭

3.데이터 연결 속성창에서 공급자를 선택(전 Microsoft OLE DB Provider for SQL Server) 후 다음 버튼

4.연결탭으로 이동되었다면 서버명과 암호 데이터베이스를 선택한 후 연결테스트

5.연결테스트가 성공이라면 확인 버튼을 누른후 방금 작성된 XXXX.udl파일을 텍스트 편집기로 읽어오시면

6.결과를 확인하시면 됩니다.

[oledb 결과]

; Everything after this line is an OLE DB initstring

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=XXXX;Initial Catalog=XXXX;Data Source=XXXX

“DB 연결문자열 쉽게 만들기 [UDL] | DataBase”의 8개의 댓글

  1. This is the right web site for anyone who wishes to find out about this topic.
    You understand a whole lot its almost hard to argue with you (not that I
    really would want to…HaHa). You certainly put a new spin on a subject that has been written about for ages.

    Great stuff, just excellent!

  2. Hi there! I just wanted to ask if you ever have any issues
    with hackers? My last blog (wordpress) was hacked and I ended up
    losing months of hard work due to no data backup. Do you have any
    methods to stop hackers?

  3. It’s perfect time to make a few plans for the longer
    term and it is time to be happy. I’ve read this post and if I could
    I desire to suggest you few attention-grabbing issues or suggestions.
    Perhaps you can write subsequent articles regarding this article.
    I desire to read more issues about it!

  4. Excellent post. I was checking continuously this weblog
    and I am inspired! Extremely useful info specifically the last phase :
    ) I take care of such information much. I was
    seeking this certain info for a very lengthy time. Thank you and
    good luck.

  5. Greate pieces. Keep writing such kind of info on your site.
    Im really impressed by it.
    Hello there, You have done an incredible job.
    I’ll definitely digg it and personally suggest to my friends.
    I’m confident they will be benefited from this
    web site.

댓글 남기기