Page 1 of 1
Improper namespace error
Posted: Fri Sep 05, 2003 3:02 pm
by P._Luichinger_(Guest)
Hello, my company recently purchased a copy of R&R10+. I^m attempting to build reports via ODBC off of a postgreSQL database. I^ve set up my DSN for my windows machine to connect to the postgreSQL server, and have had several other applications use the DSN without error.____When I request a report based on table ^xyz^ in R&R, I get a DB access error stating that the requested namespace ^www^ does not exist. Tracing the sql connection, I can see that R&R is performing the following query: select * from www.xyz where 0=1. ^www^ is the username given in the DSN. It appears that R&R is attempting to use the username ^www^ as the schema name instead of properly determining the schema name ( which is ^public^ ) for the requested table. I haven^t had this problem in other reporting software I^ve used, and I was wondering if any knows why this is occuring with R&R, and how to fix it.
=> RE: Improper namespace error
Posted: Fri Sep 05, 2003 3:41 pm
by kfleming
Does the same error occur if you do a File New User SQL and enter:____SELECT * from XYZ____in the SQL statement box?____Kathleen__R&R Support
==> RE: Improper namespace error
Posted: Mon Sep 08, 2003 8:51 am
by P._Luichinger_(Guest)
No, R&R can connect to the database if I do that. However, when I try to view my recordset from the sql query ( substituting one my table names for ^XYZ^ ), I get no records returned. Tracing the sql odbc connection, I see a lot of errors for an unsupported type ( binary ).
===> RE: Improper namespace error
Posted: Mon Sep 08, 2003 9:48 am
by pluichinger
Oops.. correction. I can get data from my table, so ignore that part of the above comment. So, I can get data if I type in the SQL statement, but I can^t if I let R&R try to build my statement for me. Is there a way around this? The person who will be building my company^s reports is not a programmer and won^t be able to write SQL statements by hand.__
====> RE: Improper namespace error
Posted: Mon Sep 08, 2003 2:51 pm
by kfleming
Does R&R give you a correct list of table names and then error when you select a table?____Kathleen__R&R Support
=====> RE: Improper namespace error
Posted: Mon Sep 08, 2003 3:15 pm
by pluichinger
Yes. That is when the error occurs.
======> RE: Improper namespace error
Posted: Tue Sep 09, 2003 3:58 pm
by kfleming
There are some edits that we can try to RSW.INI and RSWSQL.INI that might make a difference. I will email you directly with a list of what you can try however there is no implied promise of success. Some ODBC driver seem to give us fits when other applications think they are perfectly ok.____Kathleen__R&R Support