Re: Dev. 2000 unable to connect to backend

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 16 Apr 1999 12:59:42 +0200
Message-ID: <3717181E.9B2B0450@vnl.nl>

Hameed wrote:

> Hi,
>
> I have installed Dev. 2000 in a stand alone machine and tried to connect
> to the MS Access back end.
>
> Created a user DSN using MS Access ODBC driver. In the connect dialog box
> of Form Builder I have entered username/password_at_odbc:dbname as
> scott/tiger_at_odbc:Msaccess. It says no error during connect but when I am
> going
> create a data block the no tables in the database are listed. But there are
> many tables in the database. (Problem 1)
>

I guess developer relies on the Oracle structure to retrieve the tables, and it

will probably not know how to retrieve Access tables

> I can connect the MSAccess ODBC database using SQL Plus 3.3(can select rows
> from the table) but not through SQL Plus 8.0. (Problem 2)
>

What is/are the error(s)?

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046

Received on Fri Apr 16 1999 - 05:59:42 CDT