Publish Web site with gridview - datasource an Entity Model
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
Publish Web site with gridview - datasource an Entity Model
Hello, I'm new in DevArt and i'm tryng to publish a simply web site with e gridview that has as datasource an entytymodel that use a db Oracle on Windows Server 2008. I've done all I read in this forum, I've put in web.config:
And i've add all the dll in the bin folder, however, when i try to see the page that contain the gridview there is the error:
Schema specified is not valid. Errors:
Devart.Data.Oracle.Entity.StoreSchemaDefinition.ssdl(2,69) : error 0169: All SSDL artifacts must target the same provider. The ProviderManifestToken 'ORA' is different from 'Ora10gR2' that was encountered earlier.
But really, I've installed Oracle - OraClient10g_home1 in both of pc!!!
How can i do???
Please, helpme!!
And i've add all the dll in the bin folder, however, when i try to see the page that contain the gridview there is the error:
Schema specified is not valid. Errors:
Devart.Data.Oracle.Entity.StoreSchemaDefinition.ssdl(2,69) : error 0169: All SSDL artifacts must target the same provider. The ProviderManifestToken 'ORA' is different from 'Ora10gR2' that was encountered earlier.
But really, I've installed Oracle - OraClient10g_home1 in both of pc!!!
How can i do???
Please, helpme!!
We are unable to reproduce this error.
The similar one was reported here:
http://devart.com/forums/viewtopic.php?t=14222,
but it was resolved simply by recreating the model.
Try to delete the model from your project and re-add it. This should help.
The similar one was reported here:
http://devart.com/forums/viewtopic.php?t=14222,
but it was resolved simply by recreating the model.
Try to delete the model from your project and re-add it. This should help.
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
Hello, i've solved my problem installing devart on server. It's not exactly what I wanted but it is the same.
Now I have another problem, I've created an ado .net entity model (called model.edmx) in my site web and I have to change the connection string dinamically. How can i do?? Is it possible usiing devart? Thanks, Silvia
Now I have another problem, I've created an ado .net entity model (called model.edmx) in my site web and I have to change the connection string dinamically. How can i do?? Is it possible usiing devart? Thanks, Silvia
1. The 0169 error occurs rarely. It is fixed now and will be included in the next build. As a workaround, please change the ProviderManifestToken attribute of the Schema tag from "Ora10gR2" to "ORA".
2. If you want to change the connection string dynamically, it is necessary to remove the Schema attributes and the DefiningQuery tags from the SSDL part of the EDMX file. This allows you to create the instance of the ObjectContext class by passing the connection string you want as a parameter of a constructor.
2. If you want to change the connection string dynamically, it is necessary to remove the Schema attributes and the DefiningQuery tags from the SSDL part of the EDMX file. This allows you to create the instance of the ObjectContext class by passing the connection string you want as a parameter of a constructor.
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
I've created an ado .net entity model (called model.edmx) in my site web and I have to change the connection string of that dinamically. After that I have a gridview that has, like datasource, an entitydatasource linked to model. When the connection string of the model change i want that data in gridview change automatically, becose it's linked to an entitydatasource that is linked with model.edmx. How can i do?? The web site is a visual basic web site.
I try this way:
Dim connectionString = "metadata=res://*;provider=Devart.Data.Oracle;provider connection string=""User Id=***;Password=***;Server=***;Sid=***;Persist Security Info=True"""
Dim ctxt As New TestEntities(connectionString)
Me.GridView1.DataBind()
But it doesn't work!!!
Thanks,
Silvia
I try this way:
Dim connectionString = "metadata=res://*;provider=Devart.Data.Oracle;provider connection string=""User Id=***;Password=***;Server=***;Sid=***;Persist Security Info=True"""
Dim ctxt As New TestEntities(connectionString)
Me.GridView1.DataBind()
But it doesn't work!!!
Thanks,
Silvia
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43
Now i've try to put, in the page_load:
Dim connectionString = "metadata=res://*;provider=Devart.Data.Oracle;provider connection string=""User Id=***;Password=***;Home=OraClient10g_home1;Direct=True;Sid=***;Port=****;Persist Security Info=True"""
Using conn As New Entities(connectionString)
Me.GridView1.DataBind()
End Using
But it says:
Schema specificato non valido. Errori: TestEDM.App_Code.Model.ssdl(2,76) : errore 0169: Tutti gli elementi SSDL devono utilizzare lo stesso provider. ProviderManifestToken 'Ora10gR2' diverso da 'ORA', rilevato in precedenza.
WHY??? Please, help me!!!
Silvia
Dim connectionString = "metadata=res://*;provider=Devart.Data.Oracle;provider connection string=""User Id=***;Password=***;Home=OraClient10g_home1;Direct=True;Sid=***;Port=****;Persist Security Info=True"""
Using conn As New Entities(connectionString)
Me.GridView1.DataBind()
End Using
But it says:
Schema specificato non valido. Errori: TestEDM.App_Code.Model.ssdl(2,76) : errore 0169: Tutti gli elementi SSDL devono utilizzare lo stesso provider. ProviderManifestToken 'Ora10gR2' diverso da 'ORA', rilevato in precedenza.
WHY??? Please, help me!!!
Silvia
You didn't assign a value to the GridView1.DataSource property. For example:
As for the 0169 error, please look forward to the next build of dotConnect for Oracle if our workaround mentioned above doesn't help.
Code: Select all
Dim ctxt As New TestEntities(connectionString)
Me.GridView1.DataSource = from k in ctxt.Objects
select k
Me.GridView1.DataBind()
-
- Posts: 13
- Joined: Thu 28 May 2009 15:43