Export to RDBMS problem

Hi Team,

I can’t figure out why my ‘Export to RDBMS’ behaves inconsistently.

Sometimes the option is dimmed out and sometimes it is not.

I have both 5.1.4 and 6.1 installed on the same machine. Today when I opened the same report, the 5.1.4 version showed me the option is available and the option for 6.1 is dimmed out.

But the other day both were dimmed out.

Any clue what is causing this?

Thanks.

Joanna


joanna (BOB member since 2004-01-29)

One thought would be whether you are switching between ZABO (3-tier) or full-client (2-tier) connections. I don’t believe Export to RDBMS is available using a ZABO connection.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Thanks for reply. How do I check to see which type of connections I am using? Is it some setting I can check on my local machine?

Thanks again.

Joanna


joanna (BOB member since 2004-01-29)

When you get to your login screen, do you see a security domain box (in addition to user name and password)? If you do, entries in the drop-down box with a globe icon are ZABO connections, and entries with a computer icon are full-client connections. If you don’t have a security domain box, then it means you are using only one connection and it can’t be the reason for what you are seeing.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

No. I don’t have that domain box. What I can’t figure out is why sometimes it shows up and sometimes it doesn’t. :roll_eyes:
Thanks.

Joanna


joanna (BOB member since 2004-01-29)

Well, I’ve helped to eliminate one possibility, but I’m afraid I’m out of suggestions. Actually, that’s not true. Is the data provider set to be editable / refreshable? Sometimes that can cause seemingly unrelated capabilities (like exporting) to be disabled as well.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Thank you for helping. I need any suggestion.

It is a free hand SQL report that access Oracle database tables directly.
The user has the rights to edit the database table.

Joanna


joanna (BOB member since 2004-01-29)

You need to have a Personal Connection and that connection needs to have Create Table rights.

You may also want to Rename your DataProvider, since that is the name of the table that will be created. It’s possible that your DP begins with a numeric value so you may not be able to create a table with that name.

-RM


digpen :us: (BOB member since 2002-08-15)