Hi! Problem solved! I use the owner of the tables, SAPR3, to log on with the ODBC connection and it works beautiful!
Cheers! rollo ----- Original Message ----- From: "Zabach, Elke" <[EMAIL PROTECTED]> To: "rollo" <[EMAIL PROTECTED]>; <[email protected]> Sent: Thursday, January 13, 2005 1:40 PM Subject: AW: problem with addressing tables via ODBC from an asp-page rollo wrote: > > Hi! > > We just migrated our database from an IBM AS/400 to a MaxDB database and > now I'm updating some asp-pages on our intranet. > > I used to address the tables like this > > ar = year(date) > ar2 = "'"& ar &"'" > SQLQuery = "SELECT * FROM R3T02DATA.zzuppfs where Gjahr = "& ar2 > > This doesn't work, so I tried "Select * from zzuppfs", but it doesn't help > either. > > The error I get is "[MySQL MaxDB][SQLOD32 DLL][MaxDB] Base table not > found;-4004 POS(15) Unknown table name:ZZUPPFS " > > When I use SQL Studio, the table is not found > > > What might be the problem? You do not use user R3T02DATA when working with SQL Studio. The user you are working with does not have the privilege to see this table. This -4004 has nothing to do with the tool/client used, but with the user used and his privileges for the object (table) concerned. Elke SAP Labs Berlin > > > regards > > > rollo -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
