CODEWITHSUNDEEP
sql-serverlinked-serverdbf
Danniel Magno
Danniel Magno

Reputation: 304

SQL Server error while trying to insert data to database on a linked server

I'm trying to insert some data to a database on a linked server but I'm getting the #215 error.

SQL:

INSERT INTO DBF...mone0012
   ('CODE', 'TIMES', 'BANK', 'INTCODE', 'AGENCY', 'DATE', 'DUE', 'VALUE', 
    'DISCOUNT', 'PAY', 'PDATE', 'OVER', 'ODATE', 'DOC', 'TYPE', 'EMITT', 'SIT', 
    'BUS', 'CLIENT', 'DEALER', 'LAST', 'DEVBACK', 'DESCONTADO', 'VENDOR', 'FRETE',
    'DATEB', 'TIPOC', 'OLDCLI', 'DESPESA', 'DESPDATE', 'DUPALOC', 'SACADO', 
    'CODSACADO', 'BXREAL', 'BXCONT', 'BXTERC', 'BXARBIT', 'DATAPAG', 'BANKANT', 
    'PROTESTO', 'ENDOSSO', 'SITENDOSSO', 'REEMBOLSO', 'CREDITO', 'ACERTO', 'DESPBANC', 
    'DESPCART', 'JUROS', 'DESPBANCP', 'DESPCARTP', 'JUROSP', 'LIQCNAB', 'NCOMIS', 
    'SEQRELATO', 'DEBINCOB', 'TXGER', 'TXVENDOR', 'COMPGER', 'COMPDEALER',  
    'COMPVENDOR', 'COMGER', 'COMDEALER', 'COMVENDOR', 'CODSEQ', 'COMPDEALE2', 
    'EMITCUSTOD', 'CONTRATO', 'SEND', 'BUSCDEB', 'SENDDATE', 'SENDTYPE', 'QUITEMIT', 
    'CONTRLOC', 'TXDEALER') 
VALUES 
   ('09431500A', 1, NULL, NULL, NULL, '2012-02-23 10:55:00.000', 
    '2012-02-23 10:55:00.000', 2500.50, 0, 2500.50, '2012-02-23 10:55:00.000', 0, 
    NULL, 'd', 0, NULL, 'D', '06', '6666', '666', NULL, 0, NULL, NULL, 0, NULL, NULL, 
    NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 
    NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 
    0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL)

Error:

Msg 215, Level 16, State 1, Line 1
Parameters supplied for object 'DBF...mone0012' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.

How can I solve this?

Thanks.

Upvotes: 0

Views: 1694

Answers (2)

Diego
Diego

Reputation: 36146

maybe the 3 dots are the problem. I always use:

insert into [LINKED_SERVER].DB.SCHEMA.TABLE
select * from TABLE

try updating with your information

also, I dont think you need single quotes on the names of the columns after the insert

Upvotes: 1

DavidGouge
DavidGouge

Reputation: 4623

Try putting [] around your table name. I would guess that '...' might be confusing it.

INSERT INTO [DBF...mone0012]
('CODE',        'TIMES',    'BANK', 'INTCODE',  'AGENCY',   'DATE',                     'DUE',                      'VALUE',    'DISCOUNT', 'PAY',      'PDATE',                    'OVER', 'ODATE',    'DOC',  'TYPE', 'EMITT',    'SIT',  'BUS',  'CLIENT',   'DEALER',   'LAST', 'DEVBACK',  'DESCONTADO',   'VENDOR',   'FRETE',    'DATEB',    'TIPOC',    'OLDCLI',   'DESPESA',  'DESPDATE', 'DUPALOC',  'SACADO',   'CODSACADO',    'BXREAL',   'BXCONT',   'BXTERC',   'BXARBIT',  'DATAPAG',  'BANKANT',  'PROTESTO', 'ENDOSSO',  'SITENDOSSO',   'REEMBOLSO',    'CREDITO',  'ACERTO',   'DESPBANC', 'DESPCART', 'JUROS',    'DESPBANCP',    'DESPCARTP',    'JUROSP',   'LIQCNAB',  'NCOMIS',   'SEQRELATO',    'DEBINCOB', 'TXGER',    'TXVENDOR', 'COMPGER',  'COMPDEALER',   'COMPVENDOR',   'COMGER',   'COMDEALER',    'COMVENDOR',    'CODSEQ',   'COMPDEALE2',   'EMITCUSTOD',   'CONTRATO', 'SEND', 'BUSCDEB',  'SENDDATE', 'SENDTYPE', 'QUITEMIT', 'CONTRLOC', 'TXDEALER') VALUES
('09431500A',   1,          NULL,   NULL,       NULL,       '2012-02-23 10:55:00.000',  '2012-02-23 10:55:00.000',  2500.50,    0,          2500.50,    '2012-02-23 10:55:00.000',  0,      NULL,       'd',    0,      NULL,       'D',    '06',   '6666',     '666',      NULL,   0,          NULL,           NULL,       0,          NULL,       NULL,       NULL,       0,          NULL,       NULL,       NULL,       NULL,           NULL,       NULL,       NULL,       NULL,       NULL,       NULL,       0,          NULL,       NULL,           0,              0,          0,          NULL,       NULL,       NULL,       NULL,           NULL,           NULL,       0,          0,          NULL,           0,          0,          0,          0,          0,              0,              0,          0,              0,              NULL,       NULL,           0,              NULL,       NULL,   NULL,       NULL,       NULL,       0,          NULL,       NULL)

Upvotes: 0

Related Questions