 |
 |
 |
 |
°¡ÀÔÇϽмºñ½º·Î ·Î±×ÀÎÇϼ¼¿ä |
|
|
|
 |
|
|
 |
|
|
|
|
| Home > À¥È£½ºÆÃ > ÀÌ¿ë¹æ¹ý ¾È³» > µ¥ÀÌÅͺ£À̽º »ç¿ëÇϱâ |
 |
|
|
 |
MSDEQUERYÀ» ÀÌ¿ëÇÏ¿© Á¢¼Ó ¹æ¹ý |
ÇØ´ç MSDEQUERY.ZIPÀ» »ç¿ëÇϱâ À§Çؼ´Â .NET Framework 2.0À» ¹Ýµå½Ã ¼³Ä¡ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
´Ù¿î·Îµå´Â ´ÙÀ½ »çÀÌÆ®¿¡¼ ´Ù¿î·Îµå ¹ÞÀ» ¼ö ÀÖ½À´Ï´Ù.
ÇØ´ç »çÀÌÆ®¿¡¼ ´Ù¿î·Îµå ¹Þ¾Æ .NET 2.0À» ¼³Ä¡ÇÕ´Ï´Ù.
¼³Ä¡°¡ ¿Ï·áµÇ¸é ÇØ´ç MSDEQUERY.ZIPÀ» ¾ÐÃàÇØÁ¦ ÇÕ´Ï´Ù
1. MSDEQUERY ¼³Ä¡Çϱâ
MSDEQUERY.ZIP ÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®¸é ´ÙÀ½°ú °°ÀÌ 3°³ÀÇ ÆÄÀÏÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.
1. Setup.exe ÆÄÀÏÀ» ´õºíŬ¸¯ÇÕ´Ï´Ù.
2. ¾Æ·¡¿Í °°Àº ȸ鿡¼ NEXT ¹öưÀ» Ŭ¸¯ÇÕ´Ï´Ù.
3. ´ÙÀ½Àº ¶óÀ̼¾½º µ¿ÀÇȸéÀÔ´Ï´Ù. [I Agree]¸¦ ¼±ÅÃÇϽŠÈÄ NEXT ¹öưÀ» Ŭ¸¯ÇÕ´Ï´Ù.
4. ¼³Ä¡Æú´õÀÇ ¼±ÅÃÀº default·Î ¼±ÅÃÇϽŠÈÄ [everyone]À» ¼±ÅÃÇϽŠÈÄ ¼³Ä¡ÇÕ´Ï´Ù.
5. ¼³Ä¡È®ÀΠȸ鿡¼ NEXT ¹öưÀ» ´·¯ÁֽʽÿÀ.
6. MSDE Query Á¤º¸¿¡¼ NEXT ¹öưÀ» ´·¯Áֽøé ÇÁ·Î±×·¥À» ¼³Ä¡ÇÕ´Ï´Ù.
7. ¼³Ä¡°¡ Á¤»óÀûÀ¸·Î ¿Ï·áµÇ¸é ¾Æ·¡¿Í°°Àº ȸéÀÌ Ç¥½ÃµË´Ï´Ù.
2. MSDEQUERY ½ÇÇàÇϱâ
MSDEQUERY¸¦ ½ÇÇàÇϱâ À§ÇÏ¿© [½ÃÀÛ] - [ÇÁ·Î±×·¥] - [MSDE QUERY]¸¦ ¼±ÅÃÇÕ´Ï´Ù.
¾Æ·¡ÀÇ ±×¸²°ú °°ÀÌ Ã¼Å©¹Ú½º¸¦ Ŭ¸¯ÇÏ¿© Ã¼Å©ÇØÁֽŠÈÄ OK ¹öưÀ» Ŭ¸¯ÇÕ´Ï´Ù.
1. MSDE Query¿¡¼ FILE- CONNET¸¦ Ŭ¸¯ÇÏ½Ã¸é ¾Æ·¡¿Í °°Àº âÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.
2. SQL Server Ç׸ñ¿¡ ÀÚ½ÅÀÇ SQL ¼¹öÀÇ IP ¸¦ ÀÔ·ÂÇϽŠÈÄ ¾Æ·¡ÀÇ SQL Server Authentication
(SQL ¼¹öÀÎÁõ) Ç׸ñÀ» üũÇÕ´Ï´Ù.
User Name °ú Password Ç׸ñ¿¡ ÀÚ½ÅÀÇ °èÁ¤°ú ÆÐ½º¿öµå¸¦ ÀÔ·ÂÇϽŠÈÄ OK ¹öưÀ» ´·¯ÁֽʽÿÀ.
3. ÀÚ½ÅÀÇ °èÁ¤°ú ÆÐ½º ¿öµå Á¤º¸°¡ ÀÏÄ¡ ÇÏ¸é ´ÙÀ½°ú °°ÀÌ Á¤»óÀûÀ¸·Î ·Î±×ÀÎÀ» È®ÀÎ ÇÒ ¼ö ÀÖ½À´Ï´Ù.
|
| |
| |
 |
| |
|
|
|