Re: Newbie: ODBC & VB & ORACLE

Erik Oosterling wrote:
>
> Hello there,
>
> I got a question. I want to write a VB program using oracle. I believe
> that i need to use ODBC. But what do i have to do to make this work ?
>
> BTW
>
> i don't know nothing about ODBC !

First, you have to create an alias with SQL*Net Easy Configuration. This is the "CONNECT STRING" required in the ODBC DSN entry.

Install an ORACLE ODBC driver, there is one supplied with the ORACLE release CD, but the 7.3.3 version does not always load on Win95 machines.

Then, create a Data Source Name (DSN) using the 32-bit ODBC tool either in the ORACLE for Windows xx menu or the Control Panel.

Name a DSN, select the desired Oracle driver, and supply the Connect String (SQL*Net alias).

Then in your VB program's ODBC connect function supply the string "ODBC;DSN=<the 32-bit ODBC DSN>;uid=<Oracle username>;pwd=<Oracle Password"

This ends the easy part.

Good luck, Received on Wed Sep 24 1997 - 00:00:00 CDT