Connection to Oracle DB

[Julia Sats]

I try to Data connection to oracle DB in new application and every time I
get the same error: ORA 12154
I us Microsoft Ole DB Provider for Oracle and I have Oracle 9.2
but if I use connect to the same db with the same login and pwd from
application which contain example of Janus.Windows.GridEx - I can create
Data Connection . Of course it sound strange but maybe someone has any ideas
?

Thanks

 

[Peter van der Goes]

I try to Data connection to oracle DB in new application and every time I
get the same error: ORA 12154
I us Microsoft Ole DB Provider for Oracle and I have Oracle 9.2
but if I use connect to the same db with the same login and pwd from
application which contain example of Janus.Windows.GridEx - I can create
Data Connection . Of course it sound strange but maybe someone has any ideas
?

Thanks

Have you tried downloading the latest available drivers from Oracle and
using them? You're using a very recent edition of Oracle and the MS drivers
are probably not up to date for 9.2.
What drivers does the Janus control use? Oracle *used to (I haven't had to
deal with Oracle lately)* provide database version-specific drivers for
their databases.
You might want to ask your question in microsoft.public.data.oledb, if you
haven't already.