Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
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

Issue

  • 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.

Cause

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

Resolution

  • Specify a connection string using the standard OLEDB form.
    E.g., Provider=OraOLEDB.Oracle.1;Data Source=ework.sid;User Id=ework;Password=secret;
    or
    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.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!