<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 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$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 class="gmail_quote">2014$BG/(B3$B7n(B28$BF|(B 2:22 kubo <span dir="ltr"><<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>></span>:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">$B5WJ](B(jflute)$B$G$9(B<br> <br> $B;V?e$5$s!"$3$s$K$A$O!#(B<br> DBFlute.NET$B$4MxMQ$"$j$,$H$&$4$6$$$^$9!#(B<br> <br> <a href="http://xn--h9jep6j.NET" target="_blank">$B$A$g$C$H(B.NET</a>$B$G(BSQLServer$B$K$D$J$$$G$k4D6-$,<j85$K$J$$$N$G!"(B<br> $B8+$?$@$1$G$O9g$C$F$k$+$I$&$+ITL@$J$N$G$9$,!"(B<br> JDBC$B$H$+B>$+$i$&$^$/$$$C$F$k$H$$$&$3$H$O!"(B<br> $B$b$&(B Quill.config $B$N=q$-J}$H9M$($k$N$,<+A3$G$9$,(B...<br> <br> $B%]!<%HHV9f$C$F!";XDj$7$J$/$F$b(BOK$B$J$s$G$9$h$M!)(B<br> ($B0J2<$N%5%$%H$r;29M$K$7$?$@$1$G$9$,!"(B<br> $B?'!9$J=q$-J}$r;n$7$F$_$?$$$H$3$m$G$9$M(B)<br> <a href="http://shiba-yan.hatenablog.jp/entry/20110103/1294060564" target="_blank">http://shiba-yan.hatenablog.jp/entry/20110103/1294060564</a><br> <br> <br> # $B$I$J$?$+!"(B.NET$B$G(BSQLServer$B$K(BDB$B%"%/%;%9$5$l$F$$$kJ}$G!"(B<br> # $B!V@\B3J8;zNs$r$3$s$J46$8$G=q$$$F$k$h!W(B<br> # $B$_$?$$$J>pJs$"$j$^$7$?$i%3%a%s%HD:$1$k$H=u$+$j$^$9!#(B<br> <br> <br> <br> 2014-03-27 19:38 GMT+09:00 $B;V?e@59,(B <<a href="mailto:ie2m-smz@asahi-net.or.jp">ie2m-smz@asahi-net.or.jp</a>>:<br> <div class="HOEnZb"><div class="h5">> $B$*@$OC$K$J$C$F$*$j$^$9!#(B<br> > $B;V?e$H?=$7$^$9!#(B<br> ><br> > <a href="http://ASP.NET" target="_blank">ASP.NET</a>$B$G3+H/$7$F$$$k$N$G$9$,!"(B<br> > ORACLE$B@\B3$7$F$$$?%W%m%8%'%/%H$r(BSQLServer$B@\B3$KJQ99$7$F$$$^$9!#(B<br> > $B$7$+$7!"$I$&$K$b@\B3$G$-$:%(%i!<$H$J$C$F$7$^$$(B<br> > $B$9$C$+$j%O%^$C$F$7$^$$$^$7$?(BOrz<br> > $B2?$,$$$1$J$$$N$+!"$I$J$?$+$4;XE&$$$?$@$1$?$i$H;W$$$^$9!#!#(B<br> > $BJQ992U=j$O(BdataSources$BItJ,$@$1$G$$$$$H;W$C$?$N$G$9$,(B<br> > $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<br> > SQLServer$B$b2?$+I,MW$J$N$G$7$g$&$+!)(B<br> ><br> ><br> > $B$A$J$_$K0J2<$N@_Dj$G%/%i%$%"%s%H$+$i!"(Bdbflute$B$N%P%C%A$G%F!<%V%k@8@.$G$-(B<br> > $B$^$9!#(B<br> > map:{<br> > ; driver = com.microsoft.sqlserver.jdbc.SQLServerDriver<br> > ; url = jdbc:sqlserver://192.168.1.49:1433;databaseName=db_11;<br> > ; schema = dbo<br> > ; user = user11<br> > ; password = passwd<br> > ; propertiesMap = map:{includeSynonyms=true}<br> > ; variousMap = map:{<br> > ; objectTypeTargetList=list:{TABLE;VIEW;SYNONYM}<br> > ; tableExceptList = list:{prefix:MLOG$_}<br> > }<br> > }<br> > $B%/%i%$%"%s%H$N#A#c#c#e#s#s$+$i#O#D#B#C7PM3$G@\B3$b$G$-$^$7$?!#(B<br> > $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<br> > $B$_$^$7$?$,!"F1$8$h$&$K@\B3%(%i!<$K$J$j$^$7$?!#(B<br> ><br> ><br> > $B!Z4D6-![(B<br> > $B3+H/(BOS:Windows7 64bit<br> > DB$B%5!<%P(B:Windows2008std<br> ><br> > .NET ASP C# FrameWork4.0<br> > SqlServer2012<br> > Quill(s2container.net-1.4.0)<br> > dbflute-0.8.9.54<br> ><br> ><br> > $B!Z%(%i!<%a%C%;!<%8![(B<br> > $B>l=j(B Seasar.Framework.Util.DataSourceUtil.GetConnection(IDataSource<br> > dataSource)<br> ><br> > [NextException]<br> > System.Data.DataException<br> > $B%3%M%/%7%g%s$N%*!<%W%s$K<:GT$7$^$7$?!#%G!<%?%Y!<%9$O5/F0$7$F$$$k$+!)@\B3(B<br> > $BJ8;zNs!"%W%m%P%$%@$N@_Dj$O@5$7$$$+!)$43NG'$r$*4j$$$7$^$9!#(B<br> ><br> > [NextNextException]<br> > System.Data.SqlClient.SqlException<br> > SQL Server $B$X$N@\B3$r3NN)$7$F$$$k$H$-$K%M%C%H%o!<%/4XO"$^$?$O%$%s%9%?%s(B<br> > $B%98GM-$N%(%i!<$,H/@8$7$^$7$?!#%5!<%P!<$,8+$D$+$i$J$$$+%"%/%;%9$G$-$^$;(B<br> > $B$s!#%$%s%9%?%s(B $B%9L>$,@5$7$$$3$H!"$*$h$S(B SQL Server $B$,%j%b!<%H@\B3$r5v2D(B<br> > $B$9$k$h$&$K9=@.$5$l$F$$$k$3$H$r3NG'$7$F$/$@$5$$!#(B (provider: SQL Network<br> > Interfaces, error: 26 - $B;XDj$5$l$?%5!<%P!<$^$?$O%$%s%9%?%s%9$N0LCV$rFCDj(B<br> > $B$7$F$$$k$H$-$K%(%i!<$,H/@8$7$^$7$?(B)<br> > ErrorCode = -2146232060<br> ><br> ><br> > $B!Z(BQuill.config$B$N@\B3J8;zNs![(B<br> > <dataSources><br> > <dataSource name="WebDS">$B!!"+$3$N%G!<%?%=!<%9$rFI$s$G$$$k$N$O3NG':Q$_(B<br> > <provider>SqlServer</provider><br> > <connectionString>"Data<br> > Source=192.168.1.49\MSSQLSERVER;database=db_11;User<br> > ID=user11;Password=passwd"</connectionString><br> > <class>Seasar.Extension.Tx.Impl.TxDataSource</class><br> > </dataSource><br> > </dataSources><br> ><br> >$B!!!!(B $B"*(B"Server=192.168.1.49\MSSQLSERVER;Database=db_11;User<br> > ID=user11;Password=passwd"<br> >$B!!!!!!(B $B",",",@\B3J8;zNs$b$?$a$7$^$7$?$,%@%a$G$7$?",",",(B<br> ><br> >$B!!!!(B $B"*(BIntegratedSecurity=true$B$D$1$?$i%5%]!<%H$5$l$F$$$J$$$C$FE\$i$l$^$7$?!#(B<br> ><br> >$B!!!!(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<br> ><br> > <assemblys><br> > <assembly>Seasar</assembly><br> > <assembly>Seasar.Dao</assembly><br> > <br> > <br> > </assemblys><br> ><br> ><br> > _______________________________________________<br> > seasar-dotnet mailing list<br> > <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br> _______________________________________________<br> seasar-dotnet mailing list<br> <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br> <br> </div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">$BC]Fb(B $B3X(B <mailto:<a 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>