Re: Help: Access 2.0 and Oracle7 problem

Well I got MS Access 2.0 to talk to Oracle 7 at last with Openlink ODBC! Thanks to all your help here on the net.

Now I have a new problem: I can not connect to the Oracle DB using Visual Basic 4.0.

I set the VB4 data control to use Access 2.0 database that I creadted with 2 Oracle database attached via Openlink ODBC. After the Oracle log-on, I kept getting back an error "ODBC-connection to 'Oracle7' failed."

I'll post the same message on the VB forum to see if anyone lese had the same problem.

Vandra Huber <vandra_at_u.washington.edu> wrote:

>lh_at_earthlink.net wrote:
>>
>> Crystal Report is also 16 bit (came with VB4 Pro16 bit)
>>
>> I ran ODBCTest and got connected just fine. Looks like the problem
>> lies with MS Access. Wonder if the Jet engine got anything to do with
>> this?
>>
>> paulj_at_sterlingcomp.co.uk (PJ) wrote:<<snip>>
>>
 

>I recall that the ODBC Test worked the first time even when the
>system was broken... Had you tried connecting/disconnecting/reconnecting.
 

>Also -- we noticed a problem with Access if the original connection
>of tables is done remembering the login/password. The original author
>or user could do anything. Any one else had problems.
 

>Please note: our system is running fine. No problems -- except running
>out of memory when creating massive reports....
 

>Mike Krolewski mkrolews_at_upw.com
Received on Thu Jul 18 1996 - 00:00:00 CEST