Follow-up... Not sure if good or bad news...
Windows 2000 Server SP4, running SAPDB 7.4.0.27 was working fine. Did backup then upgraded to MaxDB 7.5. After upgrade, several key tables were missing. Restored the backup, tables were still missing. Deleted SAPDB/MAXDB from system, installed SAPDB 7.4.0.30 and restored database copy from replication partner. All was fine. Then upgraded to MaxDB 7.5 and had no problems. Not sure what happened. But luckly my replication parter was in sync :) Stephen Gutknecht currently in Fremont, California USA -----Original Message----- From: Stephen Gutknecht (SAPDB) Sent: Thursday, November 20, 2003 7:37 AM To: 'Koetter, Thomas Theodor'; [EMAIL PROTECTED] Subject: SELECT fails to find tables after upgrade from SAPDB 7.4 to MaxDB 7.5 Yes, that was the problem. Password has to now be all UPPERCASE. Alas, once I got past that, it seems my application can not find any tables! the upgrade reported no problems, I rebooteed, but now my SELECT statements fail with: ERROR [42S02] [SAP AG][SQLOD32 DLL][MaxDB] Base table or view not found;-4004 POS(xxx) Unknown table name:TABLENAME1. This was just a test upgrade, as flying blind without 7.5 release notes. Looking like I should revert to 7.4. Stephen -----Original Message----- From: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 2:33 AM To: [EMAIL PROTECTED] Subject: RE: SAPDB 7.4 style DSN-less ODBC login fails with MaxDB 7.5 Hi Stephen, > -----Original Message----- > From: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 20. November 2003 10:59 > To: [EMAIL PROTECTED] > Subject: SAPDB 7.4 style DSN-less ODBC login fails with MaxDB 7.5 > > > > I changed my driver but now login fails after upgrade from > SAPDB 7.4. --> > MaxDB 7.5. The Win32 MaxDB (Unicode) driver returns: > > ERROR [28000] [SAP AG][SQLOD32 DLL][MaxDB]Invalid authorization > specification ;-4008 POS(1) Unknown user name/password combination. Did you take into account that connect strings are handled case sensitive now? (cmp. http://groups.yahoo.com/group/sapdb-general/message/15079). If this is not the case, please send me the internal ODBC trace. http://sapdb.2scale.net/moin.cgi/ODBCTrace Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
