Link to home
Start Free TrialLog in
Avatar of caracalla
caracalla

asked on

OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.

Scenario: I have linked a Sybase database as a linked server to my SQL Server 2000 environment. When I run a simple query against one of the Sybase tables I receive the following error:

OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.

Is the ODBC driver incapable of translating the table def. perhaps?



David

Avatar of Dishan Fernando
Dishan Fernando
Flag of Malaysia image

Can you post the Query..?
Avatar of caracalla
caracalla

ASKER

Seen the dbforum offering. Not it. I can't see the message board postings you have supplied. Would you be kind enough to post the messages into EE please?
what do u mean "post the messages into EE please? "
experts-exchange
Avatar of namasi_navaretnam
Perhaps, drop and recreate the link. That may help. Some metadata info may get re-initialized.

Have tried creating remote links using any OLEDB drivers for Sybase? There are few third party OLEDB drivers for Sybase.
As a reminder here are your open questions:

1 10/23/2003 125 Java in 10 Minutes ?  Open Java Programming
2 11/16/2003 125 IIS  Open Internet Information Server
3 11/16/2003 125 APSX  Open Apache
4 01/09/2004 250 update a field  Open Microsoft SQL Server
5 01/20/2004 500 OLE DB provider 'MSDASQL' supplied incon...  Open Microsoft SQL Server
6 09/10/2003 250 Signature  Open C#
7 12/03/2003 250 Install IIS on XP Pro  Open Internet Information Server
8 12/30/2003 250 COM >> COM+  Open C#
ASKER CERTIFIED SOLUTION
Avatar of arbert
arbert

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Some times such errors occurs due to permissions problem.