Hi Guys,
I want to query 2 databases. The first DB is SQL Server 2000 and the 2nd is MS Access.
I created this simple query in SQL Server but, it gives me an error saying "Invalid Object Name", where ODBC_TBL2 is an ODBC connection
I also get the same error message for:
I need this query in an ASP application I am creating. Links does not work in ASP.
I can query similar databases e.g. SQL Server vs SQL Server and MS Access vs. MS Access.
Thanks in advance for your help
Mike
I want to query 2 databases. The first DB is SQL Server 2000 and the 2nd is MS Access.
I created this simple query in SQL Server but, it gives me an error saying "Invalid Object Name", where ODBC_TBL2 is an ODBC connection
Code:
SELECT TBL1.Field1
FROM TBL1
INNER JOIN ODBC_TBL2.Field1 ON
TBL1.Field1 = ODBC_TBL2.field1
I also get the same error message for:
Code:
SELECT TBL1.Field1
FROM TBL1
INNER JOIN [C:\DB\ACS_TBL.MDB].TBL2 AS ODBC_TBL2 ON
TBL1.Field1 = ODBC_TBL2.field1
I need this query in an ASP application I am creating. Links does not work in ASP.
I can query similar databases e.g. SQL Server vs SQL Server and MS Access vs. MS Access.
Thanks in advance for your help
Mike