Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mnichols
Starting Member
1 Post |
 Posted - 2004-05-06 : 09:55:18
|
| I am trying to Exort some data from a few database tables in SQL Server 7.0 to AS/400 database files. Depending on how I configure the DSN's I get various errors when teh DTS wizard runs. I am using the iseries access driver for building the DSN. The biggest problem I am having is that while it attempts to create the file, and I beleive that it does create it, when it starts trying to copy data, it can't find the column names it is looking for.Does anyone have any idea how to do this? I am at a loss, as is my counter part that works for our billing company. I have tried everything I can think of, but it still will not work.Any help would be MUCH appreciated. |
|
|
MikeInNH
Starting Member
2 Posts |
Posted - 2004-05-12 : 10:59:06
|
| Hi mnichols Holy Cow! A problem that I might be able to help with. What are u using for your AS/400 connection?? The ODBC driver (CWBZZODB.DLL) -OR- the native OLE DB driver (IBMDA400)?? Also, could you share your version and service level of Client Access? I'm assuming you are using DTS (true?) - if so what task type are you using? Finally, are you actually creating new files dynamically on the 400 ('cause I don't know how to do that) -OR- are you just appending to existing database files on the 400?? Let me know. |
 |
|
|
|
|
|
SQL server 7 to AS/400