I can't copy or link the oracle support doc as you need an active account.

Check the blog above, it contains the command below[/url]

netsh interface tcp set global autotuninglevel=disabled

Other possible culprits:...

Hello,

I hope it is stress. Having to manage too many troublesome instances or other work that has to be done too.

Also it is a lot harder to revert to a...

What version of oracle oledb did you install?

Latest can be found here

Apparently there is a networksetting "TCP window scaling" that might be the culprit:

See Oracle support document Oledb and Odbc...

Postponing defragmentation till really necessary as there are some many things involved: usage, fragmentation DB level, fragmentation os level, fragmentation storage level...

Thanks for sharing

Check out the Driver mania thread in this forum

I don't have the time to test it properly.

Same problem mentioned

Do you have the problem in a blank access 2010 database? As 2003/2007 is out of active support. Office life...

What type are the Access datafields? Memo?

I guess DT_WSTR is the answer. (not sure)

Is the table involved in a foreign key relationship?

You could resort to dynamic sql, double every single quote.

something like

set @mysql='select .... from openquery(banner_prod,''SELECT a.Major

...

Chad, glad you read it differently, but I meant version B (teaching developers).

Like "You exceeded your network quota",please report to your system administrator to man the networkpump. Type a...

How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?

*edit* Not an actual situation,...

Workaround is your shared answer: proper sql server casting the oracle datatypes.

Could you check if NUMBER in oracle all have a scale, precision specified? It was troublesome (2000 era) when...

What about having the remote server handling the count?

SELECT mycount

FROM OPENQUERY(LSCTLR40DAT, 'SELECT count(*) mycount FROM BASIC_CONTRACT')

Could also be due activity (locking...) on BASIC_CONTRACT