Hello,
I am trying to get SUN ChiliSoft ASP and SAP DB to talk to each other by
means of Datadirect Technologies SQLink Socket Driver.
So far, using the SAP DB driver for Linux or for Windows, I get the same
error message: (Follows the error when using the SAP DB ODBC Windows
Driver):
Error: -2147418113
Description: Chili!Soft ASP ADO control - build 3.6.2 SQLState: S1091
Native Error Code: 0
SQLState: 01004
Native Error Code: 0
SQLState: S1091
Native Error Code: 0
SQLState: S1091
Native Error Code: 0
SQLState: 01004
Native Error Code: 0
SQLState: S1091
Native Error Code: 0
[DataDirect][ODBC SequeLink driver][ODBC Socket][SAP AG][SQLOD32 DLL]
Invalid descriptor field identifier.
[DataDirect][ODBC SequeLink driver][ODBC Socket][SAP AG][SQLOD32
DLL]Data truncated.
[DataDirect][ODBC SequeLink driver][ODBC Socket][SAP AG][SQLOD32 DLL]
Invalid descriptor field identifier.
[DataDirect][ODBC SequeLink driver][ODBC Socket][SAP AG][SQLOD32 DLL]
Invalid descriptor field identifier.
[DataDirect][ODBC SequeLink driver][ODBC Socket][SAP AG][SQLOD32
DLL]Data truncated.
[DataDirect][ODBC SequeLink driver][ODBC Socket][SAP AG][SQLOD32 DLL]
Invalid descriptor field identifier.
I am also attaching the SQL Trace from the SAP DB ODBC Windows Driver.
Any ideas?
Thanks in advance for your help.
Saludos,
Jose
<![CDATA[
PRODUCT : SAP DB C-PreComp Runtime
VERSION : 7.4.3
BUILD : 009-111-000-000
DATASOURCE: agadb
SESSION : 1;
SQLMODE : INTERN
SERVERDB : agadb
SERVERNODE: 192.168.2.10
CONNECT "DBA " IDENTIFIED BY :A ISOLATION LEVEL 1
START : DATE : 2002-12-04 TIME : 0021:57:59
END : DATE : 2002-12-04 TIME : 0021:57:59
SELECT TYPE_NAME, decode (DATA_TYPE, 9, 91, 10, 92, 11, 93, DATA_TYPE),
PRECISION AS COLUMN_SIZE, LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS,
NULLABLE, CASE_SENSITIVE, SEARCHABLE, UNSIGNED_ATTRIBUTE, MONEY, AUTO_INCREMENT
AS AUTO_UNIQUE_VALUE, LOCAL_TYPE_NAME, MINIMUM_SCALE, MAXIMUM_SCALE,
SQL_DATA_TYPE, SQL_DATETIME_SUB, NUM_PREC_RADIX, INTERVAL_PRECISION FROM SYSDBA.
SYSODBCTYPES ORDER BY 2, 1
PARSE : CMD :
mfIndex init : 1
mfIndex init : 2
PARSEID: OUTPUT: 000001F9 00000201 3C002E00 01000000
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
SELECT TYPE_NAME, decode (DATA_TYPE, 9, 91, 10, 92, 11, 93, DATA_TYPE),
PRECISION AS COLUMN_SIZE, LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS,
NULLABLE, CASE_SENSITIVE, SEARCHABLE, UNSIGNED_ATTRIBUTE, MONEY, AUTO_INCREMENT
AS AUTO_UNIQUE_VALUE, LOCAL_TYPE_NAME, MINIMUM_SCALE, MAXIMUM_SCALE,
SQL_DATA_TYPE, SQL_DATETIME_SUB, NUM_PREC_RADIX, INTERVAL_PRECISION FROM SYSDBA.
SYSODBCTYPES ORDER BY 2, 1
EXECUTE: CMD :
PARSEID: INPUT : 000001F9 00000201 3C002E00 01000000
mfIndex init : 2
mfIndex init : 2
WARNING: W-------8-------
SQLRESULTNAME : SQL_CURSOR_0001
SQLERRD(INDEX_3) : 17
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
PARSE : CMD :
WARNING: W--3------------
PARSEID: OUTPUT: 000001F9 00000401 2A002B00 01000000
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
EXECUTE: CMD :
PARSEID: INPUT : 000001F9 00000401 2A002B00 01000000
PARAMETER DESCRIPTION: 0X01C2F008
Application Kernel
Nr. Type Length Type Length Fraction
---------------------------------------------
1 7 19 31 18 0
2 7 8 0 5 0
3 1 4 30 10 0
4 7 4 31 3 0
5 7 4 31 3 0
6 7 129 31 128 0
7 0 2 29 5 0
8 0 2 29 5 0
9 0 2 29 5 0
10 0 2 29 5 0
11 0 2 29 5 0
12 0 2 29 5 0
13 7 19 31 18 0
14 0 2 29 5 0
15 0 2 29 5 0
16 0 2 29 5 0
17 0 2 29 5 0
18 1 4 30 10 0
19 0 2 29 5 0
OUTPUT : 1: TYPE_NAME : BOOLEAN
OUTPUT : 2: EXPRESSION1 : -7
OUTPUT : 3: COLUMN_SIZE : 1
OUTPUT : 4: LITERAL_PREFIX : IS NULL
OUTPUT : 5: LITERAL_SUFFIX : IS NULL
OUTPUT : 6: CREATE_PARAMS : IS NULL
OUTPUT : 7: NULLABLE : 1
OUTPUT : 8: CASE_SENSITIVE : 0
OUTPUT : 9: SEARCHABLE : 2
OUTPUT : 10: UNSIGNED_ATTRIBUTE : IS NULL
OUTPUT : 11: MONEY : 0
OUTPUT : 12: AUTO_UNIQUE_VALUE : IS NULL
OUTPUT : 13: LOCAL_TYPE_NAME : BOOLEAN
OUTPUT : 14: MINIMUM_SCALE : IS NULL
OUTPUT : 15: MAXIMUM_SCALE : IS NULL
OUTPUT : 16: SQL_DATA_TYPE : -7
OUTPUT : 17: SQL_DATETIME_SUB : IS NULL
OUTPUT : 18: NUM_PREC_RADIX : IS NULL
OUTPUT : 19: INTERVAL_PRECISION : IS NULL
SQLERRD(INDEX_3) : 1
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
CLOSE "SQL_CURSOR_0001"
PARSE : CMD :
PARSEID: OUTPUT: 000001F9 00000501 06002800 01000000
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
CLOSE "SQL_CURSOR_0001"
EXECUTE: CMD :
PARSEID: INPUT : 000001F9 00000501 06002800 01000000
PARSEID: SELECT: 000001F9 00000201 3C002E00 01000000
mfIndex init : 2
mfIndex restore : 2
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
PARSEID: DROP : 000001F9 00000401 2A002B00 01000000
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
SQCDROPPARSID
PARSEID: : 000001F9 00000401 2A002B00 01000000
PARSEID: DROP : 000001F9 00000501 06002800 01000000
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
SQCDROPPARSID
PARSEID: : 000001F9 00000501 06002800 01000000
mfIndex delete : 2
PARSEID: DROP : 000001F9 00000201 3C002E00 01000000
START : DATE : 2002-12-04 TIME : 0021:58:00
END : DATE : 2002-12-04 TIME : 0021:58:00
SQCDROPPARSID
PARSEID: : 000001F9 00000201 3C002E00 01000000
S1: DISCONNECT
SQCFINISH
</div>
<div class="msgButtons margintopdouble">
<ul class="overflow">
<li class="msgButtonItems"><a class="button buttonleft " accesskey="p" href="msg02856.html">Previous message</a></li>
<li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="thrd44.html#03746">View by thread</a></li>
<li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="mail31.html#03746">View by date</a></li>
<li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg03757.html">Next message</a></li>
</ul>
</div>
<a name="tslice"></a>
<div class="tSliceList margintopdouble">
<ul class="icons monospace">
<li class="icons-email"><span class="subject"><a href="msg00925.html">ODBC problem</a></span> <span class="sender italic">Hu Ping</span></li>
<li><ul>
<li class="icons-email"><span class="subject"><a href="msg00926.html">RE: ODBC problem</a></span> <span class="sender italic">Koetter, Thomas Theodor</span></li>
<li class="icons-email"><span class="subject"><a href="msg02856.html">ODBC problem</a></span> <span class="sender italic">Wiesław Poszewiecki</span></li>
<li class="icons-email"><span class="subject"><a href="msg03757.html">RE: ODBC Problem</a></span> <span class="sender italic">Jose Miselem</span></li>
<li class="icons-email"><span class="subject"><a href="msg03757.html">RE: ODBC Problem</a></span> <span class="sender italic">Koetter, Thomas Theodor</span></li>
<li class="icons-email"><span class="subject"><a href="msg06899.html">ODBC Problem</a></span> <span class="sender italic">David Blake</span></li>
<li><ul>
<li class="icons-email"><span class="subject"><a href="msg06909.html">Re: ODBC Problem</a></span> <span class="sender italic">Juergen Sauer</span></li>
</ul></li>
<li class="icons-email"><span class="subject"><a href="msg06902.html">RE: ODBC Problem</a></span> <span class="sender italic">Koetter, Thomas Theodor</span></li>
</ul>
</ul>
</div>
<div class="overflow msgActions margintopdouble">
<div class="msgReply" >
<h2>
Reply via email to
</h2>
<form method="POST" action="/mailto.php">
<input type="hidden" name="subject" value="ODBC Problem">
<input type="hidden" name="msgid" value="1039061276.2659.10.camel@miscomlxs">
<input type="hidden" name="relpath" value="sapdb.general@listserv.sap.com/msg03746.html">
<input type="submit" value=" Jose Miselem ">
</form>
</div>
</div>
</div>
<div class="aside" role="complementary">
<div class="logo">
<a href="/"><img src="/logo.png" width=247 height=88 alt="The Mail Archive"></a>
</div>
<form class="overflow" action="/search" method="get">
<input type="hidden" name="l" value="sapdb.general@listserv.sap.com">
<label class="hidden" for="q">Search the site</label>
<input class="submittext" type="text" id="q" name="q" placeholder="Search sapdb.general">
<input class="submitbutton" name="submit" type="image" src="/submit.png" alt="Submit">
</form>
<div class="nav margintop" id="nav" role="navigation">
<ul class="icons font16">
<li class="icons-home"><a href="/">The Mail Archive home</a></li>
<li class="icons-list"><a href="/sapdb.general@listserv.sap.com/">sapdb.general - all messages</a></li>
<li class="icons-about"><a href="/sapdb.general@listserv.sap.com/info.html">sapdb.general - about the list</a></li>
<li class="icons-expand"><a href="/search?l=sapdb.general@listserv.sap.com&q=subject:%22ODBC+Problem%22&o=newest&f=1" title="e" id="e">Expand</a></li>
<li class="icons-prev"><a href="msg02856.html" title="p">Previous message</a></li>
<li class="icons-next"><a href="msg03757.html" title="n">Next message</a></li>
</ul>
</div>
<div class="listlogo margintopdouble">
</div>
<div class="margintopdouble">
</div>
</div>
</div>
<div class="footer" role="contentinfo">
<ul>
<li><a href="/">The Mail Archive home</a></li>
<li><a href="/faq.html#newlist">Add your mailing list</a></li>
<li><a href="/faq.html">FAQ</a></li>
<li><a href="/faq.html#support">Support</a></li>
<li><a href="/faq.html#privacy">Privacy</a></li>
<li class="darkgray">1039061276.2659.10.camel@miscomlxs</li>
</ul>
</div>
</body>
</html>
<script>(function(){function c(){var b=a.contentDocument||a.contentWindow.document;if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'9d3f8f82c91ed945',t:'MTc3MjExMDE0Nw=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>]]></plaintext></pre></div></div>