[pgsql-jp: 37171] クライアントＰＣからのODBC経由の接続方法について

[Tetsuya Abe]

$B3'$5$s!"$3$s$P$s$O!#(B

$B!!!!(B[pgsql-jp: 37123]$B%$%s%9%H!<%k;~$N%(%s%3!<%G%#%s%0$N ＠ _Dj$K$D$$$F(B

$B$G$*@$OC$K$J$C$?0$It$G$9!#$^$-$b$H$5$s$+$i$N%"%I%P%$%9$b$"$j$^$7$?$,!"(B
$B$H$K$+$/(B PostgreSQL $B$r$$$m$$$m;n$7$F$_$k$3$H$K$7$^$7$?!#!J$^$-$b$H$5$s!"(B
$B$=$N ＠ a$O$"$j$,$H$&$4$6$$$^$7$?!#!K(B

$B!!$?$@!"$7$P$i$/;n83E*$K1?MQ$7$F$_$k$3$H$K$7$^$7$?$N$G!"%$%s%9%H!<%k$O(B
$B;d$,;H$C$F$$$k%o!<%/%9%F!<%7%g%s$K$7$^$7$?!#$H$O$$$(!"$3$N%o!<%/%9%F!<%7%g%s(B
$B$O%5!<%P!<$h$j ＠ -G=$O$+$J$j>e$G$9!##O#S$,(B Windows XP Pro $B$J$N$G!"(B
$BF1;~%"%/%;%9$,#1#0%/%i%$%"%s%H$^$G$K8B$i$l$k$N$,;H$$$K$/$$E@$G$9!#(B
$B$?$@$7!";n83E*$J1?MQ$G$OA4$/LdBj$"$j$^$;$s!#(B

$B!!$5$F!"(BPostgreSQL 8.1.4 for Windows $B$N%$%s%9%H!<%k$b;Y>c$J$/$9$_!"(B
pgAdmin$B-7(B $B$K$h$k%"%/%;%9$b=gD4$G!"(BODBC$B7PM3$N@\B3$r;n$_$?$H$3$m$G(B
$B$$$m$$$mLdBj$,=P$F$-$^$7$?!#(B

$B!!$^$:!"(BPostgreSQL $B$r%$%s%9%H!<%k$7$?8eD4$Y$k$H!"(BODBC$B%I%i%$%P$O(B
$B%P!<%8%g%s(B 8.02.00.04 $B$,%$%s%9%H!<%k$5$l$F$$$^$7$?!#%I%i%$%P$NL>A0$O(B
$B!V(BPostgreSQL Japan$B!W(B $B$G$9!#(B

$B!!=i$a!"$3$N>uBV$G(BODBC$B@\B3$r;n$_$?$N$G$9$,<:GT$7$^$7$?!#;n$7$?$N$O(B

$B!!!!!V(BPostgreSQL $BE0Dl3hMQ%,%$%I(B for Windows$B!W!!%$%s%W%l%9(B

$B$K<}O?$5$l$F$$$k(B migration2 $B$G$9!#(BExcel $B$N%$%s%]!<%H5!G=$r;H$C$F$b$@$a(B
$B$J$N$G!"2?$+(B ODBC $B$N ＠ _Dj$,ITB-$7$F$$$k$H;W$$!"%$%s%?!<%M%C%H$GD4$Y$F!"(B
ODBC $B%G!<%?%=!<%9(B $B%"%I%_%K%9%H%l!<%?$N%7%9%F%`(B DSN$B$K(B PostgreSQL Japan
$B$rDI2C$7$^$7$?!#(B

$B!!$9$k$H!"(BExcel $B$N%$%s%]!<%H5!G=$,;H$($k$h$&$K$J$C$?$N$G!"(BADO$B$r;H$C$F(B
$B%G!<%?$N(BExcel$B$X$N%$%s%]!<%H$r;n$7$?$H$3$m!"$3$l$b ＠ .8y$7$^$7$?!#$?$@$7!"(B
migration2 $B$O$$$^$@$K%(%i!<$,=P$F@\B3$G$-$^$;$s!#%(%i!<$O$$$D$bF1$8$G!"(B

$B!!!!%j%9%H$,<hF@$G$-$^$;$s$G$7$?(B (S903)

$B$G$9!#(Bmigration2 $B$N%3!<%I$r0lIt$5$o$C$F$O8+$^$7$?$,%@%a$G$7$?!#$?$@$7!"(B
$B$3$l$O$3$l$+$i;~4V$r$+$1$FD4$Y$F$$$/$D$b$j$G$9!#(B

$B!!$*J9$-$7$?$$$N$O!"%M%C%H%o!<%/$K$D$J$,$C$F$$$kB>$N#P#C$+$i$N(BODBC$B7PM3(B
$B$N%"%/%;%9J}K!$G$9!#(BODBC $B%G!<%?%=!<%9(B $B%"%I%_%K%9%H%l!<%?$r8+$k$H!"(B
$B%U%!%$%k(B DSN $B$H$$$&$N$,$"$C$F!"(B

$B!!!!!!(BODBC $B%U%!%$%k(B $B%G!<%?%=!<%9$K$h$C$F%G!<%?%W%m%P%$%@$K@\B3$G$-$^$9!#(B
$B!!!!!!%U%!%$%k(B $B%G!<%?%=!<%9L>$OF1$8%I%i%$%P$r%$%s%9%H!<%k$7$F$$$k%f!<%6$H(B
$B!!!!!!6&M-$9$k$3$H$,$G$-$^$9!#(B

$B$H$$$&@bL@$,=P$F$-$^$9!#$3$3$+$i$OA[A|$G$9$,!"$*$=$i$/%/%i%$%"%s%H#P#C(B
$B$K$bF1$8(BODBC$B%I%i%$%P$r%$%s%9%H!<%k$9$kI,MW$,$"$k$N$@$m$&$H;W$&$N$G$9$,(B
$B$=$l$G$h$$$N$G$7$g$&$+!#$=$N>l9g!"%/%i%$%"%s%H$K$O(BODBC$B%I%i%$%P$@$1$r(B
$B%$%s%9%H!<%k$7$?$$$N$G$9$,!"(B

$B!!!!!!(Bhttp://pgfoundry.org/projects/psqlodbc/

$B$+$i%@%&%s%m!<%I$9$l$P$h$$$N$G$7$g$&$+!#$^$?!">e5-$N%@%&%s%m!<%I%5%$%H$N(B
ODBC$B$N%P!<%8%g%s$O(B psqlODBC 08.02.0002 $B$H$J$C$F$$$F!"(BPostgreSQL $B$,(B
$B%$%s%9%H!<%k$5$l$F$$$k#P#C$H$o$:$+$K0c$&$N$G$9$,!J$3$A$i$O!"%P!<%8%g%s(B 
8.02.00.04$B!K(B
$B$3$NDxEY$N0c$$$O$+$^$o$J$$$N$G$7$g$&$+!#(B

$B!!$^$?!"%/%i%$%"%s%H#P#C$K(BODBC$B%I%i%$%P$r%$%s%9%H!<%k$7$?8e$N ＠ _Dj$,!"$I$&$9$l$P(B
$B$h$$$N$+$h$/$o$+$j$^$;$s!#(B

$B!!$J$*!"(BPostgreSQL $B%G!<%?%Y!<%9%5!<%P$H$7$F;H$C$F$$$k%o!<%/%9%F!<%7%g%s$O(B

$B!!!!!!#O#S$O!!!'!!(BWindows XP Pro SP2
$B!!!!!!%5!<%P%(%s%3!<%G%#%s%0$O!!!'!!(BUTF8

$B$G$9!#(B

$B!!2?$+7hDjE*$J9M$(0c$$$r$7$F$$$k$+$b$7$l$^$;$s!#$=$l$b4^$a$F%M%C%H%o!<%/$K(B
$B$D$J$,$C$?%/%i%$%"%s%H#P#C$+$i$N(BODBC$B7PM3$N(B PostgreSQL $B$X$N@\B3J}K!$K(B
$B$D$$$F$*?R$M$$$?$7$^$9!#(B

$B!!=iJbE*$J<ALd$G?=$7Lu$"$j$^$;$s$,!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
$BD9J8$G<:Ni$$$?$7$^$7$?!#(B

/// $B0$ItE/Li(B