Anyone experienced the behaviour where the first row in a resultset is brought back as two rows? We are using MaxDB and linking it through MS SQL Server using the ODBC driver.
We are running: MaxDB 7.5.0.8 on RH 8.0 MaxDB ODBC Driver 7.5.0.0 Microsoft SQL Server 2K So we setup a linked server through MS SQL Server using the OLEDB Driver for ODBC which points to a db instance in MaxDB. Let's call the linked server DBMAX... If as a test I create a table TESTTABLE in MaxDB and and Insert: 1,'A' | 2,'B' | 3,'C' Then from SQL Server do: Select * from DBMAX..DBA.TESTABLE I get: 1,'A' 1,'A' 2,'B' 3,'C' Everytime. I tried adding an order by clause to force the reverse order and whatever record is listed first in the resultset is listed twice... I am not by any means sure if this is a MaxDB issue but in searching the 'net I uncovered people who were having the same sort of issue with linked AS400 dbs and the problem turned out to not be a Microsoft or SQL Server problem, but a problem with the ODBC driver. If anyone else is experiencing or experienced this same issue I would be grateful for any information. Likewise if someone has used MaxDB as a linked server from MS SQL 2K and has NOT experienced this problem I would also appreciate any information. Thanks in advance! Don Gray CTO, VigilantMinds Inc. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
