Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

960[Oracle][ODBC][Ora]ORA-00960

andrewgs73andrewgs73 Member Posts: 95
Hi,
I am having trouble with this, please help.
We are using Oracle database server, that database
is defined in ODBC, then the DSN defined in the
ODBC is linked to a *.mdb file. We use Excel VBA
openrecordset to get data in that *.mdb file.
In my PC, that vba runs normal but in others, I
receive the error message "960[Oracle][ODBC][Ora]ORA-00960:
ambiguous column naming in select list"
Any idea on this???
Thanks for your help in advance.

Andrew Mosqueda


Comments

  • dannyerldannyerl Member Posts: 20
    Hey, do you speak spanish, right ? i mean because of your lastname:

    Basicamente tenes que revisar que si estas haciendo un producto cartesiano algun campo de otra tabla no se llame exactamente igual que otro que tambien estas seleccionando, en ese caso utiliza un alias para esos campos y tambien asegurate de usar un alias para las distintas tablas. Buena onda y espero que te sirva el tip.


    : Hi,
    : I am having trouble with this, please help.
    : We are using Oracle database server, that database
    : is defined in ODBC, then the DSN defined in the
    : ODBC is linked to a *.mdb file. We use Excel VBA
    : openrecordset to get data in that *.mdb file.
    : In my PC, that vba runs normal but in others, I
    : receive the error message "960[Oracle][ODBC][Ora]ORA-00960:
    : ambiguous column naming in select list"
    : Any idea on this???
    : Thanks for your help in advance.
    :
    : Andrew Mosqueda
    :
    :
    :

  • andrewgs73andrewgs73 Member Posts: 95

    no entiendo mucho espaol. Apesadumbrado. Cambie al ingls, puede usted? Gracias por su amabilidad.


    : Hey, do you speak spanish, right ? i mean because of your lastname:
    :
    : Basicamente tenes que revisar que si estas haciendo un producto cartesiano algun campo de otra tabla no se llame exactamente igual que otro que tambien estas seleccionando, en ese caso utiliza un alias para esos campos y tambien asegurate de usar un alias para las distintas tablas. Buena onda y espero que te sirva el tip.
    :
    :
    : : Hi,
    : : I am having trouble with this, please help.
    : : We are using Oracle database server, that database
    : : is defined in ODBC, then the DSN defined in the
    : : ODBC is linked to a *.mdb file. We use Excel VBA
    : : openrecordset to get data in that *.mdb file.
    : : In my PC, that vba runs normal but in others, I
    : : receive the error message "960[Oracle][ODBC][Ora]ORA-00960:
    : : ambiguous column naming in select list"
    : : Any idea on this???
    : : Thanks for your help in advance.
    : :
    : : Andrew Mosqueda
    : :
    : :
    : :
    :
    :

Sign In or Register to comment.