I have tried to run a simple BTEQ Export data using Report Mode ,my source is Oracle.
i am facing an issue logging into BTEQ with Oracle credentials.
verified the ODBC connection
when i normally login to the SQL Asst it's connecting easily ,but when i tried to connect to BTEQ i am having the issue.
Normally when we connect using TD db
***Login will be successful
when it comes to connecting to oracle i have tried to login using the same procedure
how do we resolve this issue or am i following the wrong procedure ,suggestions......???
It seems you are a bit confused:
You cannot use bteq with ODBC connection (only Cli)
And most important: You cannot acces Oracle DB with bteq. You must use Oracle sql*plus or another compaible tool.