Screns

[Jose Eduardo]

Ryan,

The screens of Visual Studio 2008 with the www.data and www.interface. See if this all right.

Thank you.

Eduardo

[Ryan Gahl]

Does the "GetXMLDefinition" method exist in that service?

--
Ryan Gahl
Manager, Senior Software Engineer
Nth Penguin, LLC
http://www.nthpenguin.com
--
WebWidgetry.com / MashupStudio.com
Future Home of the World's First Complete Web Platform
--
Inquire: 1-920-574-2218
Blog: http://www.someElement.com
LinkedIn Profile: http://www.linkedin.com/in/ryangahl

[Jose Eduardo]

Ryan,

The method GetXMLDefinition exists in the service and returns the following value

=====================

<?xml version="1.0" encoding="utf-8" ?>

- <ServiceCallResult xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">

  <Success>true</Success>

  <LoggedIn>true</LoggedIn>

  <Message />

- <SessionInfo>

  <TimeoutInMilliseconds>1200000</TimeoutInMilliseconds>

  </SessionInfo>

  <Result xsi:type="xsd:string"><?xml version="1.0" encoding="utf-8" ?> <model namespace="test.ControleAcesso" name="ControleAcesso"> <objects> <object name="Modulo" collectionName="ModuloCollection"> <initialSchema pluralName="Modulos"> <table name="Modulos" tree="false" displayName="Modulos" readOnly="false" searchable="false" /> <relations> <relation objectName="Sistema" /> <relation objectName="Usuario" /> </relations> <pks> <pk columnName="CodModulo" /> </pks> <columns> <column name="CodModulo" displayName="Cod Modulo" type="int32" editable="false" /> <column name="CodUsuario" displayName="Cod Usuario" type="int32" fktablename="Usuario" fktabledisplayname="Usuarios" /> <column name="CodSistema" displayName="Cod Sistema" type="int32" fktablename="Sistema" fktabledisplayname="Sistemas" /> <column name="NomeModulo" displayName="Nome Modulo" type="byte[]" /> <column name="DescricaoModulo" displayName="Descricao Modulo" type="text" /> <column name="Ativo" displayName="Ativo" type="boolean" /> </columns> </initialSchema> </object> <object name="Pagina" collectionName="PaginaCollection"> <initialSchema pluralName="Paginas"> <table name="Paginas" tree="false" displayName="Paginas" readOnly="false" searchable="false" /> <relations> <relation objectName="Modulo" /> </relations> <pks> <pk columnName="CodPagina" /> </pks> <columns> <column name="CodPagina" displayName="Cod Pagina" type="int32" editable="false" /> <column name="CodModulo" displayName="Cod Modulo" type="int32" fktablename="Modulo" fktabledisplayname="Modulos" /> <column name="CodUsuario" displayName="Cod Usuario" type="int32" /> <column name="NomePagina" displayName="Nome Pagina" type="string" maxLength="255" /> <column name="NomeVisualizacao" displayName="Nome Visualizacao" type="string" maxLength="255" /> <column name="Insercao" displayName="Insercao" type="boolean" /> <column name="Alteracao" displayName="Alteracao" type="boolean" /> <column name="Exclusao" displayName="Exclusao" type="boolean" /> <column name="Visualizacao" displayName="Visualizacao" type="boolean" /> <column name="Impressao" displayName="Impressao" type="boolean" /> <column name="Ativo" displayName="Ativo" type="boolean" /> </columns> </initialSchema> </object> <object name="Sistema" collectionName="SistemaCollection"> <initialSchema pluralName="Sistemas"> <table name="Sistemas" tree="false" displayName="Sistemas" readOnly="false" searchable="false" /> <relations> </relations> <pks> <pk columnName="CodSistema" /> </pks> <columns> <column name="CodSistema" displayName="Cod Sistema" type="int32" editable="false" /> <column name="NomeSistema" displayName="Nome Sistema" type="int32" /> <column name="Descricao" displayName="Descricao" type="text" /> <column name="Redirecionamento" displayName="Redirecionamento" type="text" /> <column name="Ativo" displayName="Ativo" type="boolean" /> </columns> </initialSchema> </object> <object name="Usuario" collectionName="UsuarioCollection"> <initialSchema pluralName="Usuarios"> <table name="Usuarios" tree="false" displayName="Usuarios" readOnly="false" searchable="false" /> <relations> </relations> <pks> <pk columnName="CodUsuario" /> </pks> <columns> <column name="CodUsuario" displayName="Cod Usuario" type="int32" editable="false" /> <column name="Login" displayName="Login" type="string" maxLength="30" /> <column name="Senha" displayName="Senha" type="string" maxLength="30" /> <column name="NomeUser" displayName="Nome User" type="byte[]" /> <column name="Ativo" displayName="Ativo" type="boolean" /> </columns> </initialSchema> </object> <object name="UsuarioSistema" collectionName="UsuarioSistemaCollection"> <initialSchema pluralName="UsuarioSistemas"> <table name="UsuarioSistema" tree="false" displayName="UsuarioSistema" readOnly="false" searchable="false" /> <relations> <relation objectName="Sistema" /> <relation objectName="Usuario" /> </relations> <pks> <pk columnName="CodUsuarioSistema" /> </pks> <columns> <column name="CodUsuarioSistema" displayName="Cod Usuario Sistema" type="int32" editable="false" /> <column name="CodUsuario" displayName="Cod Usuario" type="int32" fktablename="Usuario" fktabledisplayname="Usuarios" /> <column name="CodSistema" displayName="Cod Sistema" type="int32" fktablename="Sistema" fktabledisplayname="Sistemas" /> <column name="DataCriacao" displayName="Data Criacao" type="datetime" /> </columns> </initialSchema> </object> <object name="UsuariosModulo" collectionName="UsuariosModuloCollection"> <initialSchema pluralName="UsuariosModulos"> <table name="UsuariosModulos" tree="false" displayName="UsuariosModulos" readOnly="false" searchable="false" /> <relations> <relation objectName="Modulo" /> <relation objectName="Usuario" /> </relations> <pks> <pk columnName="CodUsuarioModulo" /> </pks> <columns> <column name="CodUsuarioModulo" displayName="Cod Usuario Modulo" type="int32" editable="false" /> <column name="CodUsuario" displayName="Cod Usuario" type="int32" fktablename="Usuario" fktabledisplayname="Usuarios" /> <column name="CodModulo" displayName="Cod Modulo" type="int32" fktablename="Modulo" fktabledisplayname="Modulos" /> <column name="Insercao" displayName="Insercao" type="boolean" /> <column name="Alteracao" displayName="Alteracao" type="boolean" /> <column name="Exclusao" displayName="Exclusao" type="boolean" /> <column name="Visualizacao" displayName="Visualizacao" type="boolean" /> <column name="Impressao" displayName="Impressao" type="boolean" /> </columns> </initialSchema> </object> </objects> </model></Result>

  </ServiceCallResult>

 

=====================

 

Eduardo

 

 

==========================================================

2008/10/27 Ryan Gahl <ryan...@nthpenguin.com>

[Ryan Gahl]

Hmm. OK. Try this... close all instances of Visual Studio, and if you are running your service in IIS, stop that website in IIS Manager... then browse to "C:\temp" and delete all the .dll files (make sure all them go away). If it doesn't let you delete them all (due to some process hanging on to them), you might have to log off and back on to delete them all.

Once those are all deleted, start your web service back up again, and then try again with WW.Interface...

It seems like it's possible that you had, at one time, generated this back end with a previous version of WW.DataServices, and that dynamic assembly got cached...

Let me know if that helps.

-Ryan

[Jose Eduardo]

Morning Ryan!

I tried to do what you suggested me for the folder "c: / Temp", but did not work.
Now I'm not on my computer where I have the projects, here I have a project to test it configured the same way. The error and the same!

Attn

Eduardo

 

========================================

2008/10/27 Ryan Gahl <ryan...@nthpenguin.com>

[Ryan Gahl]

Sorry about this, Jose. I'm not sure yet what the problem is. I'll try to reproduce this on my end to see if I can figure it out...

[Jose Eduardo]

Ok, Ryan!

As you have an answer to the problem let me know, I will be waiting.

att.

Eduardo

 

==========================================================

2008/10/28 Ryan Gahl <ryan...@nthpenguin.com>

[Ryan Gahl]

Jose... I ran into a similar situation here now, but I'm not 100% sure it's the same problem you're having. Can you send me your database schema? I'd like to see if there are potentially any problems with "special" column names...

If you don't want to send me your schema... do a check through to see if you have any table or column or view names that seems like they might be special keywords... for instance "Data" or "UserName"...

Also... have you tried doing this with a different database yet? For example, Northwind? ...just to see if we can narrow the problem down.

[Jose Eduardo]

Ryan,

Tonight I sent you a diagram of the base. I am using a base rather than the standard specifies that guided you, because I never use a basic standard plug-ins and they should work for any kind of basis for SQLServer.

att.

Eduardo

 

 

=============================================

2008/10/28 Ryan Gahl <ryan...@nthpenguin.com>