ODBC Connectivity

[scottpdann]

I am having trouble getting my IBM Universe ODBC data accessed in Crystal versions 9 and 10. Any thoughts?

Thank you.

 

[synapsevampire]

Post what the issue is, such as no tables show, or you get an error, or...

-k

 

[scottpdann]

Failed to Open a ROWSET

 

[Turkbear]

Hi,
That means that something in what you 'asked' for did not exist..

Check your connection ( use the 'test connection' option in th DSN configuration tool), your username/password, etc..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

This can mean many things, including that there wasn't an understandable dataset returned.

This should also only occur after having tried to open a specific table, view or SP. Perhaps you can take the time to post the specifics, as previously requested.

Such as:

"When I try to open a table, I get the error: blah...", or whatever the circumstances are.

Make sure that you've tried numerous tables, and then if you can, try linking (not importing) the same table into
MS Access or some other 3rd party tool and see how it reacts.

-k

 

[scottpdann]

It imports into Access fine.

Universe/SQL Syntax error, Unexpected File name is the jist of the message.

 

[synapsevampire]

Ahhh, there is a blurb in the knowledge base about aliases:

http://support.businessobjects.com/library/kbase/articles/c2017074.asp?ref=devzone_reporting_main

Perhaps the name of the object is causing Crystal grief.

Have you tried different database object types, and different objects?

-k

 

[scottpdann]

Thanks for your suggestions, but it didn't work. I am thinking the problem is in the data, as I have tried it in three versions of Crystal now.

Any other thoughts?