Re: Oracle and Sybase connection problem. Please help me!!! urgent.

"Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca.x> wrote in message news:<fjOWc.51996$X12.2798_at_edtnps84>...
> I assume that you are trying to connect to ASA 6, not ASE 6.
> - do you have ASA client installed on the db server?
> - did you create an ODBC DSN on the database server that can actually
> connect to ASA?
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Mata" <matabares_at_gmail.com> wrote in message
> news:e87a2791.0408241314.1b03d38f_at_posting.google.com...
> > Ed Stevens <nospam_at_noway.nohow> wrote in message
> news:<2pgmi0pij29unve68tmud9vtodb8acqrmm_at_4ax.com>...
> > > On 23 Aug 2004 14:16:01 -0700, matabares_at_gmail.com (Mata) wrote:
> > >
> > > >Hello,
> > > >
> > > >I'm trying to connect oracle running on AIX system whit a sybase 6.0.2
> > > >D.B running on a WIN XP platform. I'm using Heterogeneous
> > > >Services to connect them; version of transparent gateway for Sybase is
> > > >9.2.0.1.0.
> > > >
> > > >When i do a select sentence from sql plus i get this message:
> > > >
> > > >ORA-28500: connection from ORACLE to a non-Oracle system returned this
> > > >message:
> > > >[Transparent gateway for SYBASE]No se puede encontrar el módulo
> > > >especificado.
> > > >; at FIND_IMAGE_SYMBOL
> > > >[C079] Failed to load dynamic library 'hsdbsyb'
> > > >PATH = C:\oracle\ora90\bin;C:\Archivos de
> > > >programa\Oracle\jre\1.3.1\bin;C:\Archivos de
> > >
> >programa\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Sys
> tem32\Wbem;C:\DJGPP\bin;C:\Archivos
> > > >de programa\UltraEdit;C:\j2sdk1.4.2_04\bin;C:\BORLANDC\BIN;C:\Ar
> > > >
> > > >[C077] Could not find symbol 'SYBASE' in dynamic library
> > > >ORA-02063: preceding 7 lines from PR1
> > > >
> > > >
> > > >WHAT IS WRONG?????
> > > >
> > > >
> > > >I'll really apreciate any help you can bring.
> > > >
> > > >Thanks.
> > >
> > >
> > > I'm always amused when people post to usenet with subject line that
> > > says "urgent". Given the nature of usenet, how msgs are propogated,
> > > and the geographical location of myself in relation to who might
> > > reply, I never expect an answer in less than 24 hours, and that only
> > > if I ask a reasonable question in a reasonable manner.
> >
> > Hello
> >
> > Howard,Daniel and Ed,
> >
> > I'm a student of systems a telecommunication engineery on latin
> > america.
> > I gotta do a lab activity that consists in connect a sybase and oracle
> > databases. As you may understand i don't count with technical support.
> >
> > I'm sorry if i was rude, perhaps annoying, but it wasn't my intention.
> >
> > My english is not good, i hope you understand.

Hi Terry!!

> - do you have ASA client installed on the db server?
Yes, i have a ASA client.

> - did you create an ODBC DSN on the database server that can actually
> connect to ASA?

Yes, I have an ODBC DSN conection to ASA. I have tested it Received on Thu Aug 26 2004 - 10:42:37 CDT