Viewing 15 posts - 781 through 795 (of 2,044 total)
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
Have a search on fetch on this forum. The oracle default fetchsize is around 200.
August 13, 2012 at 11:44 am
What do you get if you use the Oracle OLEDB drivers for oracle?
August 12, 2012 at 11:36 pm
Viewing 15 posts - 781 through 795 (of 2,044 total)