hi,
i'm tryng to use .netTiers with my Oracle server i use this connection string:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=prio;Password=xx;
When I try to generate this error is returned
Error while execution Sql file. System.ArgumentException: The length of the value for key 'data source' exceeds limit of "128".
in System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
in System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
in System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
in System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
in System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
in System.Data.SqlClient.SqlConnection..ctor(String connectionString)
in MoM.Templates.CommonSqlCode.ExecuteSqlInFile(String pathToScriptFile, String connectionString) in c:\Users\riccardo.barbi\Documents\CodeSmith Generator\Samples\v6.0\Templates\Frameworks\NetTiers\TemplateLib\CommonSqlCode.cs:riga 5204
in _CodeSmith.NetTiers_cst.Go() in c:\Users\riccardo.barbi\Documents\CodeSmith Generator\Samples\v6.0\Templates\Frameworks\NetTiers\NetTiers.cst:riga 1914
And no SQL Command for stored procedures is generated
Please help me! tanks!
Here is my csp file
http://sdrv.ms/JAP3zd
Hello,
This has been fixed in the latest nightly build of the .netTiers templates (community.codesmithtools.com/.../NetTiers)
Blake Niemyjski CodeSmith Tools, LLC. Software Development Engineer Blog: http://windowscoding.com/blogs/blake/ .NetTiers team | Visit http://www.nettiers.net