I’m trying to connecto to internal sql through X-Node. But Tamino throws error when defining schema. I went through following procedure.
1) Invoke SQLInt utility
2) Connect to sql engine with “DBA” id.
3) create “DBA” schema
create schema DBA authorization DBA;
4) create “customer” table
create table customer(
id char(10),
name char(20));
5) commit;
6) After then, I made following Tamino schema
***** test_schema
********** - customer (Doctype)
********** - customer (Element complex)
******************** Storage Type:Map SubTreeSQL
******************** schema:DBA
******************** table:customer
******************** userid:DBA
******************** password:dba
******************** datasource:empty
******************** primaryKeyColumn:id
***************** - sequence
******************** - id (Element simple)
*********************** Storage Type:Map NodeSQL
*********************** column:id
******************** - name (Element simple)
*********************** Storage Type:Map NodeSQL
*********************** column:name
7) Tamino returns following error.
<?xml version="1.0" encoding="iso-8859-1" ?>
- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
- <ino:message ino:returnvalue=“8514”>
<ino:messagetext ino:code=“INOXME8514”>X-Node SQL column not found or authorization error</ino:messagetext>
ino:messagelineElement name = customer</ino:messageline>
</ino:message>
</ino:response>
Please help me solving this problem. Thank you in advance.
[This message was edited by Stone on 15 Oct 2002 at 09:25.]
Which version of Tamino do you use and which platform?
My environment :
Tamino v3.1.1.4 for Windows (Windows 2000 Prof)
license info :
sql : yes
dbms : no
Is dbms license required to connect to internal sql?
I would recommend upgrading to Tamino v3121. I vaguely remember having this problem too with Tamino v311 on a Windows platform (can’t remember if it was NT or Windows 2000) - hence my previous question. But it certainly works with Tamino v3121.
I don’t know if you need something in the license file for X-Node to the internal sql database, I have a feeling you probably do, but I really don’t know the answer to that one. I would suggest contacting your local Software AG Customer Support Center and ask them.