Enterprise Software Development

Archive for March, 2007

Webservice fix for error message - Maximum request length exceeded

19 March 2007

So I ran into a weird error this morning on one of my webservices. It was a SOAP exception which yielded a 500 HTTP Status error (as viewable from the trace.axd)
“There was an exception running the extensions specified in the config file. –> Maximum request length exceeded.”
The WebService call was posting a DataSet to a [...]

Utilizing SQL 2005 Linked Server to connect to external systems via OLE DB

10 March 2007

You can utilize MS SQL Server 2005’s Linked Servers ability to connect to any OLE DB provider. Here we are connecting to an iSeries (AS/400) DB2 using the IBMDA400 ole db provider
Here is the command to add a linked server:
EXEC master.dbo.sp_addlinkedserver
  @server = N'MYSERVER',
  @srvproduct=N'IBMDA400',
  @provider=N'IBMDA400',
  @datasrc=N'MYSERVER',
  @provstr=N'Transport Product=Client Access;
    Force Translate=0;
    DATA SOURCE=MYSERVER;
    USER ID=MYUSERID;
    PASSWORD=MYPASSWORD;
    Connect Timeout=30;'
You’ll notice the Force Translate is set [...]