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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-06 : 20:04:37
|
| Toni writes "I am trying to set-up a linked server in SQL Server 7.0 sp4 to our AS400 using Client Access v4r4. I set up a DSN on the box using Client Access. I then set up a linked server using Microsoft Ole DB Provider for ODBC Drivers that uses this DSN. After setting up the linked server I can select from a table on the 400 in query analyzer using the following syntax: Select * from AS400.S1042A6M.QGPL.CTELAB_1 This works fine. I receive the rows in the table on the AS400. When I try to insert records using this syntax it fails: Insert into AS400.S1042A6M.QGPL.CTELAB_1(PER_ID,ACCTNUM,JDEABNUM,USERID) Values ('00015096513511D696FB000103147803','LJS00000074460','90076833','CtelUser')Here is the error message that I receive: Server: Msg 7399, Level 16, State 1, Line 4 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL7008 - CTELAB_1 in QGPL not valid for operation.] OLE DB error trace [OLE/DB Provider 'MSDASQL' IOpenRowset::OpenRowset returned 0x80004005: ] I have also tried using the OpenQuery method and receive "Token" errors. How do I set this up so that I can insert records into the 400 table." |
|
|
|
|
|
SQL Server Linked Server Issue