Solved

Current AS400 OLE Db Source Driver needed for SQL Server Standard Edition

Posted on 2009-05-13
3
344 Views
Last Modified: 2013-11-10
Hi,

I'd like to verify that my ODBC driver for IBM AS400/Db2 is the latest for SQL Server 2005.  I've seen a posting for a more current one, but it did not support Standard Edition, only Enterprise Edition.

I cannot build a dynamic (variable driven) query using the old driver.

Thanks for any help you can lend me.
Todd

AS400-Connection.jpg
AS400-ODBC.jpg
0
Comment
Question by:ToddFields2
  • 2
3 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
check this link - you can find all new downloads ..
 
http://www-03.ibm.com/systems/i/software/access/windows/dotnet/index.html
0
 

Author Closing Comment

by:ToddFields2
Comment Utility
I think our driver is the latest for our install of iSeries software.
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
also check another drivers for AS400
http://www.sqlsummit.com/oledbVen.htm
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

762 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

9 Experts available now in Live!

Get 1:1 Help Now