We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The database
(mdb) was installed in
remote client machines working with Access2000 and it worked fine.
When the query was put on an Access2002 machine, it came up with
"ORA-01017 invalid logon/password", and fails. The failing machine
passes other queries and operations with the same Oracle database
without problem.
Any help is appreciated. 8 2014
mainframetech wrote:
We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The database
(mdb) was installed in
remote client machines working with Access2000 and it worked fine.
When the query was put on an Access2002 machine, it came up with
"ORA-01017 invalid logon/password", and fails. The failing machine
passes other queries and operations with the same Oracle database
without problem.
Any help is appreciated.
Is the query created in the query builder or via handcode? If handcode,
is it possible something is misspelled? An incorrect reference?
Since it's multi-file, perhaps send the user a set of that
queries...each query truncate/remove one table and column references to
that table. You might find which table it's bombing out on.
Maybe delete, then compact, then rewrite the query from scratch.
On Apr 19, 12:56 pm, salad <o...@vinegar.c omwrote:
mainframetech wrote:
We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The database
(mdb) was installed in
remote client machines working with Access2000 and it worked fine.
When the query was put on an Access2002 machine, it came up with
"ORA-01017 invalid logon/password", and fails. The failing machine
passes other queries and operations with the same Oracle database
without problem.
Any help is appreciated.
Is the query created in the query builder or via handcode? If handcode,
is it possible something is misspelled? An incorrect reference?
Since it's multi-file, perhaps send the user a set of that
queries...each query truncate/remove one table and column references to
that table. You might find which table it's bombing out on.
Maybe delete, then compact, then rewrite the query from scratch.
All the simple stuff has been checked into. The mdb with the
query is created on Access2000 and tested here and at the client
location on an Access2000 machine. This runs fine. When put on an
Access2002 machine at the client location, it fails with the logon/
password error (ORA-01017) almost immediately.
Chris
mainframetech wrote:
On Apr 19, 12:56 pm, salad <o...@vinegar.c omwrote:
>>mainframete ch wrote:
>>>We are having a problem with Access 2002 as opposed to Access 2000. A multi-file query was set up under 2000 and tested good. Access is connected through a link to an Oracle 9.1 database. The database (mdb) was installed in remote client machines working with Access2000 and it worked fine. When the query was put on an Access2002 machine, it came up with "ORA-01017 invalid logon/password", and fails. The failing machine passes other queries and operations with the same Oracle database without problem.
>> Any help is appreciated.
Is the query created in the query builder or via handcode? If handcode, is it possible something is misspelled? An incorrect reference?
Since it's multi-file, perhaps send the user a set of that queries...eac h query truncate/remove one table and column references to that table. You might find which table it's bombing out on.
Maybe delete, then compact, then rewrite the query from scratch.
All the simple stuff has been checked into. The mdb with the
query is created on Access2000 and tested here and at the client
location on an Access2000 machine. This runs fine. When put on an
Access2002 machine at the client location, it fails with the logon/
password error (ORA-01017) almost immediately.
Chris
I don't know your setup. Does the remote site have multiple users? If
so, is it only 1 user that has a problem? Is he/she the only person
using A2002? Does that person have A2000? Does it work on that machine
with A2000 but rejects A2002?
Again, since it's a multi-table query, can that person access each table
in a simple SQL Select?
I went to http://groups.google.com/advanced_search?q=&
and entered
ora-01017 ora01017
in the With At Least One Word box and entered
*Oracle*
in the groups box and searched.
There's 271 messages you can browse, one of them may turn the lightbulb on.
On Apr 20, 9:27 pm, salad <o...@vinegar.c omwrote:
mainframetech wrote:
On Apr 19, 12:56 pm, salad <o...@vinegar.c omwrote:
>mainframetec h wrote:
>>We are having a problem with Access 2002 as opposed to Access 2000. A multi-file query was set up under 2000 and tested good. Access is connected through a link to an Oracle 9.1 database. The database (mdb) was installed in remote client machines working with Access2000 and it worked fine. When the query was put on an Access2002 machine, it came up with "ORA-01017 invalid logon/password", and fails. The failing machine passes other queries and operations with the same Oracle database without problem.
> Any help is appreciated.
>Is the query created in the query builder or via handcode? If handcode, is it possible something is misspelled? An incorrect reference?
>Since it's multi-file, perhaps send the user a set of that queries...ea ch query truncate/remove one table and column references to that table. You might find which table it's bombing out on.
>Maybe delete, then compact, then rewrite the query from scratch.
All the simple stuff has been checked into. The mdb with the
query is created on Access2000 and tested here and at the client
location on an Access2000 machine. This runs fine. When put on an
Access2002 machine at the client location, it fails with the logon/
password error (ORA-01017) almost immediately.
Chris
I don't know your setup. Does the remote site have multiple users? If
so, is it only 1 user that has a problem? Is he/she the only person
using A2002? Does that person have A2000? Does it work on that machine
with A2000 but rejects A2002?
Again, since it's a multi-table query, can that person access each table
in a simple SQL Select?
I went to http://groups.google.com/advanced_search?q=&
and entered
ora-01017 ora01017
in the With At Least One Word box and entered
*Oracle*
in the groups box and searched.
There's 271 messages you can browse, one of them may turn the lightbulb on.- Hide quoted text -
- Show quoted text -
They have already tried accessing each table directly, which works
fine. We have tried it on other machines that have Access2000, and it
works fine. Only under Access2002 does it fail. the machine at the
client site has only one user. I've gone through the MS Knowledge
Base, but don't see anything there.
Chris
mainframetech wrote:
On Apr 20, 9:27 pm, salad <o...@vinegar.c omwrote:
>>mainframete ch wrote:
>>>On Apr 19, 12:56 pm, salad <o...@vinegar.c omwrote:
>>>>mainframete ch wrote:
>>>>>We are having a problem with Access 2002 as opposed to Access 2000. >A multi-file query was set up under 2000 and tested good. Access is >connecte d through a link to an Oracle 9.1 database. The database >(mdb) was installed in >remote client machines working with Access2000 and it worked fine. >When the query was put on an Access2002 machine, it came up with >"ORA-01017 invalid logon/password", and fails. The failing machine >passes other queries and operations with the same Oracle database >without problem.
>>>> Any help is appreciated.
>>>>Is the query created in the query builder or via handcode? If handcode, is it possible something is misspelled? An incorrect reference?
>>>>Since it's multi-file, perhaps send the user a set of that queries...e ach query truncate/remove one table and column references to that table. You might find which table it's bombing out on.
>>>>Maybe delete, then compact, then rewrite the query from scratch.
>> All the simple stuff has been checked into. The mdb with the query is created on Access2000 and tested here and at the client location on an Access2000 machine. This runs fine. When put on an Access2002 machine at the client location, it fails with the logon/ password error (ORA-01017) almost immediately.
>>>Chris
I don't know your setup. Does the remote site have multiple users? If so, is it only 1 user that has a problem? Is he/she the only person using A2002? Does that person have A2000? Does it work on that machine with A2000 but rejects A2002?
Again, since it's a multi-table query, can that person access each table in a simple SQL Select?
I went to http://groups.google.com/advanced_search?q=& and entered ora-01017 ora01017 in the With At Least One Word box and entered *Oracle* in the groups box and searched.
There's 271 messages you can browse, one of them may turn the lightbulb on.- Hide quoted text -
- Show quoted text -
They have already tried accessing each table directly, which works
fine. We have tried it on other machines that have Access2000, and it
works fine. Only under Access2002 does it fail. the machine at the
client site has only one user. I've gone through the MS Knowledge
Base, but don't see anything there.
Chris
If none of the Google group messages had anything that pointed to an
solution then you might get a response in an Oracle forum.
Is it possible there is a driver incompatability ? At this point I'm
clutching at straws. You too probably.
MDB isn't reliable
it is a TOY database
On Apr 19, 8:33 am, mainframetech <chough...@insi defsi.netwrote:
We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The database
(mdb) was installed in
remote client machines working with Access2000 and it worked fine.
When the query was put on an Access2002 machine, it came up with
"ORA-01017 invalid logon/password", and fails. The failing machine
passes other queries and operations with the same Oracle database
without problem.
Any help is appreciated.
On Apr 23, 7:17 pm, "Susie DBA [MSFT]" <susie...@hotma il.comwrote:
MDB isn't reliable
it is a TOY database
On Apr 19, 8:33 am, mainframetech <chough...@insi defsi.netwrote:
We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The database
(mdb) was installed in
remote client machines working with Access2000 and it worked fine.
When the query was put on an Access2002 machine, it came up with
"ORA-01017 invalid logon/password", and fails. The failing machine
passes other queries and operations with the same Oracle database
without problem.
Any help is appreciated.- Hide quoted text -
- Show quoted text -
Thanks Susie, but that's what I have, and that's what I need a
suggestion for.
Chris
On Apr 23, 7:17 pm, "Susie DBA [MSFT]" <susie...@hotma il.comwrote:
MDB isn't reliable
it is a TOY database
On Apr 19, 8:33 am, mainframetech <chough...@insi defsi.netwrote:
We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The database
(mdb) was installed in
remote client machines working with Access2000 and it worked fine.
When the query was put on an Access2002 machine, it came up with
"ORA-01017 invalid logon/password", and fails. The failing machine
passes other queries and operations with the same Oracle database
without problem.
Any help is appreciated.- Hide quoted text -
- Show quoted text -
Thanks for the help Susie. Access 2002 is what we have, and what we
have to debug.
Chris This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: deko |
last post by:
After doing a lot of vba work, I've noticed the size of my mdb has grown,
even though no data or objects have been added.
I've read that the following procedure will remedy this and improve
performance:
1. From the command line, type msaccess.exe /decompile.
2. Open the database you want to decompile.
3. Open up any module. Select the...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much appreciated.
Thanks in advance
|
by: Roald Oines |
last post by:
Hi,
I'm working on converting several of my Access 97 databases to Access
2002 format (the company's changing from NT 4 to XP and updating Office
at the same time), and this one has me stumped. As a performance
enhancer, I use VBA code (transfertext) to export the results of a query
(usually 20-30 thousand rows with a few dozen fields of...
|
by: James P. |
last post by:
Hello there,
I'd like to have my minutes convert to hours and minutes in Access
report in this format: hh:mm. For examples: 150 minutes converts to
2:30. I have this formula below used to work with my machine using
Access 2002 SP3.
=\60 & Format( Mod 60,"\:00")
However, if I run it on someone else's machine who has a newer
|
by: monnomiznogoud |
last post by:
Ok, my problem is the following:
I have very complicated Access 97 databases that link through ODBC to
Sybase databases.
Now in some of the forms controls I had queries that used as "where
clause" parameters form field values; For example:
select foo from bar where a_colmun = !!
| |
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access...
|
by: raylopez99 |
last post by:
I'm having problems compiling complex reference declarations in
MSVC++.NET 2002 IDE.
Here is an example:
// --Foo.h--
#include "Bar.h"
class Bar; //forward decl. to a class Bar in another file, not used
|
by: Frav |
last post by:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access...
|
by: Sebastian |
last post by:
Hello
I develop my applications in Access 2002. My development system is
running Windows XP SP2 and I have Microsoft Office XP Developer.
Microsoft Office XP is at SP3.
I used Inno Setup (great product) to install my applications.
When the Access Runtime was needed on the system I simply ran
'accessrt.msi' from Microsoft Office Developer...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |