Problem with XNode and Access with ODBC

, ,
#1

Hello Guys ,

I have a Problem with XNode and Access with ODBC .
I always get a native error no matter how I try to define this schema to Tamino .
The name used by me is in System DNS because I can use it with another application .

RESPONSE Tamino Interactive Interface :

<?xml version="1.0" encoding="utf-8" ?>
- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“http://metalab.unc.edu/xql/”>
- <ino:message ino:returnvalue=“8505”>
<ino:messagetext ino:code=“INOXME8505”>ODBC error occurred</ino:messagetext>
ino:messagelineLine 8, Column 0: State: S1000 Native Error: 51 [Microsoft][ODBC Access 97 ODBC driver -Treiber]Allgemeiner Fehler. Registrierungsschl

#2

Seems like there is a problem with the ODBC DSN. This is not Tamino specific.

Now why can you use the DSN with another application, and Tamino cannot? Well there are some differences: While you start this other application by double-click or via the start menu, Tamino works in the background. You application has the user id and the regarding environment of the currently logged in user, while Tamino, by default is started with the system account (check this in Control Panel, Services, Software AG Tamino Event Daemon).

Please check whether the DSN you use is a user or a system DSN.