OLE DB OPENROWSET

 0 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Jim Howerton
New Member
Posts: 6
New Member
    Has anyone used this? I finally got the command to work but it returns an error.  Running in SQL analyzer window drawing from driver, not linked server.

    select * from OPENROWSET('Lawson.LawOLEDBC.4','server.com';'id';'pw',
    'dmeROD=PROD90&FILE=APINVOICE&FIELD=ACCR-CODE;COMPANY;CREATE-DATE;INCOME-CODE;
    VENDOR;INVOICE;DISTRIB-DATE&SELECT=DISTRIB-DATE%3D20090630&INDEX=APISET1&KEY=2000%3D55012%3D%3D')

    Error:

    Server: Msg 7350, Level 16, State 2, Line 1
    Could not get the column information from the OLE DB provider 'Lawson.LawOLEDBC'.
    [OLE/DB provider returned message: The command text is invalid. Verify the syntax of the command text.

    |12|-2147217900|80040e14|Command|IColumnsInfo.cc|101|-1|-1|-1|||||||||]
    OLE DB error trace [OLE/DB Provider 'Lawson.LawOLEDBC' IColumnsInfo::GetColumnsInfo returned 0x80040e14].