Error Query Linked Server

I added a Linked Server - ODBC to a Progress DB in Enterprise Manager.

Query: Select * from erptest.pub.dbo.part

Results in:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider does not support the necessary method.
[OLE/DB provider returned message: Method is not supported by this provider.]
[OLE/DB provider returned message: [DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80040e53:  The provider does not support the necessary method.].

flexpipeAsked:
Who is Participating?
 
JaazeCommented:
Try to use OPENQUERY

SELECT * FROM OpenQuery( linkedserver, 'SELECT * FROM PUB."PART" ')
0
 
YveauCommented:
Is MSDASQL the correct provider for Progress DB's ?
Does the 'test connection' work in the SSMS for that linked server ?

Hope this helps ...
0
 
YveauCommented:
And the ODBC is working ?
Linked server connected to the correct DSN ?

Hope this helps ...
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
flexpipeAuthor Commented:
odbc works - can see the list of tables and views in enterprise manager linked servers
0
 
YveauCommented:
And when you name a column to select ?
Maybe it can't handle the * ... ?

Hope this helps ...
0
 
flexpipeAuthor Commented:
Again, nice work! Thanks.
0
 
JaazeCommented:
Hey Flexpipe,

Im glad to be useful for you

How do you create your Linked Server

0
 
flexpipeAuthor Commented:
Enterprise manager, Security, Linked Servers, New Linked Server - ODBC
0
 
JaazeCommented:
which parameter did you use???

Cause i need to do the same but I couldn't create the Linked server

0
 
flexpipeAuthor Commented:
Provider: MS OLE DB Provider for ODBC Drivers
Linked Server Properties
General,  "Data Source:" name of an exisiting working system ODBC connection
Security, "Be made using this security context", supply odbc connection id/pwd
0
 
JaazeCommented:
Thnks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.