Viewing 15 posts - 796 through 810 (of 2,062 total)
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
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...
August 27, 2012 at 12:32 pm
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...
August 27, 2012 at 12:28 pm
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...
August 24, 2012 at 11:22 am
Hint: rewrite select * to the actual field names.
August 21, 2012 at 12:05 pm
If you have access to oracle support checkout note 1132253.1
August 16, 2012 at 12:50 pm
You should not set the NLS_LANG to AL32UTF8 if the client (SQLSERVER varchar) isn't AL32UTF8 aware.
August 16, 2012 at 12:42 pm
Almost certain, AL32UTF8 is an unicode characterset. All char/varchar2/... columns can now store unicode characters. You can consider them nchar/nvarchar... by now.
WE8ISO8859P1 is non-unicode.
Because not all characters from AL32UTF8 can...
August 14, 2012 at 10:00 pm
Unlikely that the move to 64-bit triggers cannot convert between non-unicode to unicode.
Did you change the nls_characterset of your oracle database whilst migrating from 9 to 11?
The oracle client on...
August 14, 2012 at 4:50 pm
Viewing 15 posts - 796 through 810 (of 2,062 total)