Ok first of all I am rather new to ODBC. Just never had to use it before being on unix.
The server is on linux 7.2. I have the odbc driver installed on the same machine. I have noticed the same behavior when using both iodbc and unixodbc. Accessing sapdb via odbc works fine when I use the simple query tools provided by iodbc (odbctest) and unixodbc (isql). The problem comes when I run applications linked to either of these. So far the ones I have tested are sqlrelay and the perl DBI::ODBC interface. Both of these applications exhibit exactly the same behavior. The strange behavior is that the odbc driver gets disconnected from the database when there is more than one data source defined in odbc.ini. This happens on any query and on the very first one. If I edit odbc.ini and take out the second data source, bingo all works fine. I know this sounds strange but it is very consistant and happens every single time. The tracefile shows that whenever there are two data sources the message 'Implicit SERVERDB restart' is returned. Subsequent queries return the message -807. (tracefile inserted below). I really have no idea what is going on here, but it seems strange that two separate applications cause exactly the same result, but accesses through the driver manager using it's fairly raw cmd line interface works fine. This seems to me to be a problem where either the applications or the driver are not odbc compliant in some way? Is there anything in the odbc spec that would cause a different sql syntax based on if there are multiple data sources? Chris DATASOURCE: TST SESSION : 1; SQLMODE : INTERN SERVERDB : TST SERVERNODE: CONNECT "DBA " IDENTIFIED BY :A ISOLATION LEVEL 1 START : DATE : 2002-03-26 TIME : 0018:27:45 END : DATE : 2002-03-26 TIME : 0018:27:45 select * from customer PARSE : CMD : SQLCODE: 800 Implicit SERVERDB restart (connection broken) PARSEID: OUTPUT: 00000000 00000000 00000000 START : DATE : 2002-03-26 TIME : 0018:35:06 END : DATE : 2002-03-26 TIME : 0018:35:06 PARSE : CMD : SQLCODE: -807 Connection down, session released PARSEID: OUTPUT: 00000000 00000000 00000000 START : DATE : 2002-03-26 TIME : 0018:35:06 END : DATE : 2002-03-26 TIME : 0018:35:06 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
