Re: Oracle ODBC connection and VB4

From: Paul K. Courtney <pcourtney_at_pine.vpcc.sunysb.edu>
Date: 1997/05/05
Message-ID: <336E46F5.5FB0C4A5_at_pine.vpcc.sunysb.edu>#1/1

This is a multi-part message in MIME format. --------------2F1E5CD5088C35EEA3FF3DD3
Content-Type: multipart/alternative; boundary="------------2955C6AB45A2D51E6926E671"

--------------2955C6AB45A2D51E6926E671
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Michael Krolewski wrote:

> Mark McCubbin wrote:
> >
> > I need my VB4 application to "talk" to the Oracle Local Database

that
> > resides on my desktop PC. When I try to open the database from my VB4

> > app, I get the error message "Couldn't find installable ISAM."
> >
> > To setup the data source I double-clicked the ODBC icon in Control

> > Panel, clicked the Add button, chose "Oracle ODBC Driver for Rdb," and

> > keyed in "Local Database" for data source name.
> >
> > The connect code I use in my VB code is
> >
> >     sConnect = "C:\WINDOWS\SYSTEM\ODBC32.DLL;UID=SCOTT;PWD=TIGER"
> >
> >     ' Get ISAM error message on next line...
> >     Set dbPersonInfo = OpenDatabase("Local Database", False,

False,

> > sConnect)
> >
> > If you have any advice, I would appreciate your assistance. Thank

you.

> >
> > Mark
>
> As someone else stated, you need the correct ODBC driver.
> The windows95/NT drivers -- new and improved -- are available on the
>
> oracle web site.
>
> Make sure you pick the correct driver. The new drivers are 32bit.
> For instance Access 2.0 needs 16bit drivers. Access 7.0 up uses
> 32bit drivers.
>
> You generally do not need the class 2 ODBC drivers.
>
> Mike Krolewski mkrolews_at_upw.com

Another important piece of this puzzle is the version of the Oracle server you are connecting to. We have just upgraded to sqlnet2.3, for instance.

Also, if possible, get the Oracle Objects for OLE (OO4O) at the Oracle Web site. Although they do not yet have a 32-bit data control, they do allow access to an Oracle DB programmatically with OraSession, OraDatabase, etc.

Good Luck!

Paul Courtney paul.courtney_at_sunysb.edu

--------------2955C6AB45A2D51E6926E671
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML><BODY>

Michael Krolewski wrote:

<BLOCKQUOTE TYPE=CITE>Mark McCubbin wrote:
 >
 > I need my VB4 application to "talk" to the Oracle Local Database that
 > resides on my desktop PC. When I try to open the database from my

VB4</I>


<BR><I>&gt; app, I get the error message "Couldn't find installable ISAM."</I>

<BR><I>&gt;</I>

<BR><I>&gt; To setup the data source I double-clicked the ODBC icon in Control</I>


<BR><I>&gt; Panel, clicked the Add button, chose "Oracle ODBC Driver for Rdb,"


and</I>


<BR><I>&gt; keyed in "Local Database" for data source name.</I>

<BR><I>&gt;</I>

<BR><I>&gt; The connect code I use in my VB code is</I>

<BR><I>&gt;</I>

<BR><I>&gt;&nbsp;&nbsp;&nbsp;&nbsp; sConnect = "C:\WINDOWS\SYSTEM\ODBC32.DLL;UID=SCOTT;PWD=TIGER"</I>

<BR><I>&gt;</I>

>     ' Get ISAM error message on next line...
 >     Set dbPersonInfo = OpenDatabase("Local Database",
False, False,
 > sConnect)
 >
 > If you have any advice, I would appreciate your assistance. Thank

you.</I>


<BR><I>&gt;</I>

<BR><I>&gt; Mark</I>

<BR>

<BR>As someone else stated, you need the correct ODBC driver.


<BR>The windows95/NT drivers -- new and improved -- are available on the

<BR>oracle web site.

<BR>

<BR>Make sure you pick the correct driver. The new drivers are 32bit.

<BR>For instance Access 2.0 needs 16bit drivers. Access 7.0 up uses

<BR>32bit drivers.

<BR>

<BR>You generally do not need the class 2 ODBC drivers.

 
 Mike Krolewski mkrolews_at_upw.com
</BLOCKQUOTE>
 Another important piece of this puzzle is the version of the Oracle server you are connecting to.  We have just upgraded to sqlnet2.3, for instance.
 
 Also, if possible, get the Oracle Objects for OLE (OO4O) at the Oracle
Web site.  Although they do not yet have a 32-bit data control, they do allow access to an Oracle DB programmatically with OraSession, OraDatabase, etc.
 
 Good Luck!
 
 Paul Courtney  paul.courtney_at_sunysb.edu

</BODY>
</HTML>

--------------2955C6AB45A2D51E6926E671--

--------------2F1E5CD5088C35EEA3FF3DD3
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Courtney, Paul 
Content-Disposition: attachment; filename="vcard.vcf"

begin:vcard

fn:Courtney, Paul

n:Courtney;Paul

org:SUNY Stony Brook

adr:;;Zip-2635;Stony Brook;NY;11794;

email;internet:pcourtney_at_pine.vpcc.sunysb.edu

title:Lead Programmer/Analyst

tel;work:516-632-9241

tel;home:516-727-5051

x-mozilla-cpt:;0

x-mozilla-html:FALSE

end:vcard

--------------2F1E5CD5088C35EEA3FF3DD3-- Received on Mon May 05 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Brad Baker: "Re: ODBC and stored prcoedures OUT parameters and VB"
Previous message: Paul K. Courtney: "Re: Oracle ODBC and Office 97"
Maybe in reply to: Steve Thompson: "Re: Oracle ODBC connection and VB4"
In reply to Michael Krolewski: "Re: Oracle ODBC connection and VB4"
Next in thread: Thomas Kyte: "Re: Winword Documents and Webserver2.0"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message