From: "John Powell" Subject: Re: Access 2 to Oracle database via ODBC reports error -7751 Date: 1998/09/09 Message-ID: #1/1 Content-Transfer-Encoding: 7bit References: <35f6c90b.587464@read.news.globalnet.co.uk> Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 X-Complaints-To: abuse@visi.com X-Trace: ptah.visi.com 905373960 138.64.19.158 (Wed, 09 Sep 1998 15:46:00 CDT) MIME-Version: 1.0 NNTP-Posting-Date: Wed, 09 Sep 1998 15:46:00 CDT Newsgroups: microsoft.public.vb.database.odbc,comp.databases.ms-access,microsoft.public.vb.database,microsoft.public.access.multiuser,comp.databases.oracle.server Have you verified that all your Oracle stuff is installed correctly using TNS Ping (to test the SQL-Net) and ODBC Test (to test, of course, the ODBC)? If those test out OK, then the next question is: Have you installed the Access 2.0 Service Pack? It's free, available from Microsoft. Check out Dev's or Tony's page. Links provided on my page below. This service pack has corrected a couple ODBC problems for us - as a matter of fact, ones that didn't show up until we started hitting a 7.3.3 database. So I hope it works for you. -- HTH, John Powell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You can believe anything you want. The universe is not obliged to keep a straight face. This page contains links to many MS Access FAQ's and resources (including places to post job related ads, which do NOT belong here!). http://www.wavefront.com/~pow/johnmsaccess.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Adrian Harrison wrote in message <35f6c90b.587464@read.news.globalnet.co.uk>... >Sorry if this is in the wrong group! > >Running on win 3.11 > >Trying to attach some tables to an Access 2 database from an Oracle 7.3.3 database! > >Using the latest ODBC driver from Oracle's web site but keeps coming up with error -7751 and no >description. > >What's funny is that when entering the connection details if I delibrately enter the wrong password >Access reports this. If I enter the correct one is waitr a bit longer then reports trhe above error >message > >It must be talking to the Oracle database to know that the password was incorrect! > >Any ideas > >Thanks > >A.H >Thanks in advance! > >A.H