Hypermechanic
asked on
Replication from AS400/PRMS to Microsoft SQL2000. HOW TO PLEASE.
I am trying to replicate the data contain within our AS400 running INFOR's "PRMS" to a SQL 2000 server.
I would like to do this via ODBC. I do not see AS400 driver in the ODBC list. At this point I feel some Expert advice or better yet a How To is in order.
If you would please.
I would like to do this via ODBC. I do not see AS400 driver in the ODBC list. At this point I feel some Expert advice or better yet a How To is in order.
If you would please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't think he's goin to have the IBMDA400 provider until the client tools get installed.
Hi
nmcdermaid: gave the correct answer in that the ODBC driver comes on the client access tools CD.
Once the software is installed it appears in the systems DSN.
I simply gave an alternate to ODBC by using ADODB.
nmcdermaid: gave the correct answer in that the ODBC driver comes on the client access tools CD.
Once the software is installed it appears in the systems DSN.
I simply gave an alternate to ODBC by using ADODB.
i would use ADODB, this is the same as ODBC but you can create the connections dynamically.
You could create a list of files, libraries etc in Excel the run down the list abd populete the sql table.
in excel VB you get acces to ADODB via F11, vb macro, Tools/References then select any Microsoft DAO 3.x Object library.
Open in new window