Kbase P183043: Query the database using MSSQL server linked server gives error Requested conversion is not supporte
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/03/2011 |
|
Status: Unverified
SYMPTOM(s):
Query the database using MSSQL server linked server
SELECT * FROM OPENQUERY (fdm4_64,'select * from PUB."product_review"')
Requested conversion is not supported
Cannot get the current row value of column "[MSDASQL].comment" from OLE DB provider "MSDASQL" for linked server "fdm4_64"
Query only fails for this one table
FACT(s) (Environment):
Windows
OpenEdge 10.2B
IBM AIX 6.1
CHANGE:
Changed query from 32-bit to 64-bit and ODBC driver from 32-bit to 64-bit
CAUSE:
This is a SQL Server issue.
FIX:
Contact Microsoft for assistance with the SQL server issue.
There are numerous references to the error on the web such as:
http://www.google.com/#sclient=psy&hl=en&rlz=1R2GGLL_enUS360&q=Requested+conversion+is+not+supported+Cannot+get+the+current+row+value+of+column+&rlz=1R2GGLL_enUS360&aq=f&aqi=&aql=f&oq=&pbx=1&bav=on.1,or.&fp=42ea6e12edc6080
Linked Server issue
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/8b157a9c-6a16-4b47-ba9e-10a1fa013cb3/
Linked Server Query Problem
http://bytes.com/topic/sql-server/answers/719748-linked-server-query-problem
Truncate data problem with OPENQUERY
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90555