Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Data Access Web Service
Message
From
08/02/2007 18:48:07
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Using Data Access Web Service
Environment versions
Environment:
VB 8.0
Miscellaneous
Thread ID:
01193925
Message ID:
01193925
Views:
68
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.
Next
Reply
Map
View

Click here to load this message in the networking platform