Some commonly found problems are listed below.

 

The most common problems relate to the set up of IIS and Framework 2.0

please ensure you have read the Getting Started guide and have configured IIS and Framework2.0 of ASP.NET correctly.

 

Q. My Designer for Web services tests work but my generated Web Service won't return data.

 

A. This is probably due to your web security settings, the Designer for Web Services Tests are

carried out in the Windows environment , when you try to access via the Web you can have problems

if you haven't set up ASP.NET settings correctly.

 

One common problem when accessing ,for example SQL Server from a Web service, is that the user ASPNET has not been set up to access the server.Depending on the security settings you have defined in the connection string you may have to grant this user access rights to the relevant database and table, if not already set up to do so.

 

This can also be due in some cases because you have set up the query with the wrong Data Type.

Q. I have created my project and all the tests work but I get an error when I try to generate the Web Service.

 

A. This can be due to a number of factors. Refer to the prerequisites section and check you have the software required to use this product.

 

Have you installed Framework 2.0?

 

If you have the 'Register with IIS' box checked then you need to ensure you have IIS installed as well.

 

You need to check that the destination folder for the web service is accessible by IIS (the web server). If you have chosen a destination folder that is in your own personal space, such as My Documents, IIS will not be able to access the generated web services. Good practice is to create a c:\WebServices folder, and create a subfolder for each of your web services, i.e. c:\WebServices\MyWebService01\.

 

Q. I have followed the instructions above but when I try and generate my Web Service and click Yes to view it I get an error when trying to access or run the Web Service.

 

A. If you are using IIS you will need to ensure that IIS is set up correctly. Go to control panel > admin. tools>Internet information Services and check that your Web Service has been created.Check the IIS Service is running. If all seems o.k then you may need to run the command aspnet_regiis -i from the Windows command prompt, if you have just installed IIS.If you still have problems you will need to refer to Microsoft's documentation on setting up IIS. See the Getting Started Guide for more detail on how to run the command aspnet_regiis -i for your operating system.

 

Q. Can I use Stored Procedures?

 

A. Yes , see Using Stored Procedures to find out how.

 

Q. I'm having trouble connecting to an Access Query file. It's expecting a parameter but my Query doesn't have a parameter specified.

 

A. You need to treat the Access Query like you would a Stored Procedure instead of a Stored Procedure name though enter the name of your Access Query.

 

Q. I have used the Simple Query Wizard to access a Table and I get the following error, why?

 

A. Unfortunately if the Table name contains a non-standard character, as in the example above (dbo.Order Details), which contains a space, you cannot select the Table using the Simple Query Wizard , you will have to enter the Table name enclosed with square brackets manually [dbo.Order Details].In the case of Excel worksheets whose names are followed by the $ character, this method must also be used.

 

Q. I have defined a connection to a data source and tested the connection works but when I try and select the tables or files using the Simple Query wizard or manually enter the SQL string I cannot connect to my Table/File.  

 

A. It's worth noting here that the Datasource connection in DWS connects to the driver not directly to the data source itself. If for example you wanted to connect to an iSeries and your files were in a specific library,even if your data source ( for example Client Access ODBC) is specified to use that library , when you connect using DWS it will not necessarily be connecting using the desired library or location.

ODBC driver connections for some providers do not provide the facility to enter the path or library to your table/file.

The solution to this is to either set up a FILEDSN connection where you can specify the File and Its location or in the case of a connection to an iSeries using a Client Access ODBC Datasource connection you can enter the SQL statement SELECT ~col1~ FROM Libraryname.FileName  this will then connect to the library and file name you require.

 

If you are still having problems with the Product or need any assistance then send and e.mail to Flynet's Technical support at support@flynetviewer.com