|
µ¨¸¶´ç °ø½Ä ÀºÇà°èÁ |
ÇϳªÀºÇà 227-910235-83607 |
¿¹±ÝÁÖ ÀÌ»ó±¹(¿î¿µÁø) |
|
|
|
|
|
|
|
|
|
|
°ÁÂ, ÆÁ, Á¤º¸ |
°ÁÂ, ÆÁ, Á¤º¸ ÀÔ´Ï´Ù. |
|
|
|
[angel] ADO ¿¡¼ SQL Server ¿¬°á |
Ÿ¶ôõ»ç
(±è¼ºÈÆ)
2015-11-07 ¿ÀÀü 10:07:23
Ä«Å×°í¸®:
ÆÁ
4073ȸ Á¶È¸
µî·ÏµÈ ÆÄÀÏÀÌ ¾ø½À´Ï´Ù.
|
|
|
¾È³çÇϼ¼¿ä. Ÿ¶ôÀÓµÂ.
OLE DB Provider ¸¦ Áö¿øÇÏ´Â SQL Server À̳ª Acess, Excel µîÀº ODBC ¾øÀÌ Á÷Á¢ ¿¬°á ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Á÷Á¢ ¿¬°á ÇÏ¸é ¼Óµµ°¡ ÈξÀ ºü¸¨´Ï´Ù.
ConnectionString ¿¡
"Data Source" º¯¼ö¿¡ DB IP ³ª DNS ³Ö°í "Initial Catalog" º¯¼ö¿¡ DB Name ³Ö°í, "User ID" º¯¼ö¿¡ ID ³Ö°í, "Password" º¯¼ö¿¡ ºñ¹Ð¹øÈ£ ³Ö°í
¿¬°á ÇÕ´Ï´Ù.
... ADOConnection1: TADOConnection; ADOQuery1: TADOQuery; ADOTable1: TADOTable; ...
ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=127.0.0.1,1433;Initial Catalog=MyDB;User ID=MyID;Password=MyPW';
ADOConnection1.Connected := true;
À̳ª
ADOQuery1.ConnectionString := 'Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=127.0.0.1,1433;Initial Catalog=MyDB;User ID=MyID;Password=MyPW';
ADOQuery1.Open;
À̳ª
ADOTable1.ConnectionString := 'Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=127.0.0.1,1433;Initial Catalog=MyDB;User ID=MyID;Password=MyPW';
ADOTable1.Open;
ÇÏ¸é µË´Ï´Ù.
PS 1: TADOQuery or TADOTable ÄÄÆ÷³ÍÆ®·Î µðºñ¿¡ ¿¬°á ÇÏ¿© Äõ¸® Á¶È¸ ÇÒ¼ö ÀÖ½À´Ï´Ù.
PS 2: TADOQuery or TADOTable ÄÄÆ÷³ÍÆ®·Î Excel ÆÄÀÏÀ» ¿¬°áÇÏ¿© ÀÐÀ» ¼ö ÀÖ½À´Ï´Ù.
|
|
|
|
|
|
|
|
|