| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ODBC connection failing to connect Oracle 8i
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFD8F8.A64F7790
Content-Type: text/plain;
charset="windows-1255"
Hi ,
We had a lot of problems connecting Oracle via VB6....
After many attempts we arrived to the conclusion that only Oracle ODBC driver is working properly, be careful, versions are changing very often ....
Actualy we are using version 8.1.55, I know there is a new version but I did not try it.
If you use transactions be aware to Disable MTS Support !
Good Luck
Ruth Fouks
-----Original Message-----
From: pradeep_at_ibsplc.com [mailto:pradeep_at_ibsplc.com]
Sent: Saturday, June 17, 2000 9:44 AM
To: Multiple recipients of list ORACLE-L
Subject: ODBC connection failing to connect Oracle 8i
Hi,
I am facing a problem after the installation of Oracle 8i Server.The problem is mentioned below.
An application which was developed in VB 6.0 with Oracle 8.0.4 as the database was working fine with the Oracle 8.0.4 Client. But when I tried to connect the application after installing Oracle 8i client , it shows the following error.
IM006: [Microsoft] [ODBC Driver Manager] Drivers SQL Set Connect Attr Failed
The ODBC driver we used is Microsoft ODBC for Oracle (Version 2.573.292700).
Expecting a solution at the earliest.
Regards
Pradeep
-- Author: INET: pradeep_at_ibsplc.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). ------_=_NextPart_001_01BFD8F8.A64F7790 Content-Type: text/html; charset="windows-1255" Content-Transfer-Encoding: quoted-printableReceived on Sun Jun 18 2000 - 02:41:40 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1255">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2232.0">
<TITLE>RE: ODBC connection failing to connect Oracle 8i</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi , </FONT>
</P>
<P><FONT SIZE=3D2>We had a lot of problems connecting Oracle via =
VB6....</FONT>
</P>
<P><FONT SIZE=3D2>After many attempts we arrived to the conclusion that =
only Oracle ODBC driver is working properly, be careful, versions are = changing very often ....</FONT></P>
<P><FONT SIZE=3D2>Actualy we are using version 8.1.55, I know there is =
a new version but I did not try it.</FONT>
</P>
<P><FONT SIZE=3D2>If you use transactions be aware to Disable MTS =
Support !</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Good Luck </FONT>
<BR><FONT SIZE=3D2>Ruth Fouks</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: pradeep_at_ibsplc.com [<A =
HREF=3D"mailto:pradeep_at_ibsplc.com">mailto:pradeep_at_ibsplc.com</A>]</FONT>=
<BR><FONT SIZE=3D2>Sent: Saturday, June 17, 2000 9:44 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: ODBC connection failing to connect Oracle =
8i</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2>I am facing a problem after the installation of =
Oracle 8i Server.The</FONT>
<BR><FONT SIZE=3D2>problem is mentioned below.</FONT>
</P>
<P><FONT SIZE=3D2>An application which was developed in VB 6.0 with =
Oracle 8.0.4 as the</FONT>
<BR><FONT SIZE=3D2>database was working fine with the Oracle =
8.0.4 Client.</FONT>
<BR><FONT SIZE=3D2>But when I tried to connect the application after =
installing Oracle 8i</FONT>
<BR><FONT SIZE=3D2>client , it shows the following error.</FONT>
</P>
<P><FONT SIZE=3D2>IM006: [Microsoft] [ODBC Driver Manager] Drivers SQL =
Set Connect Attr</FONT>
<BR><FONT SIZE=3D2>Failed</FONT>
</P>
<P><FONT SIZE=3D2>The ODBC driver we used is Microsoft ODBC for Oracle =
(Version</FONT>
<BR><FONT SIZE=3D2>2.573.292700).</FONT>
</P>
<P><FONT SIZE=3D2>Expecting a solution at the earliest.</FONT>
</P>
<P><FONT SIZE=3D2>Regards</FONT>
<BR><FONT SIZE=3D2>Pradeep</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2> INET: pradeep_at_ibsplc.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
 |
 |