I just want to check one thing out: You have installed ACE on the same machine that SQL Server is running on, haven't you?
I mean, if SQL Server runs on another machine, and you install ACE on your desktop, it is not going to work out.
So many assisted on this issue that I want to make clear that though I am marking this as the answer, all other input shared was absolutely necessary to get to this point.
This answer is selected due to the fact that when I installed the OLEDB providers on the SQL Server box I no longer receive the timeout error. In fact, the processing is almost instantaneous.
I still cannot see the OLEDB providers listed in the SSMS. Not sure why but I do think the location of the OLEDB provider installations made the difference.
Sign in to comment
Did you try to follow steps from this blog post