Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: ODBC drivers

AW: ODBC drivers

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Wed, 6 Sep 2000 09:47:46 +0200
Message-Id: <10611.116277@fatcity.com>


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=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche 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=20 noticed it, knows fix for it. Here it goes:

I have a stored procedure that takes three parameters VARCHAR2,=20 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=20 NT 4.0 SP 5. When I use Microsoft ODBC driver or old Oracle=20 ODBC driver (Oracle 73 ver 2.5) it works. But when I use Oracle=20 ODBC driver installed with Oracle 8i client (ver 8.01.06.00)=20 sometimes it works but in most cases it returns error 6550 with the=20 message:
line1, column 64: PLS-00103: Encountered the symbol "" The=20 symbol "" was ignored.

I would look into the procedure but it works with other drivers, as=20 well as with OCI etc.

Has anyone worked with the driver?

Thanks

Witold

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com =20
http://www.novalistech.com
--=20
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). Received on Wed Sep 06 2000 - 02:47:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US