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!
Hello,
You will need to turn off the property that auto executes the procedures on generation and have to execute the generated procedures manually.
Blake Niemyjski CodeSmith Tools, LLC. Software Development Engineer Blog: http://windowscoding.com/blogs/blake/ .NetTiers team | Visit http://www.nettiers.net
Here is my csp file
http://sdrv.ms/JAP3zd
This has been fixed in the latest nightly build of the .netTiers templates (community.codesmithtools.com/.../NetTiers)