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 |
|
DBM_IDCN
Starting Member
3 Posts |
 Posted - 2004-09-15 : 07:27:47
|
| hi,on the left corner :MS SQL Server 2000 sp3a and a simple table on widons 2000 srv (2 columns for testing)on the right corner :DB2 v 7On center : DB2 connect v 7.1The purpose is to write data to db2 from the sql2k table.With DTS :I set my connections up and when i execute the package i always received the same message column name <nameofthedb2firstcol> was not found.Even when i try to load data from a text file i receive this msg.With Query Analyser :I set up a linked server and i can only read with the openquery syntax, whe i try to select data with the 4 parts name notation i receive this msg :Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. The provider does not support the necessary method.[OLE/DB provider returned message: Method is not supported by this provider.]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80040e53: The provider does not support the necessary method.].If somebody has infos it would be great.PS: sry for my poor englishBAF SQL DBS Team |
|
|
|
|
|
Insert into DB2 table form a SQL2K one