DB2OLEDB provider for MSSQL 2008 standard edition

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.
HagitaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenDBACommented:
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
HagitaAuthor Commented:
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
Kent OlsenDBACommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

HagitaAuthor Commented:
Thank you Kent! I will try and let you know how it went.
0
HagitaAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HagitaAuthor Commented:
i added the solution i found
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.