Joined: 15 May 2008
Online Status: Offline
Posts: 12
Topic: Crystal Connection String Posted: 18 Aug 2009 at 7:23am
Not sure if this makes sense, but is there somewhere I can see the connection string Crystal is using to pull down data?
I have a remote Oracle database that I connect to via ODBC, and I report off of all the time. I have had a terrible time pulling data down in Access, or via web pages. Pulling down the data takes forever, and usually times out before it gets where it's going.
The one exception is Crystal. I can report off any table and I get the data very quickly. And regardless of how many records I'm bringing down, it never times out, despite the fact that I'm using the same ODBC connection.
I'd love to be able to use a similar connection string in other applications to allow me to pull live data in a reasonable time frame. Is there a way to do this?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum