Improper namespace error

[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.

[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

[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 ).

[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.__

[kfleming]

Does R&R give you a correct list of table names and then error when you select a table?____Kathleen__R&R Support

[pluichinger]

Yes. That is when the error occurs.

[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