Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Suppress default table owner Post Reply Post New Topic
Author Message
baldrick69
Newbie
Newbie


Joined: 17 Sep 2010
Online Status: Offline
Posts: 1
Quote baldrick69 Replybullet Topic: Suppress default table owner
    Posted: 17 Sep 2010 at 5:58am
Is it possible to suppress the default table owner in Crystal Reports XI?
 
When Crystal fails to retrieve data I look at the SQL and see that it is of the form SELECT field FROM owner.table
 
This fails.
 
I know from other SQL query analyzers that SELECT field FROM owner.table will fail, whereas without the "owner" bit - SELECT field FROM table works.
 
The datasource is the Attunity OLEdb driver but I can't get Attunity to accept SELECT queries using owner.table.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.