March 10, 2003 at 3:54 pm
I am attempting to extract data from an AS/400 database using the "DTS Import Wizard".
After selecting the Data Source "IBM AS400 OLE DB Provider", entering the correct Data Source, Username and password I click the "Test Connection" button and get a "Test connection succeeded." message.
I select the appropriate destination as well as the "Copy table(s) and view(s) from the source database" radio button and everything appears to be fine. But when I get to the next screen, the "Select Source Tables and Views" screen, there are no table or views to be seen.
I think that the problem lies in the fact that the wizard doesn't let me select which AS/400 library I want to use and therefore I can't see any tables.
Does anyone know how to directly extract AS/400 data from specific libraries?
I'm using the SQL Server 2000 Personal Edition as a testing ground until our SQL Server 2000 Enterprise Edition server gets built, configured, etc... I know that SQL Server Personal can't do everything that the Enterprise version does, but I was able to import MS Access data using the same steps and using the same SQL database.
Any help would be greatly appreciated.
Thanks.
March 11, 2003 at 2:25 am
Cannot help you with AS400 connection as I have never done that. I do connect to a third party db using their own ODBC driver and found the best way is to creat a DSN and check connectivity (although this does not seem to your problem) and table access using MSQuery. I find that if MSQuery can view table contents then SQL normally does as well. Don't know if this helps or not.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply