Viewing 15 posts - 811 through 825 (of 2,085 total)
Thanks for sharing
October 18, 2012 at 11:06 am
October 4, 2012 at 12:00 am
I don't have the time to test it properly.
Do you have the problem in a blank access 2010 database? As 2003/2007 is out of active support. Office life...
September 13, 2012 at 3:23 am
What type are the Access datafields? Memo?
September 12, 2012 at 1:11 pm
I guess DT_WSTR is the answer. (not sure)
September 10, 2012 at 2:16 pm
Is the table involved in a foreign key relationship?
August 30, 2012 at 3:32 pm
You could resort to dynamic sql, double every single quote.
something like
set @mysql='select .... from openquery(banner_prod,''SELECT a.Major
...
August 30, 2012 at 1:53 pm
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...
August 30, 2012 at 11:08 am
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,...
August 29, 2012 at 1:50 pm
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...
August 29, 2012 at 1:21 pm
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
August 29, 2012 at 12:52 pm
Someone on another forum suggested the following to get more insight into what is happening:
select * into your_table from [dbo].[vwIMPACT_FEE_DATA]
Can you retrieve definition of the datasource(s) on the oracle side...
August 28, 2012 at 3:54 pm
Not sure what the defaults are. Is @provstr="Integrated Security=SSPI; " mentioned?
August 28, 2012 at 3:01 pm
Check: linked server provider should be OracleOleDB instead of MS provider for Oracle
August 28, 2012 at 2:41 pm
Viewing 15 posts - 811 through 825 (of 2,085 total)