December 31, 2008 at 12:37 pm
I hope someone can help me out with connecting to a Progress Database.
Here is what is going on; I need to create a connection from SQL Server to a Progress database. I need to pull data down regularly to perform a comparison between multiple data sources including this Progress server.
I have configured the ODBC Data source as a name of ‘ProgressODBC’ to point to the Progress database server (ProgressServer) that I need. I can access this server through MS Excel by setting the data source to this ODBC. Progress driver is 'DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E' PGPR0918.DLL
However, I have tried to create a Linked Server to no avail. I seem to be able to create the Linked Server but when I try to access the tables I get the following error: 'OLE DB provider MSDASQL reported an error. Invalid connection Data source name not found and no default driver specified.'
What I choose to use for the Linked Server is this:
- Linked Server Name: lsProgress
- Server Type: MS OLE DB Provider for ODBC Driver
- Product Name : 4.10 32-BIT Progress SQL92 v9.1E (I have even used the DLL name)
- Data Source: ProgressODBC (I have even used the DLL name and the server name)
- Provider String: ProgressServer
- Location: I used the port number that was defined on the ProgressServer. I even tried to use the full location of where the database is located.
- Catalog: I used the name of the database that I want to connect to
On the Security tab:
- Login should be made using this security context: I used the system userid that was supplied. However, there is no password. So, I used a 'space' as I found from Goggling this should work. Plus, that is the way the ODBC is set up too.
On the Server Options tab:
- I choose RPC and Use Remote Collation
I am at a loss for what I can do. I contact the Progress support guy we use and they weren't too sure what to do.
Thanks!
Don
December 31, 2008 at 12:48 pm
Go simpler. I think you're giving it too much info (and specifying it in multiple places) so it's getting confused.
Set up the actual ODBC connection with everything needed, then simply fill in
the product name and data source. Since you've already provided everything else within the ODBC connection itself - don't put the rest in again. I wouldn't specify the catalog either, since that will allow you to use 4-part names in your queries.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
December 31, 2008 at 1:13 pm
Hi Matt,
Thanks for the reply.
For the product name, I tried using along with the ODBC datasource name that I created.
When I run a query or even try to expand the tables/views from the linked server explorer I get the following error:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
I tried to set the provider name to but I received the same error.
Any thoughts on what I am missing?
I've gone down the path of leaving everything blank but the provider string. Where I entered the following:
I've even tried to use as that is how the ODBC is setup.
January 7, 2009 at 3:13 pm
I was receciving the same issue when connecting to a sybase server.
What I needed to do was add the server in the DSEDIT interface Driver
start --> Run --> dsedit
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply