Solved

Query Error in Access

Posted on 2002-06-26
7
245 Views
Last Modified: 2008-02-01
Hi All,
I am trying to query an Oracle database throught Access' SQL. I have setup my ODBC driver and DSN but I keep getting this error:

ODBC - call failed
[Microsoft][ODBC Driver Manager] Driver's SQL Set ConnectAttr failed (#0)[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed(#0)[Microsoft][ODBC driver for Oracle] Invalid connection string attribute (#0)

Thanxs
0
Comment
Question by:Animalcar
7 Comments
 
LVL 6

Expert Comment

by:xSinbad
Comment Utility
How have you connected to the database, linked tables or through code?
0
 

Author Comment

by:Animalcar
Comment Utility
I haven't linked the databases. But I want to. I'm guessing that it would have to be done using code. The Oracle dbase runs a UNIX shell.
0
 
LVL 6

Expert Comment

by:xSinbad
Comment Utility
So do you get this error when you try to link or when you create the DSN?
If the DSN creates successfully does it test OK?

The best way is to go with DSNless connections if possible using some simple code.

Cheers
Marcus
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Animalcar
Comment Utility
The DSN is created successfully and it does connect successfully I tested it in Net8 easy config. I'm getting the error when I try to link. I don't think I will be able to connect DSNless the two Dbases must be linked.

Cheers to you,
Jorge
0
 
LVL 6

Accepted Solution

by:
xSinbad earned 100 total points
Comment Utility
If you dont use the Oracle ODBC driver (MS is default) then use that, you can get it from Oracle.


Cheers
Marcus
0
 
LVL 44

Expert Comment

by:bruintje
Comment Utility
Hello Animalcar

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-PAQ
-points to xSinbad
-this will be finalized by an EE Moderator
-with no further update (19.10.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0
0
 
LVL 1

Expert Comment

by:Computer101
Comment Utility
Comment from expert accepted as answer

Computer101
E-E Admin
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Article by: dandraka
There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now