473,372 Members | 1,224 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

ODBC -- call failed Error

I have an Access 2000 database that links several tables from Oracle 9.
For some reason or another, one of our user repeatedly gets the
following error when accessing queries within this database:
************************************************** **********************************
ODBC -call failed.

[Oracle][ODBC]ORA-01017: invalid username/password; logon denied
(#1017)[Microsoft][ODBC Driver Manger] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (#0)

************************************************** **********************************
I can access this database with no problems. When I try to recreate a
new database for her and re-link these table it seems to work okay for
several try and the error would pop-up again. It looks like this error
is specific to her machine. Anyone know why or how to fix this
problem? She's had problem with this error for all of her access
databases that are connecting to an Oracle server. Any information
would be appreciated.

Jan 12 '07 #1
4 11602

alegria4ever wrote:
I have an Access 2000 database that links several tables from Oracle 9.
For some reason or another, one of our user repeatedly gets the
following error when accessing queries within this database:
************************************************** **********************************
ODBC -call failed.

[Oracle][ODBC]ORA-01017: invalid username/password; logon denied
(#1017)[Microsoft][ODBC Driver Manger] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (#0)
I have had similar problems with connecting to an MS SQL database. I
found that I had to create a login for the user in sql.

>
************************************************** **********************************
I can access this database with no problems. When I try to recreate a
new database for her and re-link these table it seems to work okay for
several try and the error would pop-up again. It looks like this error
is specific to her machine. Anyone know why or how to fix this
problem? She's had problem with this error for all of her access
databases that are connecting to an Oracle server. Any information
would be appreciated.
Another issue could be that you do not have the ODBC setup under system
dsn.

Jan 12 '07 #2
alegria4ever wrote:
[Oracle][ODBC]ORA-01017: invalid username/password; logon denied
(#1017)[Microsoft][ODBC Driver Manger] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (#0)
Looks like you're using the MS Oracle driver. Try the Oracle driver.

The error message seems to indicate that the password for the Oracle
user is not correct. Have you examined the DSN she is using? Most
important, does tnsnames.ora have the correctnet service name set up on
the machine for her user name?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Jan 14 '07 #3
Yes, I have examed her DSN and even replicated the one on my machine to
hers. That didn't fix the problem either. The password she's using is
correct, we've tested that many times. I think the tnsnames.ora file
is correct because she was able to access the database with no problems
for several times.

Tim Marshall wrote:
alegria4ever wrote:
[Oracle][ODBC]ORA-01017: invalid username/password; logon denied
(#1017)[Microsoft][ODBC Driver Manger] Driver's SQLSetConnectAttr
failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (#0)

Looks like you're using the MS Oracle driver. Try the Oracle driver.

The error message seems to indicate that the password for the Oracle
user is not correct. Have you examined the DSN she is using? Most
important, does tnsnames.ora have the correctnet service name set up on
the machine for her user name?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Jan 16 '07 #4
alegria4ever wrote:
Yes, I have examed her DSN and even replicated the one on my machine to
hers. That didn't fix the problem either. The password she's using is
correct, we've tested that many times. I think the tnsnames.ora file
is correct because she was able to access the database with no problems
for several times.
What I would do next then, is repeat the problem on her machine, ie,
relink the tables and then work the app for several tries until the
ora-01017 error occurs again. As soon as it does, on her machine, open
SQL Plus (I always make sure I install this on my users' machines along
with the Oracle net client and the Oracle ODBC driver - if you don't
have it on her machine, it can be installed from the Oracle set up cd)
using the same user name used by the DSN and the password. If this
latter action causes problems, then it's something to do with the net
client installation, a conflict or something and you're into Oracle
territory I don't usually tread (or troubleshoot, at least). Another
possible alternative to testing with SQL Plus is tnsping (but I haven't
done this since it used to be done at the command prompt in Oracle
7.3.4, so I don't remember how to do it).

Anyway, if SQL Plus connects to the database/user name successfully,
then there's something screwy with Access 2000 and again, I'm sorry, I'm
out of my area of expertise (I went from A97 to A2003 and didn't use
either 2000 or 2002).

Hope this is of some help, at least for further trouble shooting. 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Jan 16 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Vic Spainhower | last post by:
Hello, This is probably not the correct forum to post this problem but I posted it in the Access group but didn't get a reply and I'd like to move forward on this. I have setup an ODBC...
7
by: tina | last post by:
Hello, Can you hale me to define my mistake please? I am trying to run a SQL Pass Through Query from Access 2000 and inside the record set I am trying to loop for a LoginID. I think that this...
14
by: Abhi | last post by:
FYI: This message is for the benefit of MS Access Community. I found that this prblem has been encounterd by many but there is hardly any place where a complete solution is posted. So I thought...
1
by: VBSponge | last post by:
Hi all. Need help here as I cant see whats wrong... I have a querydef in Access 2k which execs a stored proc in a SQL Server 2k db. I keep getting the following error, and cant stop it for the...
2
by: Jimbo | last post by:
I have an access 97 database linked to sql server..I click update on a form and get an error message: Run-time error 3146 ODBC call failed The debugger points to this line: MyTable.Update
0
by: bazzer | last post by:
hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in...
12
by: mukeshhtrivedi | last post by:
We have 4 MS Access Databases with few tables on each DB. There are some reports which uses ODBC. When I try to use the report and input date range and click ok I get error "ODBC --call failed" it...
11
by: Kirby1 | last post by:
ODBC call failed -------------------------------------------------------------------------------- We have recently upgraded our SQL Server from 7.0 to 2000. Since then my Access database to...
1
by: mikerudy | last post by:
I have an 3rd-party application that uses a SQL back-end, but uses Access 2000 (linked tables all using the same DSN) as an intermediary. We recently upgraded from SQL 7 to SQL 2005, which went...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.