MSaccess odbc and oracle Connection error: Help!

From: <Sanbyj_at_telkom.co.za>
Date: Thu, 25 Jun 1998 10:46:15 GMT
Message-ID: <6mt9pn$la3$1@nnrp1.dejanews.com>

Hi all

If I link a table in MS Access to Oracle table and choose "save the password". I can look at my data.

Close the Access and reopen the database just closed and try and look at the data, I get a Connection error 3151.

If I leave out the "Save password" when linking the table, I get prompted for the username and password and I can view my data.

ODBC trace log has a ORA-01017 - ( can I monitor what access is sending to odbc?)

I am useing NT4 SP3,
Office proffesional for 97 with SR1,
ODBC core components are all 3.0.28.22

****Extract from Oracle ODBC support assistant********

Type:			SQL*Net v2
ODBC Driver Vendor:	Oracle73
ODBC Driver DLL:		d:\ORANT\ODBC\sqo32_73.dll
Oracle Home:		D:\ORANT
RSF release:		Required Support Files v7.3 for Win95/WinNT (32bit)
Oracle Interface DLL:	ORA73.DLL
  Found at location:		D:\ORANT\BIN\ORA73.DLL
TNSNAMES.ORA file used:	D:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA
Protocol Stack:		tcp
Net Interface DLL:		sqltnsnt.dll
  Found at location:		D:\ORANT\BIN\sqltnsnt.dll
Net Adapter DLL:		nttnt.dll
  Found at location:		D:\ORANT\BIN\nttnt.dll

Any help will be greatly appreciated.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 25 1998 - 05:46:15 CDT