ODBC Call -- Failed

[mukeshhtrivedi]

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

[mukeshhtrivedi]

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

[Rick Brandt]

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

[mukeshhtrivedi]

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

[Rick Brandt]

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

[mukeshhtrivedi]

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

[Rick Brandt]

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

[mukeshhtrivedi]

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

[mukeshhtrivedi]

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

[Rick Brandt]

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

[mukeshhtrivedi]

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

[Rick Brandt]

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

[mukeshhtrivedi]

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