I had a similar problem. I downloaded the latest
version of ODBC driver from oracle.com and now it
works without any errors. You can try that out.
Muru
- Schoen Volker <v.schoen_at_inplan.de> wrote:
> I think your problem is the MS Transaction Server.
> Configure your DSN and
> click checkbox "Disbale MTS Support". I think this
> should work.
>
> Regards
>
> Volker Schön
> E-Mail: mailto:v.schoen_at_inplan.de
> http://www.inplan.de
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Witold Iwaniec
> [mailto:wiwaniec_at_novalistech.com]
> Gesendet: Dienstag, 5. September 2000 16:45
> An: Multiple recipients of list ORACLE-L
> Betreff: ODBC drivers
>
>
> Hi
>
> I have strange behavior of ODBC drivers and wonder
> if anyone else
> noticed it, knows fix for it. Here it goes:
>
> I have a stored procedure that takes three
> parameters VARCHAR2,
> VARCHAR2, NUMBER
> the call through ODBC would be, for example,:
>
> begin my_proc('-1', 'INT_TEN_RS', 1); end;
>
> I connect to Oracle 8.1.6 database on Sun Solaris
> from Windows
> NT 4.0 SP 5. When I use Microsoft ODBC driver or old
> Oracle
> ODBC driver (Oracle 73 ver 2.5) it works. But when I
> use Oracle
> ODBC driver installed with Oracle 8i client (ver
> 8.01.06.00)
> sometimes it works but in most cases it returns
> error 6550 with the
> message:
> line1, column 64: PLS-00103: Encountered the symbol
> "" The
> symbol "" was ignored.
>
> I would look into the procedure but it works with
> other drivers, as
> well as with OCI etc.
>
> Has anyone worked with the driver?
>
> Thanks
>
> Witold
>
> ======================================
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Author: Schoen Volker
> INET: v.schoen_at_inplan.de
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Received on Wed Sep 06 2000 - 10:09:19 CDT