By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,490 Members | 3,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,490 IT Pros & Developers. It's quick & easy.

ODBC Call -- Failed

P: n/a
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 happens on
my computer only. I have just setup Windows XP SP2 with latest updates
and MS Office Prof. 2000 and in ODBC I have same dirvers installed as
other users who are able to access reports without any problem.

Can anybody tell me what setting I need to do on my computer.

Thanks,
Mukesh

Jul 14 '06 #1
Share this Question
Share on Google+
12 Replies


P: n/a
mu************@gmail.com wrote:
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 happens on
my computer only. I have just setup Windows XP SP2 with latest updates
and MS Office Prof. 2000 and in ODBC I have same dirvers installed as
other users who are able to access reports without any problem.

Can anybody tell me what setting I need to do on my computer.

Thanks,
Mukesh
Jul 17 '06 #2

P: n/a
mu************@gmail.com wrote:
mu************@gmail.com wrote:
>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 happens
on my computer only. I have just setup Windows XP SP2 with latest
updates and MS Office Prof. 2000 and in ODBC I have same dirvers
installed as other users who are able to access reports without any
problem.

Can anybody tell me what setting I need to do on my computer.

Thanks,
Mukesh
ODBC Call Failed is a completely generic message that is often followed by
another message containing the specific error. For a report I would expect
the problem to be not having SELECT permissions on the database or table
being read.

What kind of ODBC connection is it? SQL Server? Oracle?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 17 '06 #3

P: n/a
It is MS Access only.
Thanks, Mukesh

Rick Brandt wrote:
mu************@gmail.com wrote:
mu************@gmail.com wrote:
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 happens
on my computer only. I have just setup Windows XP SP2 with latest
updates and MS Office Prof. 2000 and in ODBC I have same dirvers
installed as other users who are able to access reports without any
problem.

Can anybody tell me what setting I need to do on my computer.

Thanks,
Mukesh

ODBC Call Failed is a completely generic message that is often followed by
another message containing the specific error. For a report I would expect
the problem to be not having SELECT permissions on the database or table
being read.

What kind of ODBC connection is it? SQL Server? Oracle?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 17 '06 #4

P: n/a
mu************@gmail.com wrote:
It is MS Access only.
Thanks, Mukesh
You cannot link from one Access file to another using ODBC. That has always
been the case so either it is not working on anyone else's computer or you
are not describing the situation accurately.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 17 '06 #5

P: n/a
Rick sorry but may be I am able to explain or what.

Let me tell you that we have MS Access DB for sales group and have
Timberline Accounting software both are linked I believe for some
reports but I don't know it has to do with particular report which I am
trying to access. I no basic about access not expert level. I have
installed Timberline Accounting software which works fine and Sales
software (MS Access) also. But I am not able to access this report and
I don't know about other reports as I never touched.

Hope this explains.
Mukesh
Rick Brandt wrote:
mu************@gmail.com wrote:
It is MS Access only.
Thanks, Mukesh

You cannot link from one Access file to another using ODBC. That has always
been the case so either it is not working on anyone else's computer or you
are not describing the situation accurately.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 17 '06 #6

P: n/a
mu************@gmail.com wrote:
Rick sorry but may be I am able to explain or what.

Let me tell you that we have MS Access DB for sales group and have
Timberline Accounting software both are linked I believe for some
reports but I don't know it has to do with particular report which I
am trying to access. I no basic about access not expert level. I have
installed Timberline Accounting software which works fine and Sales
software (MS Access) also. But I am not able to access this report and
I don't know about other reports as I never touched.

Hope this explains.
Mukesh
What makes the most sense then is that you have ODBC links to the data in your
Tinmberline Accounting software, and that on your PC something is not set up
correctly or you do not have sufficient permissions to that ODBC data source. I
have no idea what king of data table that Timberline is using. You might have
to ask them or at least examine the links to those table to see how the links
are connected.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 17 '06 #7

P: n/a
Thanks Rick.
Mukesh

Rick Brandt wrote:
mu************@gmail.com wrote:
Rick sorry but may be I am able to explain or what.

Let me tell you that we have MS Access DB for sales group and have
Timberline Accounting software both are linked I believe for some
reports but I don't know it has to do with particular report which I
am trying to access. I no basic about access not expert level. I have
installed Timberline Accounting software which works fine and Sales
software (MS Access) also. But I am not able to access this report and
I don't know about other reports as I never touched.

Hope this explains.
Mukesh

What makes the most sense then is that you have ODBC links to the data in your
Tinmberline Accounting software, and that on your PC something is not set up
correctly or you do not have sufficient permissions to that ODBC data source. I
have no idea what king of data table that Timberline is using. You might have
to ask them or at least examine the links to those table to see how the links
are connected.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 18 '06 #8

P: n/a
I have Dell Laptop XP SP2 and where I havne't installed Timberline
Accounting software and My MS Access Database is on File Server and I
have mapped that drive and when I use Reports I get the same error.
(ODBC Call--failed).

Thanks,
Mukesh
mu************@gmail.com wrote:
Thanks Rick.
Mukesh

Rick Brandt wrote:
mu************@gmail.com wrote:
Rick sorry but may be I am able to explain or what.
>
Let me tell you that we have MS Access DB for sales group and have
Timberline Accounting software both are linked I believe for some
reports but I don't know it has to do with particular report which I
am trying to access. I no basic about access not expert level. I have
installed Timberline Accounting software which works fine and Sales
software (MS Access) also. But I am not able to access this report and
I don't know about other reports as I never touched.
>
Hope this explains.
Mukesh
What makes the most sense then is that you have ODBC links to the data in your
Tinmberline Accounting software, and that on your PC something is not set up
correctly or you do not have sufficient permissions to that ODBC data source. I
have no idea what king of data table that Timberline is using. You might have
to ask them or at least examine the links to those table to see how the links
are connected.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 18 '06 #9

P: n/a
mu************@gmail.com wrote:
I have Dell Laptop XP SP2 and where I havne't installed Timberline
Accounting software and My MS Access Database is on File Server and I
have mapped that drive and when I use Reports I get the same error.
(ODBC Call--failed).
If a specific ODBC source is required in an Access file thgat you are
running from a server you still need that ODBC driver and DSN (if used) on
YOUR PC. That is not something that is inherited from the server.

If other users can open that report without getting an ODBC error it is
because they have installed or set up something to handle the ODBC
connection on their individual PCs. You will have to do the same on yours.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 18 '06 #10

P: n/a
Thanks Rick for your help. I know that I need to do the ODBC settings
but I have compared the ODBC setting (with users computer who can
access the report )and it is the same on my computer.

Mukesh
Rick Brandt wrote:
mu************@gmail.com wrote:
I have Dell Laptop XP SP2 and where I havne't installed Timberline
Accounting software and My MS Access Database is on File Server and I
have mapped that drive and when I use Reports I get the same error.
(ODBC Call--failed).

If a specific ODBC source is required in an Access file thgat you are
running from a server you still need that ODBC driver and DSN (if used) on
YOUR PC. That is not something that is inherited from the server.

If other users can open that report without getting an ODBC error it is
because they have installed or set up something to handle the ODBC
connection on their individual PCs. You will have to do the same on yours.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 19 '06 #11

P: n/a
mu************@gmail.com wrote:
Thanks Rick for your help. I know that I need to do the ODBC settings
but I have compared the ODBC setting (with users computer who can
access the report )and it is the same on my computer.
If you are looking at the ODBC settings then you must know what kind of
connection to is. What ODBC driver is it? It will NOT be the Access ODBC
driver. There should be some other kind of ODBC that is being used to
connect to your other software package.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 20 '06 #12

P: n/a
Thanks Rick for your help. I will talk to Timberline Tech Support and
will see if they can help me.

Mukesh
Rick Brandt wrote:
mu************@gmail.com wrote:
Thanks Rick for your help. I know that I need to do the ODBC settings
but I have compared the ODBC setting (with users computer who can
access the report )and it is the same on my computer.

If you are looking at the ODBC settings then you must know what kind of
connection to is. What ODBC driver is it? It will NOT be the Access ODBC
driver. There should be some other kind of ODBC that is being used to
connect to your other software package.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 20 '06 #13

This discussion thread is closed

Replies have been disabled for this discussion.