sqlserver HS ODBC
I successfully made connection to ACCESS DB and FOXPRO DB using
But when I tried making HS to SQLSERVER DB using the same procedure
i got this error:
select count(*) from EMP@SQLSVR_db
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot open database requested in login 'master'. Login fails. (SQL
State: 37000; SQL Code: 4060)
ORA-02063: preceding 2 lines from SQLSVR_DB
I created EMP table on MASTER DB on PROD_SERVER.
Why does it fails login on Master my default config DB when I did successful
connect during the config set-up.
My sql login userid is SA and with no password.
Thanks a lot.
Click Here to Expand Forum to Full Width