ODBC-call failed.

[Guest]

I am running a query in access XP, the database is link a table in SQL server
DB, the query is simple "group by" query as following:

SELECT dbo_NF.MNFTIMC
FROM dbo_NF
GROUP BY dbo_NF.MNFTIMC;

dbo_NF is link table in SQL server database

Everytime I ran this query, I got following error message:

ODBC-call failed.
[Microsofet][ODBC SQL Server Drive]Timeout expired (#0)

I can't figure out why? Can anyone help me to solve this question? Thanks

 

[Jeff Boyce]

If you take the error message fairly literally, the SQL/query is taking too
long and the server is timing it out.

How many rows are in this table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

I'll also point out that if the SQL server table is not indexed on the field
you are GROUPing BY, you are asking the server to do a lot of work
(depending on size of the table).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks for the response. This is huge table contain 26M records. But the
questions is when I did the similar query for another field, I got result
without the error message. Any reason?

If you take the error message fairly literally, the SQL/query is taking too
long and the server is timing it out.

How many rows are in this table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running a query in access XP, the database is link a table in SQL
server
DB, the query is simple "group by" query as following:

SELECT dbo_NF.MNFTIMC
FROM dbo_NF
GROUP BY dbo_NF.MNFTIMC;

dbo_NF is link table in SQL server database

Everytime I ran this query, I got following error message:

ODBC-call failed.
[Microsofet][ODBC SQL Server Drive]Timeout expired (#0)

I can't figure out why? Can anyone help me to solve this question? Thanks

 

[Jeff Boyce]

Nothing right off the top. Is the "other field" indexed in the SQL Server
data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the response. This is huge table contain 26M records. But the
questions is when I did the similar query for another field, I got result
without the error message. Any reason?

If you take the error message fairly literally, the SQL/query is taking
too
long and the server is timing it out.

How many rows are in this table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running a query in access XP, the database is link a table in SQL
server
DB, the query is simple "group by" query as following:

SELECT dbo_NF.MNFTIMC
FROM dbo_NF
GROUP BY dbo_NF.MNFTIMC;

dbo_NF is link table in SQL server database

Everytime I ran this query, I got following error message:

ODBC-call failed.
[Microsofet][ODBC SQL Server Drive]Timeout expired (#0)

I can't figure out why? Can anyone help me to solve this question?
Thanks

 

[Guest]

A far as I can check, none of the field been indexed.

Nothing right off the top. Is the "other field" indexed in the SQL Server
data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the response. This is huge table contain 26M records. But the
questions is when I did the similar query for another field, I got result
without the error message. Any reason?

If you take the error message fairly literally, the SQL/query is taking
too
long and the server is timing it out.

How many rows are in this table?

Regards

Jeff Boyce
Microsoft Office/Access MVP


I am running a query in access XP, the database is link a table in SQL
server
DB, the query is simple "group by" query as following:

SELECT dbo_NF.MNFTIMC
FROM dbo_NF
GROUP BY dbo_NF.MNFTIMC;

dbo_NF is link table in SQL server database

Everytime I ran this query, I got following error message:

ODBC-call failed.
[Microsofet][ODBC SQL Server Drive]Timeout expired (#0)

I can't figure out why? Can anyone help me to solve this question?
Thanks