Xref: alice comp.databases.oracle.server:46134 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.amsterdam.nl.net!sun4nl!zonnetje.nl.net!not-for-mail From: Frank van Bortel Newsgroups: comp.databases.oracle.server Subject: Re: Dev. 2000 unable to connect to backend Date: Fri, 16 Apr 1999 12:59:42 +0200 Organization: V&L Informatica BV Lines: 39 Message-ID: <3717181E.9B2B0450@vnl.nl> References: <37161a49.0@ruby.hknet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: zonnetje.NL.net 924260519 2623 212.206.52.162 (16 Apr 1999 11:01:59 GMT) X-Complaints-To: abuse@nl.uu.net NNTP-Posting-Date: 16 Apr 1999 11:01:59 GMT X-Mailer: Mozilla 4.51 [en] (WinNT; I) X-Accept-Language: en 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@odbc:dbname as > scott/tiger@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