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
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column.
Is the ODBC driver incapable of translating the table def. perhaps?
David
Can you post the Query..?
I think this is some useful 4 u..
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=19991230133624.00776.00000056%40ng-bh1.aol.com&rnum=2&prev=/groups%3Fq%3DOLE%2BDB%2Bprovider%2B%27MSDASQL%27%2Bsupplied%2Binconsistent%2Bmetadata%2Bfor%2Ba%2Bcolumn%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D19991230133624.00776.00000056%2540ng-bh1.aol.com%26rnum%3D2
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=ucLPtedIBHA.1668%40tkmsftngp04&rnum=3&prev=/groups%3Fq%3DOLE%2BDB%2Bprovider%2B%27MSDASQL%27%2Bsupplied%2Binconsistent%2Bmetadata%2Bfor%2Ba%2Bcolumn%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DucLPtedIBHA.1668%2540tkmsftngp04%26rnum%3D3
http://dbforums.com/arch/176/2002/8/483206
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=19991230133624.00776.00000056%40ng-bh1.aol.com&rnum=2&prev=/groups%3Fq%3DOLE%2BDB%2Bprovider%2B%27MSDASQL%27%2Bsupplied%2Binconsistent%2Bmetadata%2Bfor%2Ba%2Bcolumn%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D19991230133624.00776.00000056%2540ng-bh1.aol.com%26rnum%3D2
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=ucLPtedIBHA.1668%40tkmsftngp04&rnum=3&prev=/groups%3Fq%3DOLE%2BDB%2Bprovider%2B%27MSDASQL%27%2Bsupplied%2Binconsistent%2Bmetadata%2Bfor%2Ba%2Bcolumn%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DucLPtedIBHA.1668%2540tkmsftngp04%26rnum%3D3
http://dbforums.com/arch/176/2002/8/483206
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? "
ASKER
experts-exchange
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.
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#
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Some times such errors occurs due to permissions problem.