Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Data Access Web Service
Message
De
08/02/2007 18:48:07
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
Using Data Access Web Service
Versions des environnements
Environment:
VB 8.0
Divers
Thread ID:
01193925
Message ID:
01193925
Vues:
67
I am having problems getting the MM .NET Data Access Service to work. Here is what I have done:

1) Created Business Object Project (works with regular SQL access)
2) Created win form project (works with regular SQL access)
3) Created web data access service project.
4) Added web reference to BO
5) Overrode CreateDataAccessSql in win form project Factory.vb (gets called correctly)
6) added reference to MM Framework Web Services to BO and Win Form projects
7) Deployed web data access service project to web server (not local)
8) Logged on to remote web server and tested web service (works)
9) Changed Business object app.config
(added add key="DefaultDataAccessMode" value="webservice" )
10) Blocked SQL port (remote webserver outside firewall and still working)
11) Run program, Get SQL connection failure. It seems that the mmDataAccessWebServiceSql.cs eventually calls dataaccesssql from the local machine (not the webserver).
Additional info, the filldataset in mmDataAccessWebServiceSql.cs gets hit

I am not sure what I am missing.
Darrell

UPDATE:
Here is a little more information.
The override of CreateDataAccessSQL correctly returns the mmDataAccessWebServiceSql.
mmDataWebService.cs line 196 "this.DataAccessObject" is of type MM.Main.Data.mmDataAccessSql. Therefore when executing the FillDataSet method it attempts a call to the sql server rather than to the web service.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform