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

Can you retrieve definition of the datasource(s) on the oracle side...

Not sure what the defaults are. Is @provstr="Integrated Security=SSPI; " mentioned?

Found in this url

Doublehop for IIS including preflight checks

If the server is part of a cluster

Check: linked server provider should be OracleOleDB instead of MS provider for Oracle

Nice link, pity I'm slimming down.

SELECT LOG_ID, LOG_NAME, SURGERY_DATE

FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE >= trunc(sysdate-1) and SURGERY_DATE <trunc(sysdate)')

Please do not use where trunc(surgery_date)=trunc(sysdate-1) unless you have a functional-index on SURGERY_DATE.

The query above...

Hello,

I think it is a good feature choosing a database-variant to master. Work enough in the field. Relational databases are mostly the backbone of many applications.

If you are familiar with...

Strange you get doubledouble quotes on ""StudOwner"."Student_Directory_Info"".

Was the oracle table created in a case sensitive way?

Have you checked the common issues Like not enabling in process @ linked server provider...