asked on

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.].

Yveau

Is MSDASQL the correct provider for Progress DB's ?
Does the 'test connection' work in the SSMS for that linked server ?

Hope this helps ...

Yveau

And the ODBC is working ?
Linked server connected to the correct DSN ?

Hope this helps ...

flexpipe

ASKER

odbc works - can see the list of tables and views in enterprise manager linked servers

Yveau

And when you name a column to select ?
Maybe it can't handle the * ... ?

Hope this helps ...

ASKER CERTIFIED SOLUTION

Jaaze

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

flexpipe

ASKER

Again, nice work! Thanks.

Jaaze

Hey Flexpipe,

Im glad to be useful for you

How do you create your Linked Server

flexpipe

ASKER

Enterprise manager, Security, Linked Servers, New Linked Server - ODBC

Jaaze

which parameter did you use???

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

flexpipe

ASKER

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

Jaaze

Thnks