ODBC Connection issue in CRXI but not CR10

[Former Member]

I'm having some difficulty viewing fields in a table connecting through an ODBC connection.

I have an ODBC connection to an informix database that has been set up. The connection is successful on test.

In CRXI, when I attempt to create a new report using this ODBC connection, I can view the tables. But when attempting to view the fields in the table, there appear to be none.

Someone else who is accessing this same database using the same connection stated that they are able to view the fields in CR10 but can recreate the same issue in CRXI.

Can anyone help out?

Please let me know if there is any more additional information you may need to help me out.

Thanks,

Mik

[former_member11696]

Hi Mik,

Create a new report using the Wizard and when you select your DSN right click on the Options and try adding filters to the table names or users etc. CR loads all of the info and if your PC has limited resources we can't fill in more than what is required.

Make sure you check on or off the other options to view Stored Procedures, views etc.

Thank you

Don

[Former Member]

Don,

Thanks for the reply. I've done some additional troubleshooting, but am still having the same issue. Hopefully, I'll be able to describe better what my issue is.

To recap, I'm using CR XI 1 and am attempting an ODBC connection to an Informix database.

After finding an article on the SAP support site, I downloaded SQLCon32 which tests your ODBC connections. I'm able to successfully view the tables, views and fileds using this application and can also successfully run SQL queries against the desired view using this application.

Now, I'll go through the steps I go through to create the new report, so I can better describe what I am experiencing.

I select new report. The Standard Report Creation Wizard window pops up.

I select Create New Connection -> ODBC (RDO)

I then select my DSN and enter the correct username/pw.

The connection is successful. I expand the view under the Connection name select the view I am attempting to access.

I hit the next button.

This is where the issue arises.

On the next screen, when it asks you to select the fields you want in the Crystal Report, there are no fields to select. (This occurs with all the views and tables in this ODBC connection)

Even if I select Finish and go into the designer, there are no fields that will display.

Yet, if I create a command view and write a simple query pulling tickets for a particular date, those fields are available and selectable from the designer view.

I'm at a loss for what is going on and why it's happening. I'm hoping someone would be able to shed some light on this for me.

Thanks,

Mik

[former_member11696]

Hi MIk,

Great info....

Firstly though SQLCON32 does not use any Crystal runtime to connect, that was the point, remove all CR runtime to verify you can connect and run SQL.

In the Database Wizard once you connect to your DSN right click on the name and select Options. You should see a properties screen that allows you to select Tables, Views etc... and add filtering also. Try selecting just views or just tables etc. and then add filters so only those that begin with tables you want to see, and test again.

If the resources of your local PC is maxed out that leaves no memory for CR to load all of the info from your server. Try closing any application you do not need as a test also.

If a Command object works then you are still going through our ODBC driver so this does show that CR has no problems other than there possibly is too much DB info to get to the tables/views you want to use.

Thanks again

Don