Hi,
I'm currently trying to create a .NetTiers project that will connect to an Access Database for one of our legacy applications.I am using the following connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\Public\exchange\Dept_BSD\James\ws32_sta.mdb;
with the ADOXSchemaProvider. I have created a view in the Access database thatI need to get data from. However, when I try and generate the .NetTiers code for the AccessDb I get the following error:
System.NotSupportedException: GetViewColumns() is not supported with this provider.
at SchemaExplorer.ADOXSchemaProvider.GetViewColumns(String connectionString, ViewSchema view)
at SchemaExplorer.ViewSchema.get_Columns()
at _CodeSmith.NetTiers_cst.SystemDataOleDbProcedures.__RenderMethod1(TextWriter writer, Control control) in c:\Documents and Settings\jrstrachan\My Documents\CodeSmith\Templates\nettiers-fx2.2-20080215-rev702\DataAccessLayer.GenericClient\System.Data.OleDb.Procedures.cst:line 624
at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
at CodeSmith.Engine.Control.Render(TextWriter writer)
at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, Boolean overwrite)
at _CodeSmith.NetTiers_cst.RenderToFile(String templateName, String path, Boolean overwrite) in c:\Documents and Settings\jrstrachan\My Documents\CodeSmith\Templates\nettiers-fx2.2-20080215-rev702\NetTiers.cst:line 622
at _CodeSmith.NetTiers_cst.Go() in c:\Documents and Settings\jrstrachan\My Documents\CodeSmith\Templates\nettiers-fx2.2-20080215-rev702\NetTiers.cst:line 1701
at _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control control) in c:\Documents and Settings\jrstrachan\My Documents\CodeSmith\Templates\nettiers-fx2.2-20080215-rev702\NetTiers.cst:line 4377
at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
at CodeSmith.Engine.Control.Render(TextWriter writer)
at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
at CodeSmith.Engine.CodeTemplate.RenderToString()
at CodeSmith.Gui.CodeTemplateGenerator.f(Object A_0, EventArgs A_1)
Is there a way to set up a connection so I can see the views in an Access DB?
Cheers