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 |
|
lousueyesh
Starting Member
9 Posts |
 Posted - 2004-05-21 : 10:36:34
|
| I am making queries to a flat file (database) system (Winsol) and by default SQL server expects a fixed data type return whereas the return is actually varchar!The following is the error message I got:"OLE DB provider ‘MSDASQL’ returned an unexpected data length for the fixed-length column ‘[Rowset_2].PROLINDES’. The expected data length is 25 , while the returned data length is 14."Can anyone tell me how I can resolve this issue by making the SQL Server not expecting the returned data type to be fixed, but as varchar?Thanks,Louis" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-21 : 12:29:32
|
| How are you running your query? Through a linked server in Query Analyzer?Tara |
 |
|
|
lousueyesh
Starting Member
9 Posts |
Posted - 2004-05-21 : 14:09:44
|
Thanks for your quick response for help!I am test running my query with SQL Server Enterprise Manager.It seems to be defaulting my return records data types to fixed data types; and when I have variable return data, the error message poped up???quote:
Originally posted by tduggan
How are you running your query? Through a linked server in Query Analyzer?Tara
|
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-21 : 14:12:11
|
| ?? How are you running this from Enterprise Manager? Are you trying to "Import Data" and getting this error? Can you just describe the processes you're going throug to do this. Also, a small sample of data would help.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Query from flat file -- fixed type expected error