I have my SQL server connecting through an OLE DB Adapter for ODBC to a UniVerse database running on a unix box. The linked server connection is made, however I cannot access the data other than viewing what is in the tables from SQL Enterprise Manager.
My question is;
How--through an SQL statement--can I access this data? The Connection name appropriately is simply 'DSN' .. and a table within it resides named 'CM'
This is what I have tried in Query Analyzer, with the following error:
---------------------
SELECT *
from OPENQUERY(dsn,'SELECT CUST from CM')
Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].CUST'. The expected data length is 10, while the returned data length is 6.
----------------------
Is there a way to set the returning length?
My question is;
How--through an SQL statement--can I access this data? The Connection name appropriately is simply 'DSN' .. and a table within it resides named 'CM'
This is what I have tried in Query Analyzer, with the following error:
---------------------
SELECT *
from OPENQUERY(dsn,'SELECT CUST from CM')
Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].CUST'. The expected data length is 10, while the returned data length is 6.
----------------------
Is there a way to set the returning length?
