Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DB2OLEDB provider for MSSQL 2008 standard edition

Posted on 2012-03-12
6
Medium Priority
?
2,969 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 46

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 46

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

972 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