Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

Metastorm BPM forums
Sign up Latest Topics

  Author   Comment  

Avatar / Picture

Posts: 5,507
Reply with quote  #1 

Error When Using ODBC Connection String

Last edited: 21 Oct 2004

The information in this article applies to product: e-Work 6.x


  • An attempt is made to issue a SQL query against an external database (e.g. using a function such as %ExecSQL). The query contains a reference to a datetime expressed using a standard ODBC timestamp escape sequence. E.g., the query has a WHERE clause such as 'WHERE DeliveryDate < {d '2004-11-01'}' The external database query fails with an error similar to the following: "Failed to process 'eExecuteSQL' e-Work Database Connector request. Unable to transform SQL statement with ODBC timestamp. Procedure ExecSQL call failed. Position: 308"

    This problem is exhibited using both Microsoft SQL Server and Oracle DBMSs.


  • The issue arises due to specifying a database connection string in standard ODBC form.
    E.g., DSN=eworkdsn;UID=ework;PWD=secret;


  • Specify a connection string using the standard OLEDB form.
    E.g., Provider=OraOLEDB.Oracle.1;Data Source=ework.sid;User Id=ework;Password=secret;
    Provider=SQLOLEDB;Data Source=EWORKSERVER;Initial Catalog=e-work;User ID=ework;Password=secret;Trusted_Connection=No;

Keywords: kb463

Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
Previous Topic | Next Topic

Quick Navigation:

Create your own forum with Website Toolbox!