| |
|
Data Dynamics Analysis Support
Started by kiran3010p at 09-17-2010 1:49 AM. Topic has 2 replies.
  
|
|
Sort Posts:
|
|
|
|
 09-17-2010, 1:49 AM
|
kiran3010p
Joined on 08-05-2010
Hyderabad
Posts 3
|
New to Data Dynamics-how to create schema?
|
|
|
|
|
Hello,
I m new to this Data Dynamics.
I m using SqlServer2005.
with the fallowing command
DataDynamics.Analysis.SchemaGenerator -c "Provider=SQLOLEDB;Initial Catalog=HA126_New;Data Source=sileru;User Id=sa;Password=lsi" -q "select id,first_name,last_name from patient;" -p "OLE DB" "c:\TEST.schema"
in command prompt I come to know
the creation of scema.
But I m not able to create schema.
Plz help me..
Regards,
Kiran P
|
|
|
|
|
Report
|
|
|
|
|
09-20-2010, 7:12 AM
|
AashishB
Joined on 12-11-2008
Posts 818
|
Re: New to Data Dynamics-how to create schema?
|
|
|
|
|
|
Kiran,
Do you get any error message while running the above command in DOS command prompt? I would suggest you to change the Provider to "SQLOLEDB" from "OLE DB" and then try to create the schema. Also take a look at this KB article.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
10-29-2010, 8:27 AM
|
mogens
Joined on 09-10-2003
Oslo
Posts 1
|
Re: New to Data Dynamics-how to create schema?
|
|
|
|
|
|
IDbConnection dbcon = new OleDbConnection(constr);
dbcon.Open();
GrapeCity.ActiveAnalysis.DataSources.RdDataSource datasource = new GrapeCity.ActiveAnalysis.DataSources.RdDataSource();
datasource.ConnectionType = GrapeCity.ActiveAnalysis.DataSources.ConnectionType.OleDb;
datasource.ConnectionString = constr;
datasource.QueryString = sql;
System.IO.FileInfo myAutoSchema = new System.IO.FileInfo(@"C:\temp\MyAutoSchema.schema");
GrapeCity.ActiveAnalysis.Schema.SchemaBuilder sb = GrapeCity.ActiveAnalysis.Schema.SchemaBuilder.AutoGenerate("The Schema Name", dbcon, sql);
sb.SaveSchema( myAutoSchema );
datasource.CustomSchemaFile = myAutoSchema.FullName;
datasource.Connect();
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Re: New to Data Dynamics-how to create schema?
|
|
|
|
|