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.
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.
ASKER
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.
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
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
ASKER
Thank you Kent! I will try and let you know how it went.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i added the solution i found
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