I have Access 97 installed on Windows NT 4 Workstation. I have an Access database that is supposed to connect to an Oracle database on a server in another location.
I open Access (it shows the login page), enter a valid ID and password, and it goes to the next logical screen, but then shows an hourglass - and that's where it stays. No error message - nothing.
Oracle connectivity is there - I can do a TNSPING and get to the server, and I can run Oracle Test or SQL Plus and run a query against the Oracle server with no problem. The issue seems to be with Access 97.
Is this an ODBC issue? How can I troubleshoot Access 97 to find out what's happening in the background? My knowledge about these things is next to zero, and I could not find much help by using Technet or other web/printed sources.
Any ideas? Thanks.
I open Access (it shows the login page), enter a valid ID and password, and it goes to the next logical screen, but then shows an hourglass - and that's where it stays. No error message - nothing.
Oracle connectivity is there - I can do a TNSPING and get to the server, and I can run Oracle Test or SQL Plus and run a query against the Oracle server with no problem. The issue seems to be with Access 97.
Is this an ODBC issue? How can I troubleshoot Access 97 to find out what's happening in the background? My knowledge about these things is next to zero, and I could not find much help by using Technet or other web/printed sources.
Any ideas? Thanks.