Connection timout 0

[Guest]

I am using SQL Server 2005 and dealing with table having 2 million records
every thing is working good in SQL.

I linked that table with Access97 through ODBC for report writing but it is
not working saying "[Microsoft][ODBC SQL Server Driver] timeout expired
[#0]"after some time (but linked table showing records when we double click
in access) which means only filter queries are not working

Can you help me on this?

thanks in advance


AA

 

[Guest]

I would recommend using pass-through queries for the report writing - this
way you retrieve only the data you need from your powerfull SQL Server;
otherwise Access attempts to create filtering locally when is linked with
other tables - and dies over 2 mil records.

 

[Guest]

Thanks for reply,
Sorry it was 20 mil records.
a) It is working when we filter 2 or 3 days data which is around 30,000 but
not working on more than that? I am using same database of informix through
ODBC which is working good it takes time but it works?

b) I am linking table through ODBC, what if I use connection string it will
work?

c) Is there any kind of connection setup time(I have checked SQL and Access)
I am talking about windows?

Please help
AA

I would recommend using pass-through queries for the report writing - this
way you retrieve only the data you need from your powerfull SQL Server;
otherwise Access attempts to create filtering locally when is linked with
other tables - and dies over 2 mil records.

I am using SQL Server 2005 and dealing with table having 2 million records
every thing is working good in SQL.

I linked that table with Access97 through ODBC for report writing but it is
not working saying "[Microsoft][ODBC SQL Server Driver] timeout expired
[#0]"after some time (but linked table showing records when we double click
in access) which means only filter queries are not working

Can you help me on this?

thanks in advance


AA

 

[Guest]

Regardless of how you link your table, you would want to get as much
filtering happenning outside Access as possible. Consider creating a
PASS-THROUGH query and a (local) temporary table and have your temp table
populated with filtered records by inserting from Pass-through query. Once
temp table is populated, open your report on that table rather then linked
directly to the server.

Thanks for reply,
Sorry it was 20 mil records.
a) It is working when we filter 2 or 3 days data which is around 30,000 but
not working on more than that? I am using same database of informix through
ODBC which is working good it takes time but it works?

b) I am linking table through ODBC, what if I use connection string it will
work?

c) Is there any kind of connection setup time(I have checked SQL and Access)
I am talking about windows?

Please help
AA

I would recommend using pass-through queries for the report writing - this
way you retrieve only the data you need from your powerfull SQL Server;
otherwise Access attempts to create filtering locally when is linked with
other tables - and dies over 2 mil records.

I am using SQL Server 2005 and dealing with table having 2 million records
every thing is working good in SQL.

I linked that table with Access97 through ODBC for report writing but it is
not working saying "[Microsoft][ODBC SQL Server Driver] timeout expired
[#0]"after some time (but linked table showing records when we double click
in access) which means only filter queries are not working

Can you help me on this?

thanks in advance


AA

 

[Guest]

Thanks for your help! it worked

Regardless of how you link your table, you would want to get as much
filtering happenning outside Access as possible. Consider creating a
PASS-THROUGH query and a (local) temporary table and have your temp table
populated with filtered records by inserting from Pass-through query. Once
temp table is populated, open your report on that table rather then linked
directly to the server.

Thanks for reply,
Sorry it was 20 mil records.
a) It is working when we filter 2 or 3 days data which is around 30,000 but
not working on more than that? I am using same database of informix through
ODBC which is working good it takes time but it works?

b) I am linking table through ODBC, what if I use connection string it will
work?

c) Is there any kind of connection setup time(I have checked SQL and Access)
I am talking about windows?

Please help
AA

I would recommend using pass-through queries for the report writing - this
way you retrieve only the data you need from your powerfull SQL Server;
otherwise Access attempts to create filtering locally when is linked with
other tables - and dies over 2 mil records.

:

I am using SQL Server 2005 and dealing with table having 2 million records
every thing is working good in SQL.

I linked that table with Access97 through ODBC for report writing but it is
not working saying "[Microsoft][ODBC SQL Server Driver] timeout expired
[#0]"after some time (but linked table showing records when we double click
in access) which means only filter queries are not working

Can you help me on this?

thanks in advance


AA

 

[Guest]

Hi,

I too have similar issue. Please help me. Thank you.

1. I am running SQL server 2000. when I open a table with about 8,000,000
records, it is ok but when query from the table it appears the same message
(ie "[Microsoft][ODBC SQL Server Driver] timeout expired")

2. Also when I link the table to microsoft access through ODBC and when I
make the query and open the table, it pops up the error "ODBC – call failed.
(Error 3146)"


Regards
Ari

Thanks for your help! it worked

Regardless of how you link your table, you would want to get as much
filtering happenning outside Access as possible. Consider creating a
PASS-THROUGH query and a (local) temporary table and have your temp table
populated with filtered records by inserting from Pass-through query. Once
temp table is populated, open your report on that table rather then linked
directly to the server.

Thanks for reply,
Sorry it was 20 mil records.
a) It is working when we filter 2 or 3 days data which is around 30,000 but
not working on more than that? I am using same database of informix through
ODBC which is working good it takes time but it works?

b) I am linking table through ODBC, what if I use connection string it will
work?

c) Is there any kind of connection setup time(I have checked SQL and Access)
I am talking about windows?

Please help
AA

:

I would recommend using pass-through queries for the report writing - this
way you retrieve only the data you need from your powerfull SQL Server;
otherwise Access attempts to create filtering locally when is linked with
other tables - and dies over 2 mil records.

:

I am using SQL Server 2005 and dealing with table having 2 million records
every thing is working good in SQL.

I linked that table with Access97 through ODBC for report writing but it is
not working saying "[Microsoft][ODBC SQL Server Driver] timeout expired
[#0]"after some time (but linked table showing records when we double click
in access) which means only filter queries are not working

Can you help me on this?

thanks in advance


AA