This problem seems to have come back when testing restores. Getting logged
in is not enough, you have to get it to 'match' correctly with the other
system.
I believe the problem stems from the change in case processing on the DBMCLI
CREATE USER and ODBC UID parameters.
I suspect my tables were all created as UserName1.tablename but now they are
USERNAME1.tablename or some such change. I'm spending tons of time trying
to get the right combination.
Anyone figured this out? Warning to others who upgrade....
Stephen Gutknecht
Fullt time traveler... currently in Lake Havasu City, Arizona USA
-----Original Message-----
From: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 2:05 PM
To: 'Koetter, Thomas Theodor'; '[EMAIL PROTECTED]'
Subject: RE: SELECT fails to find tables after upgrade from SAPDB 7.4 to M
axDB 7.5
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
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
