Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 926
  • Last Modified:

linked server error

I am trying to execute a query using linked server to AS400 (client Access driver for ODBC). the error code is:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.  
[OLE/DB provider returned message: [IBM][Controlador ODBC de Client Access Express (32 bits)]Controlador no capacitado.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005:   ].

Anybody can help me ?

Thanks in advance.
lausz
0
lausz
Asked:
lausz
1 Solution
 
Duane LawrenceCommented:
Hmmmm
Sounds like a data type error
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20788417.html
try converting
select convert( datetime, variablename)

This could be it, but I think it is more likely to be a data conversion error.
http://www.kbalertz.com/kb_Q318161.aspx

Please post the code so I can help you out further.

Duane

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now