Hi!
I try to make an uninion on two databases but i recieve error from server:
"The database name component of the object qualifier must be the name of the current database"
I use Delphi 7, MSSQL 2005, Zeos 6.6.4
SQL query:
SELECT * FROM
DB1.dbo.V1EVID_PREGL JOIN
DB2.dbo.Poslovni_Partnerji ON
DB1.dbo.V1EVID_PREGL.ID_PART=DB2.dbo.Poslovni_Partnerji.Stev_Partnerja_ID
What's wrong?
MSSQL Union on two databases problem
Moderators: gto, cipto_kh, EgonHugeist
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Hi,
I did some google work. Seems like this error may be a driver bug.
Look at this post : http://connect.microsoft.com/SQLServer/ ... -not-match
If that's not really related there was also a post that seemed there might be a Upper/Lower case issue, as if Zeoslib may convert some parts of the query to a wrong case.
Maybe you could set a TZSQLMonitor to check if the queries sent have case changes. (Or an internal zeoslib metadata query fails)
Mark
I did some google work. Seems like this error may be a driver bug.
Look at this post : http://connect.microsoft.com/SQLServer/ ... -not-match
If that's not really related there was also a post that seemed there might be a Upper/Lower case issue, as if Zeoslib may convert some parts of the query to a wrong case.
Maybe you could set a TZSQLMonitor to check if the queries sent have case changes. (Or an internal zeoslib metadata query fails)
Mark