sqlserver2005 limitation to extract TIMESTAMP data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

sqlserver2005 limitation to extract TIMESTAMP data

Author

Topic

Sheetal
Starting Member

10 Posts

Posted - 2007-10-26 : 10:08:23

Hi,

I have created one Linked server to fetch the data from Oracle server.

I have two tables at Oracle server

1. EMP_Tbl1 (Emp_Cd VARCHAR2(10))

2. EMP_Tbl2 (EMP_ID NUMBER, Emp_Cd VARCHAR2(10))

I can connect to EMP_Tbl1 table through my linked server at SQL Server 2005.

WHILE I cann't connect to EMP_tbl2.

ERROR:
The OLE DB provider "OraOLEDB.Oracle" for linked server "Linked_Facets" supplied inconsistent metadata for a column. The column "EMPID" (compile-time ordinal 1) of object ""SYSTEM"."EMP_ASH"" was reported to have a "DBTYPE" of 5 at compile time and 130 at run time.

OR "The OLE DB provider "OraOLEDB.Oracle" for linked server "Linked_Facets" supplied invalid metadata for column "JOINING_DATE". The data type is not supported."

Reason:
EXEC sp_addlinkedserver
@server='Linked_Facets'
,@srvproduct='ORACLE'
,@provider='OraOLEDB.Oracle'--'OraOLEDB.Oracle'
,@datasrc='ameri.corp.ads.valuelabs.net'

I am using 'OraOLEDB.Oracle' as the provider. This has its own limitations. How to conquer this?

nr
SQLTeam MVY

12543 Posts

Posted - 2007-10-30 : 08:32:43

Try sending a query to Oracle instead of accessing the table directly. Then you can convert the data on Oracle if necessary.

Have a look at this
http://www.nigelrivett.net/SQLTsql/sp_ExecLinkedServer.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources