>
> I created a user that can access both databases. I then
> created the datasource in CF and it points to the DB that
> will be hit the most. I then wrote the query
>
> select a.*, b.*
> from
> db.tablea a
> inner join
> db.tableb b
>
> Beside the fact that the join is not valid, I get an error
> "Invalid object name". Any suggestions?
I think you may have to specify the user name in addition to the database
name:
database.owner.table
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
