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.
| Author |
Topic |
|
cs_bhimavarapu
Starting Member
23 Posts |
 Posted - 2002-05-15 : 09:58:57
|
| I am trying to extract data directly from mainframe table using openquery function in sql server. I am having problem extracting data from a column having datatype "Long VARCHAR" on mainframe. I get following message when I tried to run in query analyzer..On DB2, the column in question has the data length upto 40 to 50 K bytes."Could not get the current row value of column 'COLUMN_NAME' from the OLE DB provider 'MSDASQL'. [OLE/DB provider returned message: Requested conversion is not supported.]"Any thoughts on how to solve this issue ??? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-15 : 10:10:27
|
If I remember correctly, the MSDASQL provider is used for ODBC data sources. I have a feeling that the ODBC translation is choking on the long text/varchar column.Have you tried using other OLE DB or ODBC providers? Take a look here, it's an excellent list of vendors and their available drivers:http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htmYou can also try http://www.datadirect-technologies.com/ (formerly Merant) they have a number of good ODBC and OLE DB drivers. Be warned, you WILL get a call from a sales rep  |
 |
|
|
|
|
|
Using Distributed query