[pgsql-jp: 39420] Re: AccessアプリからODBC経由postgresQLへの接続

YUKI ishimaru_y @ itc-tokyo.com
2008年 6月 6日 (金) 16:15:43 JST


$B$3$s$K$A$O!"%O%`$N?M$G$9!#(B



> Access$B%"%W%j!"(BODBC$B!"(BpostgreSQL$B$NAH9g$;$ODA$7$$%1!<%9$N(B
> $B$h$&$G(Bmailing list$B$G$bM>$j;vNc$,Js9p$5$l$F$$$^$;$s!"$=$3$G$*?R$M$9$k(B
> $B$b$N$G$9!"$I$J$?$+$465<x$*4j$$=PMh$^$9$G$7$g$&$+!#(B

$B!Z<ALd-!![(B
$B$3$NLdBj<+BN!"(Bpg$B$NLdBj$G$OL5$/!"(BAccess$B$G$O$J$$$N$G$7$g$&$+!)(B



> $B#1!%4D6-!'(B
> $B!!!!%$!%!!#2Bf$N(BPC(OS:XP) $B$,(Blocal network$B$G7R$,$C$F$$$F(B
> $B!!!!!!!!!!0lJ}$N(BPC$B!J$$$o$P(Bserver pc)$B$K(BpostgresQL(windows$BHG(Bver8.2),
> $B!!!!!!!!(B  $B0lJ}$N(BPC$B!J$$$o$P(Bclient pc)$B$K(BAcess2003$B$N%"%W%j%1!<%7%g%s(B
> $B!!!!!!!!(B  (access$B%"%W%j(B)$B$,%$%s%9%H!<%k$5$l!"(Bdriver$B$O(Baccess2003$B$K%P%s%I%k(B
> $B!!!!!!!!!!$5$l$F$$$k(BPostgreSQL Unicode(ver 8.02.05,PSQLODBC35W.DLL)
>  $B!!!!!!!!(B $B$r;HMQ$7$F$$$^$9!#(B
$B!Z<ALd-"![(B
$B%/%i%$%"%s%HC<Kv$N!V(B"Acess2003$B$N%"%W%j%1!<%7%g%s(B(access$B%"%W%j(B)$B$,%$%s%9%H!<%k(B
$B$5$l!"(Bdriver$B$O(Baccess2003$B$K%P%s%I%k$5$l$F$$$k(BPostgreSQL Unicode(ver 8.02.05,P
SQLODBC35W.DLL)$B$r;HMQ$7$F$$$^$9!#(B"$B!W$H$O(BAccess2003$B$N(BVBA$B$G:n @ .$7$?%G!<%?%Y!<(B
$B%9@\B3(Bapplication$B$J$N$G$7$g$&$+!)(B

$B$G$"$k$J$i$P!"$^$:%G!<%?%Y!<%9@\B32U=j$N%3!<%I$r;2>H$5$l$F(B
$B$O$$$+$,$G$7$g$&!)(B


$B4V0c$$$G$"$l$P!"$=$N(B"access$B%"%W%j(B"$B$K$D$$$F>\:Y$r65$($F2<$5$$!#(B




> $B!!!!%m!%(Baccess$B%"%W%j$rN)$A>e$2$k:]$NA`:n!'(B
> $B!!!!!!!!(Baccess$B$N(B'file'$B%a%K%e!!(B ->  'Get External Data'
>   $B!!!!(B   -> 'Link Tables' -> ' Link' $B$H$$$&%U%!%$%k(B
> $B!!!!!!!!%@%$%"%m%0%\%C%/%9$,N)$A>e$,$k!!(B-> 'Files of type'
>    $B!!!!(B  $B$G!!(B'ODBC Database() '$B$rA*Br(B -> 'Select Data
>  $B!!!!(B     Source' $B2hLL$,I=<($5$l(Bdsn $B%U%!%$%k$rA*Br(B($B$3$l$O<+J,$G:n @ .(B)
> $B#2!%LdBj!'(B
> $B!!!!%$!%>e5-A`:n$G(Baccess$B%"%W%j$r(BpostgresQL$B$K@\B3$5$;(B
> $B!!!!!!!!(B $B$7$P$i$/;HMQ$7$^$9$,LdBj$,5/$-$k$N$O!";HMQ$r0lC6=*N;$7$F(Baccess$B%"%W(B
> $B%j$r(B
> $B!!!!!!!!=*N;$5$;:FEY%"%W%j$r3+$3$&$H$9$k:]$G$9!"B($A$=$N:]$K%(%i!<%a%C%;!<%8(B
> $B!!!!!!!!!V(BODBC--connection to '{PostgreSQL Unicode}192.168.3.2}'failed$B!W(B
> $B!!!!!!!!$,=P$^$9!#(B
> $B!!!!%m!%A`:n$rB39T$9$k$K$O>e5-#1(B-$B%m$r:FEY<B9T$9$k$7$+$"$j$^$;$s$,!"$3$l$G$O(B
> $B!!!!!!!!%"%W%j%f!<%6$K$H$C$F$OHs>o$K;H$$$K$/$$%G!<%?%Y!<%9$H$J$j$^$9!#(B
> $B!!!!!!!!$3$l$r2r7h$9$k$K$O$I$3$rD>$;$P$h$$$N$G$7$g$&$+!#(B
>
> PSC SOFT CORPORATION
> $B8EC+BY;0(B
> $B!!!!(B
>
>
>


$B(,(,(,(,(,(,(,(,(,(,!D!D!E!&!&(B $B!&!!!&!!!!!&(B
$B%8%'%$%"!<%k@>F|K\>&;v-j(B
  $B%X%k%W%G%9%/C4Ev!!@P4](B
  TEL:06-4868-8668/FAX:06-4868-8608
  E-Mail:web_help @ jrw-syoji.co.jp
  URL:https://www.jrw-syoji.co.jp/top.html
$B(,(,(B




pgsql-jp メーリングリストの案内