Multi Sybase-Database Connection

[kaiserilich]

HI,

I need to execute a query using two or more different database on the same saver or not.

when execute the query this error message appear:

"Table qualifier must be name of current database"

this it's the query:

Code: Select all

SELECT 
    t1.fld1,
	t1.fld2,
	t1.fld3,
	t2.fld6,
    t2.fld7
FROM  DB1.dbo.table1 t1,
    DB2.dbo.table2 t2
WHERE t2.fld1 *= t1.fld1

please, how can fix this


stay working with:
Delphi 6 up 2
ASE 12.5.4
Zeos 6.6.0


thanks

for my bad english

[marsupilami]

Hello kaiserilich,

I looked for that error message in the code of Zeos 6.6 and cannot find it. So maybe this is an error message raised by the sybase client library? Did you try that statement in SQL Advantage and does it work as expected there?
Best regards,

Jan