Solved

DB2OLEDB provider for MSSQL 2008 standard edition

Posted on 2012-03-12
6
2,632 Views
Last Modified: 2012-03-30
We currently run MSSQL server 2008 R2 in standard edition. its a small-medium firm and we don’t need the enterprise edition.
I now ran into a problem: I need to link a as400/DB2 to MSSQL in order to pull out data reports.
After downloading the Feature Pack for SQL Server 2008 I understood the so called "free" Microsoft DB2OLEDB provider needs the developer or enterprise edition of MSSQL to run on. Does anybody have a cheaper solution then that? Im trying to aim a non microsoft  provider to that purpose.
0
Comment
Question by:Hagita
  • 4
  • 2
6 Comments
 
LVL 45

Expert Comment

by:Kdo
Comment Utility
Hi Hagita,

I really don't know that the Enterprise Edition is required, but I'll be glad to help and see if we can get the Standard Edition to work.  :)

First, some questions.  

Are you running a 32 or 64 bit version of SQL Server?
Is the underlying server a 32 o 64 bit O/S?
What O/S version is the AS400 running?
What errors are you seeing when you try to connect?


Kent
0
 

Author Comment

by:Hagita
Comment Utility
Hi Kent, I will explain myself clearer. I am trying to install DB2OLEDB provider and apparently I need the MSSQL enterprise edition in order to do that. the installation proccess does not succeed.
0
 
LVL 45

Expert Comment

by:Kdo
Comment Utility
Hi Hagita,

A linked server definition is pretty simple, (at least on a high level).  It requires an OLE DB provider, in this case DB2OELDB, that is simply a DLL with the necessary items to create and maintain the connection.  If the installation fails, you could always drop the DLL into the system library and register it by hand.  Or you could use a generic ODBC driver.  Not as efficient, but that may not be an issue.

I found an article where someone did connect SQL Server Standard Edition to an AS/400.  They've even provided a step-by-step guide.

 http://social.msdn.microsoft.com/Forums/eu/transactsql/thread/2fe14162-ae37-4932-841c-1edab0495ddd

Give that a look and see if that will work for you.


Kent
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:Hagita
Comment Utility
Thank you Kent! I will try and let you know how it went.
0
 

Accepted Solution

by:
Hagita earned 0 total points
Comment Utility
I did not use the ODBC driver explanation as I prefer using OLEDB. But I found this link with the perfect solution please use it !
http://weblogs.sqlteam.com/robv/archive/2010/08/19/use-microsoft-db2-oledb-provider-on-non-enterprise-sql-server.aspx
0
 

Author Closing Comment

by:Hagita
Comment Utility
i added the solution i found
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now