OraFAQ Forum: Networking and Gateways » HS ODBC connection to UNIData SQL translation

Home » RDBMS Server » Networking and Gateways » HS ODBC connection to UNIData SQL translation (Oracle xe 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HS ODBC connection to UNIData SQL translation [message #356752]

Sun, 02 November 2008 01:22

ravijey
Messages: 2
Registered: November 2008

Junior Member

Experts please help.
I successfully created a db link to Unidata using HS ODBC. When I execute SQL for example "SELECT NAME FROM CUSTOMER@UNIDATA", Oracle translates the SQL as "SELECT NAME AS C000 FROM CUSTOMER@UNIDATA".
The issue is, Unidata ODBC does not recoginize "as" keyword. So I am getting a syntax error. Is there a way or a parameter I can set to disable the "as" keyword during the SQL translation ?

Report message to a moderator

Re: HS ODBC connection to UNIData SQL translation [message #356753 is a reply to message #356752]

Sun, 02 November 2008 01:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try to give yourself an alias in your query:
SELECT NAME "C001" FROM CUSTOMER@UNIDATA

Regards
Michel

Report message to a moderator

Re: HS ODBC connection to UNIData SQL translation [message #356835 is a reply to message #356753]

Sun, 02 November 2008 14:30

ravijey
Messages: 2
Registered: November 2008

Junior Member

Thanks for the response.
Still does'nt work. It is translating the SQL as

select name as c0000 from customer@unidata.

Report message to a moderator

Previous Topic:	how can i create more listener and do LOAD BALANCE?
Next Topic:	TNS:Address already in use Urgent please help!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 16:11:05 CST 2024