Solved

DB2OLEDB provider for MSSQL 2008 standard edition

Posted on 2012-03-12
6
2,801 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 37709877
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
ID: 37713619
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:Kent Olsen
ID: 37714337
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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

Author Comment

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

Accepted Solution

by:
Hagita earned 0 total points
ID: 37764578
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
ID: 37786224
i added the solution i found
0

Featured Post

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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 and will be exposed to the many uses the SELECT statement has.

738 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