<html> <head> <meta content="text/html; charset=ISO-2022-JP" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#FFFFFF"> <div class="moz-cite-prefix"> <pre wrap="">$B5WJ](B(jflute)$B$5$s!"C]Fb$5$s!"8^==Mr$5$s!"(Btaknb2nch$B$5$s(B $B;V?e$G$9!#(B $B$3$s$JC1=c$J%O%^%j$G$*CQ$:$+$7$$8B$j$N(BHELP$B%a!<%k$@$C$?$N$G$9$,(B $B$_$J$5$^%"%I%P%$%9$"$j$,$H$&$4$6$$$^$9!#(B $BN^$,%A%g%A%g%.%l$^$7$?!#!#(B $B%"%I%P%$%9$r85$KLdBj2r7h$7$^$7$?!#(B taknb2nch$B$5$s!"$d$O$j(BSQLServer$B$N>l9g$OJLES(Bdll$BEy$OI,MW$J$$$s$G$9$M!#(B $B8^==Mr$5$s%"%I%P%$%9$N2~9T$N7o$OBg>fIW$G$7$?!#(B $B;n$7$KC]Fb$5$s%"%I%P%$%9$N@\B3J8;zNs$r;29M$K$7$?$i@\B3$G$-$^$7$?!#(B $B"(:#EY(BC/S$B3+H/$9$k:]$K;29M$K$5$;$F$b$i$$$^$9!#(B $B5WJ]$5$s%"%I%P%$%9$N%Z!<%8$O!"D4::$7$F$$$?:]$KFI$s$G$$$F!JFI$s$@5$$K$J$C$F$$$?!)!K(B $B$3$N(BHELP$B%a!<%k=P$9A0$K$b%]!<%HHV9f;XDj$r$7$F$_$F$O$$$?$N$G$9$,(B $B%]!<%H;XDj$N;EJ}$r4V0c$C$F$$$?$h$&$G$9!#(B $B$o$?$7$N@hF~4Q$G$9$M!#(BIP$B%"%I%l%9$N$"$H$K!V(B192.168.1.49:1433<font face="ms gothic, monospace">\MSSQLSERVER</font>$B!W$H$7$F$$$^$7$?!#(B <font face="ms gothic, monospace"> $B$=$l$G!"85!9$N@\B3J8;zNs$G$b;n$7$F$_$?$H$3$m!"(B $BN>J}$G$N@\B3$,2DG=$G$7$?!#(B "Data Source=tcp:</font><font face="ms gothic, monospace">192.168.1.49\MSSQLSERVER,1433;Initial Catalog=</font><font face="ms gothic, monospace">db_11;User ID=</font><font face="ms gothic, monospace">user11;Password=</font>passwd" </pre> <pre wrap="">"Server=192.168.1.49\MSSQLSERVER,1433;Database=db_11;User ID=user11;Password=passwd"</pre> <br> $B$H$$$&$o$1$G!"3'MM$N$*$+$2$GL5;v2r7h$G$-$^$7$?!#(B<br> $BK\Ev$K$b$&!"$J$s$H8@$C$F$$$$$d$i!">p$1$J$$(BOrz<br> $B:#EY$+$i$A$c$s$HFI$b$&$H;W$$$^$7$?!#(B<br> $B$"$j$,$H$&$4$6$$$^$7$?!#!#(B<br> <br> <br> </div> <blockquote cite="mid:CAALfU-Ds5xDpX8oAgVZEu15c+VF2nw+RKBX4zFqokNe9QuY3MQ@mail.gmail.com" type="cite"> <pre wrap="">$B5WJ](B(jflute)$B$G$9(B $B;V?e$5$s!"$3$s$K$A$O!#(B DBFlute.NET$B$4MxMQ$"$j$,$H$&$4$6$$$^$9!#(B $B$A$g$C$H(B.NET$B$G(BSQLServer$B$K$D$J$$$G$k4D6-$,<j85$K$J$$$N$G!"(B $B8+$?$@$1$G$O9g$C$F$k$+$I$&$+ITL@$J$N$G$9$,!"(B JDBC$B$H$+B>$+$i$&$^$/$$$C$F$k$H$$$&$3$H$O!"(B $B$b$&(B Quill.config $B$N=q$-J}$H9M$($k$N$,<+A3$G$9$,(B... $B%]!<%HHV9f$C$F!";XDj$7$J$/$F$b(BOK$B$J$s$G$9$h$M!)(B ($B0J2<$N%5%$%H$r;29M$K$7$?$@$1$G$9$,!"(B $B?'!9$J=q$-J}$r;n$7$F$_$?$$$H$3$m$G$9$M(B) <a class="moz-txt-link-freetext" href="http://shiba-yan.hatenablog.jp/entry/20110103/1294060564">http://shiba-yan.hatenablog.jp/entry/20110103/1294060564</a> # $B$I$J$?$+!"(B.NET$B$G(BSQLServer$B$K(BDB$B%"%/%;%9$5$l$F$$$kJ}$G!"(B # $B!V@\B3J8;zNs$r$3$s$J46$8$G=q$$$F$k$h!W(B # $B$_$?$$$J>pJs$"$j$^$7$?$i%3%a%s%HD:$1$k$H=u$+$j$^$9!#(B </pre> <div class="moz-cite-prefix">(2014/03/28 9:11), $BC]Fb3X(B wrote:<br> </div> <blockquote cite="mid:CAK8ywK92P6BDO2e5APRaJ2YuFROtPcM961uDd2UecQY8d+8Orw@mail.gmail.com" type="cite"> <div dir="ltr"> <div class="gmail_default" style="font-family:'ms gothic',monospace">$BC]Fb$G$9!#(B</div> <div class="gmail_default" style="font-family:'ms gothic',monospace"><br> </div> <div class="gmail_default" style="font-family:'ms gothic',monospace"> <a moz-do-not-send="true" href="http://APS.NET">APS.NET</a> $B$G$O$J$/$F!"%/%i%5%P!&%"%W%j$J$N$G!"$"$^$j;29M$K$O$J$i$J$$$+$b$7$l$^$;$s$,(B...</div> <div class="gmail_default" style="font-family:'ms gothic',monospace"><br> </div> <div class="gmail_default" style="font-family:'ms gothic',monospace"> $B;d$N>l9g$O!"D>@\!"@_Dj%U%!%$%k$K5-=R$9$k$N$G$OL5$/$F(B IConnectionString $B$r<BAu$7$?%/%i%9$G@\B3J8;zNs$r@8@.$9$kMM$K$7$F$*$j$^$9!#(B</div> <div class="gmail_default" style="font-family:'ms gothic',monospace"># $B$d$C$Q$j!"%Q%9%o!<%I$,J?J8$G5-=R$5$l$k$N$ODq93$,$"$k$N$G!#(B</div> <div class="gmail_default" style="font-family:'ms gothic',monospace"> <br> </div> <div class="gmail_default" style="font-family:'ms gothic',monospace">-- App.config --</div> <div class="gmail_default"> <div class="gmail_default"><font face="ms gothic, monospace">  <quill></font></div> <div class="gmail_default"><font face="ms gothic, monospace">    <dataSources></font></div> <div class="gmail_default"><font face="ms gothic, monospace">      <dataSource name="DataSource"></font></div> <div class="gmail_default"><font face="ms gothic, monospace">        <provider>SqlServer</provider></font></div> <div class="gmail_default"><font face="ms gothic, monospace">        <connectionString>xxx.Helpers.ConnectionStringHelper</connectionString></font></div> <div class="gmail_default"><font face="ms gothic, monospace">        <class>Seasar.Extension.Tx.Impl.TxDataSource</class></font></div> <div class="gmail_default"><font face="ms gothic, monospace">      </dataSource></font></div> <div class="gmail_default"><font face="ms gothic, monospace">    </dataSources></font></div> <div class="gmail_default"><font face="ms gothic, monospace"><br> </font></div> <div class="gmail_default"><font face="ms gothic, monospace">    <configPath>App.dicon</configPath></font></div> <div class="gmail_default"><font face="ms gothic, monospace"><br> </font></div> <div class="gmail_default"><font face="ms gothic, monospace">    <assemblys></font></div> <div class="gmail_default"><font face="ms gothic, monospace">      <assembly>Seasar.DynamicProxy</assembly></font></div> <div class="gmail_default"><font face="ms gothic, monospace">      <assembly>Seasar.Dao</assembly></font></div> <div class="gmail_default"><font face="ms gothic, monospace">      <assembly>Seasar.Dxo</assembly></font></div> <div class="gmail_default"><font face="ms gothic, monospace">      <assembly>Seasar.Windows</assembly></font></div> <div class="gmail_default"><font face="ms gothic, monospace"><br> </font></div> <div class="gmail_default"> <font face="ms gothic, monospace">      </font></div> <div class="gmail_default"><font face="ms gothic, monospace">      </font></div> <div class="gmail_default"><font face="ms gothic, monospace">    </assemblys></font></div> <div class="gmail_default"><font face="ms gothic, monospace">  </quill></font></div> <div style="font-family:'ms gothic',monospace"> <br> </div> <div><font face="ms gothic, monospace">  <userSettings></font></div> <div><font face="ms gothic, monospace">        <xxx.Properties.Settings></font></div> <div><span style="font-family:'ms gothic',monospace">              <setting name="DatabaseDataSource" serializeAs="String"></span><br> </div> <div><font face="ms gothic, monospace">                    <value>localhost\SQLEXPRESS</value></font></div> <div><font face="ms gothic, monospace">              </setting></font></div> <div><font face="ms gothic, monospace">              <setting name="DatabasePort" serializeAs="String"></font></div> <div><font face="ms gothic, monospace">                    <value>1433</value></font></div> <div><font face="ms gothic, monospace">              </setting></font></div> <div><font face="ms gothic, monospace">              <setting name="DatabaseInitialCatalog" serializeAs="String"></font></div> <div><font face="ms gothic, monospace">                    <value>xxx</value></font></div> <div><font face="ms gothic, monospace">              </setting></font></div> <div><font face="ms gothic, monospace">              <setting name="DatabaseUserID" serializeAs="String"></font></div> <div><font face="ms gothic, monospace">                    <value>xxx</value></font></div> <div><font face="ms gothic, monospace">              </setting></font></div> <div><font face="ms gothic, monospace">              <setting name="DatabasePassword" serializeAs="String"></font></div> <div><font face="ms gothic, monospace">                    <value>xxx</value></font></div> <div><font face="ms gothic, monospace">              </setting></font></div> <div><font face="ms gothic, monospace">        </InventoryVerification.Properties.Settings></font></div> <div><font face="ms gothic, monospace">    </userSettings></font></div> <div style="font-family:'ms gothic',monospace"><br> </div> <div style="font-family:'ms gothic',monospace"><br> </div> <div style="font-family:'ms gothic',monospace"> -- ConnectionStringHelper.cs --</div> <div> <div><font face="ms gothic, monospace">namespace xxx.Helpers {</font></div> <div><font face="ms gothic, monospace">    /// <summary></font></div> <div><font face="ms gothic, monospace">    /// $B%G!<%?%Y!<%9@\B3J8;zNs%X%k%Q!<(B $B%/%i%9(B</font></div> <div><font face="ms gothic, monospace">    /// </summary></font></div> <div><font face="ms gothic, monospace">    public class ConnectionStringHelper: IConnectionString {</font></div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace">        /// <summary></font><font face="ms gothic, monospace">        /// $B%G!<%?%Y!<%9$X$N@\B3J8;zNs$r<hF@$9$k(B</font></div> <div><font face="ms gothic, monospace">        /// </summary></font></div> <div><font face="ms gothic, monospace">        /// <returns>$B@\B3J8;zNs(B</returns></font></div> <div><font face="ms gothic, monospace">        public string GetConnectionString() {</font></div> <div><font face="ms gothic, monospace">            SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();</font></div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace">            builder.ApplicationName = "xxx";</font></div> <div><font face="ms gothic, monospace">            builder.DataSource      = string.Format("tcp:{0},{1}", Properties.Settings.Default.DatabaseDataSource, Properties.Settings.Default.DatabasePort);</font></div> <div><font face="ms gothic, monospace">            builder.InitialCatalog  = Properties.Settings.Default.DatabaseInitialCatalog;</font></div> <div><font face="ms gothic, monospace">            builder.UserID          = Properties.Settings.Default.DatabaseUserID;</font></div> <div><font face="ms gothic, monospace">            builder.Password        = DecryptPassword(Properties.Settings.Default.DatabasePassword);</font></div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace">            return builder.ConnectionString;</font></div> <div><font face="ms gothic, monospace">        }</font></div> <div style="font-family:'ms gothic',monospace">}</div> </div> <div style="font-family:'ms gothic',monospace"><br> </div> <div style="font-family:'ms gothic',monospace"> <br> </div> <div style="font-family:'ms gothic',monospace">$B$3$l$G@8@.$5$l$k@\B3J8;zNs(B $B$O(B</div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace">Data Source=tcp:localhost\SQLEXPRESS,1433;Initial Catalog=xxx;User ID=xxx;Password=xxx;Application Name=xxx</font><br> </div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace">$B$H$J$C$F$$$^$9!#(B</font></div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace">$B$4;29M$^$G$K!#(B</font></div> <div><font face="ms gothic, monospace"><br> </font></div> <div><font face="ms gothic, monospace"><br> </font></div> </div> </div> <div class="gmail_extra"><br> -- <br> <div dir="ltr">$BC]Fb(B $B3X(B <mailto:<a moz-do-not-send="true" href="mailto:mtakeuchi@ailesys.co.jp" target="_blank">mtakeuchi@ailesys.co.jp</a>><br> $B3t<02q<R%(!<%k%7%9%F%`(B<br> $B")(B384-0083 $BD9Ln8)>.=t;TBg;z;T(B665-9<br> Phone: 0267-25-5990<br> Facsimile: 0267-26-1324</div> </div> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ seasar-dotnet mailing list <a class="moz-txt-link-abbreviated" href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a> <a class="moz-txt-link-freetext" href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a> </pre> </blockquote> <pre wrap="">$B8^==Mr$G$9!#(B $B%a!<%k$rAw$C$?D>8e$K2a5n$N%9%l%C%I$+$i8+$D$1$^$7$?!#(B <a class="moz-txt-link-freetext" href="http://ml.seasar.org/archives/seasar-dotnet/2012-August/002187.html">http://ml.seasar.org/archives/seasar-dotnet/2012-August/002187.html</a> 2014$BG/(B3$B7n(B28$BF|(B 9:18 $B8^==MrBg;N(B <a class="moz-txt-link-rfc2396E" href="mailto:igarashi.h@apps.buildsystem.jp"><igarashi.h@apps.buildsystem.jp></a>: </pre> <blockquote type="cite"> <pre wrap="">$B8^==Mr$G$9!#(B $B0JA0!"@\B3J8;zNs$NCf$K2~9T$,$"$k$H@\B3$G$-$J$$$H$NEj9F$,$"$C$?5$$,$7$^$9!#(B</pre> </blockquote> <pre wrap=""> </pre> <blockquote cite="mid:CAPNzMobPCmpj9oibWc=T1scydNcU0YYU_WD20LQXUxW9ZPw=7w@mail.gmail.com" type="cite"> <div>provider$B$H(BconnectionString$B$NJQ99$@$1$G!"(B</div> <div>$BJLES(Bdll$BEy$OI,MW$J$$$H;W$$$^$9!#(B</div> <div><br> </div> <div>SQLServer2005$B$N(BC/S$B%7%9%F%`$G$7$+:#3NG'$G$-$J$$$N$G$9$,!"(B</div> <div>$B$4;XDj$N@\B3J8;zNs$GJL(BPC$B$+$i@\B3$G$-$^$7$?!#(B</div> <div><br> </div> <div>SqlConnection$B$rD>@\(B</div> </blockquote> <pre wrap=""> 2014-03-27 19:38 GMT+09:00 $B;V?e@59,(B <a class="moz-txt-link-rfc2396E" href="mailto:ie2m-smz@asahi-net.or.jp"><ie2m-smz@asahi-net.or.jp></a>: </pre> <blockquote type="cite"> <pre wrap="">$B$*@$OC$K$J$C$F$*$j$^$9!#(B $B;V?e$H?=$7$^$9!#(B ASP.NET$B$G3+H/$7$F$$$k$N$G$9$,!"(B ORACLE$B@\B3$7$F$$$?%W%m%8%'%/%H$r(BSQLServer$B@\B3$KJQ99$7$F$$$^$9!#(B $B$7$+$7!"$I$&$K$b@\B3$G$-$:%(%i!<$H$J$C$F$7$^$$(B $B$9$C$+$j%O%^$C$F$7$^$$$^$7$?(BOrz $B2?$,$$$1$J$$$N$+!"$I$J$?$+$4;XE&$$$?$@$1$?$i$H;W$$$^$9!#!#(B $BJQ992U=j$O(BdataSources$BItJ,$@$1$G$$$$$H;W$C$?$N$G$9$,(B $B#O#R#A#C#L#E$N>l9g$O!"(BOracle.DataAccess$B$N#D#L#L$N;2>H$,I,MW$G$7$?$,!"(B SQLServer$B$b2?$+I,MW$J$N$G$7$g$&$+!)(B $B$A$J$_$K0J2<$N@_Dj$G%/%i%$%"%s%H$+$i!"(Bdbflute$B$N%P%C%A$G%F!<%V%k@8@.$G$-(B $B$^$9!#(B map:{ ; driver = com.microsoft.sqlserver.jdbc.SQLServerDriver ; url = jdbc:sqlserver://192.168.1.49:1433;databaseName=db_11; ; schema = dbo ; user = user11 ; password = passwd ; propertiesMap = map:{includeSynonyms=true} ; variousMap = map:{ ; objectTypeTargetList=list:{TABLE;VIEW;SYNONYM} ; tableExceptList = list:{prefix:MLOG$_} } } $B%/%i%$%"%s%H$N#A#c#c#e#s#s$+$i#O#D#B#C7PM3$G@\B3$b$G$-$^$7$?!#(B $B$G$b!"?4G[$J$N$GG0$N$?$a#D#B%5!<%P>e$N#I#I#S$K%"%W%j$r@_CV$7$FF0:n$5$;$F(B $B$_$^$7$?$,!"F1$8$h$&$K@\B3%(%i!<$K$J$j$^$7$?!#(B $B!Z4D6-![(B $B3+H/(BOS:Windows7 64bit DB$B%5!<%P(B:Windows2008std .NET ASP C# FrameWork4.0 SqlServer2012 Quill(s2container.net-1.4.0) dbflute-0.8.9.54 $B!Z%(%i!<%a%C%;!<%8![(B $B>l=j(B Seasar.Framework.Util.DataSourceUtil.GetConnection(IDataSource dataSource) [NextException] System.Data.DataException $B%3%M%/%7%g%s$N%*!<%W%s$K<:GT$7$^$7$?!#%G!<%?%Y!<%9$O5/F0$7$F$$$k$+!)@\B3(B $BJ8;zNs!"%W%m%P%$%@$N@_Dj$O@5$7$$$+!)$43NG'$r$*4j$$$7$^$9!#(B [NextNextException] System.Data.SqlClient.SqlException SQL Server $B$X$N@\B3$r3NN)$7$F$$$k$H$-$K%M%C%H%o!<%/4XO"$^$?$O%$%s%9%?%s(B $B%98GM-$N%(%i!<$,H/@8$7$^$7$?!#%5!<%P!<$,8+$D$+$i$J$$$+%"%/%;%9$G$-$^$;(B $B$s!#%$%s%9%?%s(B $B%9L>$,@5$7$$$3$H!"$*$h$S(B SQL Server $B$,%j%b!<%H@\B3$r5v2D(B $B$9$k$h$&$K9=@.$5$l$F$$$k$3$H$r3NG'$7$F$/$@$5$$!#(B (provider: SQL Network Interfaces, error: 26 - $B;XDj$5$l$?%5!<%P!<$^$?$O%$%s%9%?%s%9$N0LCV$rFCDj(B $B$7$F$$$k$H$-$K%(%i!<$,H/@8$7$^$7$?(B) ErrorCode = -2146232060 $B!Z(BQuill.config$B$N@\B3J8;zNs![(B <dataSources> <dataSource name="WebDS">$B!!"+$3$N%G!<%?%=!<%9$rFI$s$G$$$k$N$O3NG':Q$_(B <provider>SqlServer</provider> <connectionString>"Data Source=192.168.1.49\MSSQLSERVER;database=db_11;User ID=user11;Password=passwd"</connectionString> <class>Seasar.Extension.Tx.Impl.TxDataSource</class> </dataSource> </dataSources> $B!!!!"*(B"Server=192.168.1.49\MSSQLSERVER;Database=db_11;User ID=user11;Password=passwd" $B!!!!!!",",",@\B3J8;zNs$b$?$a$7$^$7$?$,%@%a$G$7$?",",",(B $B!!!!"*(BIntegratedSecurity=true$B$D$1$?$i%5%]!<%H$5$l$F$$$J$$$C$FE\$i$l$^$7$?!#(B $B!!!!"*(B192.168.1.49$B$N8e$m$N!V(B\$B!W$r!V(B\\$B!W$G$b;n$7$F$_$^$7$?$,F1$8%(%i!<$G$7$?!#(B <assemblys> <assembly>Seasar</assembly> <assembly>Seasar.Dao</assembly>   </assemblys> _______________________________________________ seasar-dotnet mailing list <a class="moz-txt-link-abbreviated" href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a> <a class="moz-txt-link-freetext" href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a> </pre> </blockquote> <pre wrap="">_______________________________________________ seasar-dotnet mailing list <a class="moz-txt-link-abbreviated" href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a> <a class="moz-txt-link-freetext" href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a> </pre> </blockquote> <br> </body> </html>