Hi,
In preparation for a database change, I'm modifying a sql-pass through query to use a new ODBC Connection string.
When executed in sqlplus, the same query successfully returns records. But when executed in ACCESS97 and with Oracle ODBC driver 8.01.76, the query would fail and display the error:
ORA-2041: Client did not begin a transaction (#2041)
Some forums suggested to "disable the MTS" when I configure the DSN. This I've tried but it did not work. When I switched to Microsoft ODBC for Oracle, it worked. However, this solution is not preferred.
Does anyone have other suggestions to solve the error ?
Any help would be appreciated.
In preparation for a database change, I'm modifying a sql-pass through query to use a new ODBC Connection string.
When executed in sqlplus, the same query successfully returns records. But when executed in ACCESS97 and with Oracle ODBC driver 8.01.76, the query would fail and display the error:
ORA-2041: Client did not begin a transaction (#2041)
Some forums suggested to "disable the MTS" when I configure the DSN. This I've tried but it did not work. When I switched to Microsoft ODBC for Oracle, it worked. However, this solution is not preferred.
Does anyone have other suggestions to solve the error ?
Any help would be appreciated.
