Please take care when selecting Data types, warning messages have been added to send alerts if specified data types do not match.The Test may well work when processed in DWS , this is because it is being run as a Windows Application, you may experience errors when running as a Web Service as this is now an ASP.NET application.The basic rule should be if you are in doubt as to what data type to use, then in most cases you should choose Object as the data type.See the Table below for a list of recommended Data Types.

 

 

Specifying Data Types.

Due to the restrictions on what data types are supported by OLEDB and ODBC , a feature has been added to the Designer for Web Services to cater for this.

 

Previously unsupported data types, such as datetime now come under the generic data type of object.

 

Using the Northwind database in SQL server as an example , use the Simple Query wizard to create a query based on the Orders table , refer to the SQL String Definition section if needed.

 

Select Order ID, and Order Date for the Orders table, the column names will be returned to the Designer for Web Services query grid as shown below:

 

Note the new data type of object.

 

If you hit the Test button then the following message box will appear,this is for information only just click OK to continue.

 

Once you have clicked OK the data will be returned from the database as shown below, the Order Date is returned as follows.

 

The following table is a guideline on what data types can be used, the length of numeric Data types may determine which data type is best to use.