old site memo:
53ｺﾐ､ﾎﾆ・ﾋ･ﾗ･愠ｰ･鬣ﾞ｡｢ｳﾆｼ・ﾀｸ・ﾇ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹﾁ犲釥鋠ﾔﾃ・BR> PHP,PERL,RUBY､ﾈ､､､ﾃ､ｿ･ｻ･ﾟ･皈ｸ･罍ｼｷﾏ､ﾎｸﾀｸ・ﾏ､筅ﾁ､惕・BR> HSP､ﾇ､篶ｾﾃﾘHSP､ﾇCGI｡ﾙ､ｬ､｢､・ｬVbScript､菷・ﾜｸ・ﾗ･愠ｰ･鬣犧ﾀｸ・ﾊ･ﾇ･ｷ･ｳ､ﾇ､ﾏ
CGI､ﾈRDBMS､ﾎﾏ｢ｷﾈ､ｹ､・ｵ･ﾗ･・ﾗ･愠ｰ･鬣爨ｬ･ﾍ･ﾃ･ﾈｸ｡ｺﾇ､ﾊ､ｫ､ﾊ､ｫｸｫ､ﾄ､ｫ､鬢ﾊ､､､ﾎ､ﾇ
ｼｫﾊｬ､ﾇ､ﾄ､ｯ､ﾃ､ﾆ､､､ﾞ､ｹ｡｣ﾆｱｹ･､ﾎﾊ ､ﾎｻｲｹﾍ､ﾋ､ﾊ､・ﾐｹｬ､､､ﾇ､ｹ｡｣(fseigo@yahoo.co.jp)
WindowsXp､ﾎVBSCRIPT､ﾇ､ﾏ｡｢､ｳ､・ﾇ､ｦ､ﾞ､ｯ､､､ﾃ､ｿ
dim adocon
set adocon=createobject("adodb.connection")
adocon.open "driver={MySQL ODBC 3.51 Driver};server=localhost;database=test;uid=root;pwd=root;"
'adocon.open "driver={SQL Server};server=(local);database=test;uid=root;pwd=root;"
'adocon.open "driver={PostgreSQL};server=localhost;database=postgres;username=postgres;password=postgres;"
sql="select name from foo"
set adors=adocon.execute(sql)
do until adors.eof=true
==wscript.echo adors.fields("name")
==adors.movenext
loop
adors.close
adocon.close
set adors=nothing
set adocon=nothing
ｺﾇｿｷ､ﾎwindowsﾂﾐｱ postgresql8､ﾇ､ﾏ､ｦ､ﾞ､ｯ､､､ｫ､ﾊ､､､ｬ｡｢cygwin､ﾎ､ｽ､・ﾇ､ﾏ､ｦ､ﾞ､ｯ､､､ﾃ､ｿ
MSSQL､ﾏ･ﾕ･遙ｼ､ﾎmsde､筅ﾁ､､､ｿ｡｣mysql､ﾏversion4
･｢･ｯ･ｻ･ｹ､ﾏdao､ﾈado､ﾎ､､､ｺ､・ﾇ､筌ﾏ｣ﾋ｡｣､ｽ､ﾎ､ｦ､ﾁ･ｵ･ﾗ･・ﾇｼｨ､ｷ､ﾞ､ｹ｡｣ ､ﾁ､ﾊ､ﾟ､ﾋﾆ・ﾜｸ・ﾗ･愠ｰ･鬣ﾟ･ｰｸﾀｸ・ﾊ･ﾇ･ｷ･ｳ､ﾇ､ﾏ
｡ﾘdriver={MySQL ODBC 3.51 Driver};server=localhost;database=test;uid=root;pwd=root;｡ﾙ､ﾇADOｳｫ､ｯ
｡ﾘselect name from foo｡ﾙ､QLｼﾂｹﾔ
DBｷ・ﾌﾁｴﾉ霹ﾀ
､ｽ､・ｽｼｨ
､ﾇﾁｴﾉ・郛霹ﾀ､ｹ､・ ﾋ｡､筅｢､・ｬ･皈筵熙ｬﾉﾔｰﾂ､ﾊｾ・・br> ｡ﾘdriver={SQL Server};server=(local);database=fseigo;uid=sa;pwd=sa;｡ﾙ､ﾇADOｳｫ､ｯ
｡ﾖselect * from foo｡ﾗ､ﾇSQLｼﾂｹﾔ
DBｺﾇｸ衒ｽﾄ・BR> ､ｽ､・ｬ｣ｰ､ﾈﾅｷ､､､ﾎｴﾖ｡｢
==｡ﾖname｡ﾗ､ﾎDB･ﾕ･｣｡ｼ･・ﾉｼ霹ﾀ
==､ｽ､・ｽｼｨ
==DBｼ｡ｰﾜﾆｰ
==DBｺﾇｸ衒ｽﾄ・BR> DBﾊﾄ､ｸ､・BR> ､ﾈ､､､ｦ･ｪ｡ｼ･ｽ･ﾉ･ﾃ･ｯ･ｹ､ﾊﾊ ﾋ｡､ｬ､｢､・｣ﾊｿﾀｮ18ﾇｯ7ｷ・2ﾆ・BR> ｸｽｺﾟODBC-ACCESS&MSSQLｴﾘｿHP､ﾇｻ釥ｽ､ｦ､ﾈ､ｷ､ﾆ､､､・｣
CYGWIN-Pgｴﾘｿ簑ｧﾈｿ､皃ｷ､ｿ､､｡｣
(Mysq4,Pg8､ﾏﾀｮｸｺ､ﾟ)
ﾄﾉｿｭ｡｡ActivePerl､ﾇ､ﾎDBI､ﾏｽｪ､ｨRuby､ﾇ､ﾎDBI､簗ﾙｶｯﾃ讀ﾀ､ｬ｡｢
Ruby､ﾏUnix､ﾇ､ﾊ､､､ﾈ｡｢ｽﾐﾎﾏ､ｬｶｵｲﾊｽﾉ､ｦ､熙ﾇ､ﾊ､､
mswinﾈﾇ､ﾇruby/dbiﾌﾜｲｼ･ﾍ･ﾃ･ﾈ､｡ｺ讀ﾀ､ｬ
xonwin､ﾇruby/tk､ﾏ､ﾇ､ｭ､・ﾎ､ﾏｳﾎﾇｧ､ｺ､ﾟ
､ﾁ､遉ﾃ､ﾈｸﾅ､､､ｬRedHat6.2J､ﾇ･､･ｹ･ﾈ｡ｼ･・ﾑ､ﾟ､ﾎpgsql､ﾄ､ｫ､ﾃ､ﾆ
perl-dbi and ruby-dbi､ﾇ､ｭ､ｿ､ﾎ､ﾇﾊｷ､ﾞ､ｹ｡｣
php､ﾎ･､･ｹ･ﾈ｡ｼ･・筅ｽ､ﾎ､ｦ､ﾁ､荀ﾃ､ﾆ､ﾟ､・ﾄ､筅熙ﾇ､ｹ｡｣
ﾉｽｼｨ､ﾏ､ｳ､ﾁ､・a href="./dbi.html">dbi.html
､ｽ､ﾎ､ﾛ､ｫ､ﾎﾏﾃﾂ熙ﾏ､ｳ､ﾁ､・a href="./memo.html">memo.html
