Re: Help: Connection to Oracle tables via ODBC/JET/DAO

Benutzerzentrum wrote:
>
> Does anybody have the same problem: I'm trying to connect to an Oracle
> 7.3 DB with Visual Basic 4. The Oracle tables are attached to a Jet MDB
> which I then try to access by using a DAO in my VB program. But I keep
> getting "ODBC connection to <ODBC-Data-Source> failed".
>
> Funny thing: I have no problems connecting to a native Jet Table,
> created using MS-Access 2 within the same MDB.
>
> If you should happen to know a solution, please e-mail me at
>
> kurt.inalbon_at_lonza.ch
>
> Thanks a lot in advance!
>
> Kurt In Albon
> Lonza AG Fine Chemicals
> Lonzastrasse
> CH-3930 Visp
> Switzerland

Since you are using MS-Access 2.0 and Oracle v7.3, I suspect the ODBC driver you are using is not compatible with Oracle 7.3. We have an older application in house that uses VB against Oracle tables attached through MS-Access 2.0. When we upgraded our Oracle installation to 7.3, we had to upgrade our ODBC drivers.

Oracle 7.3 requires SQL*Net 2.x, it will not work with SQL*Net 1.x. In order to get our VB app to work against MS-Access 2.0, I use Oracle ODBC 7.1 or higher and the 16bit version of SQL*Net 2.x. Hope this helps.

-- 
Dennis Wetherell
Wetherell#m#_Dennis_G_at_msmail.aai.arco.com