Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3905

ODBC openquery permission issues when insert oracle date field

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Optional Optional
    • None
    • 8.7.1.6_2
    • None
    • None
    • Hide

      On a windows machine with SQL Server, create a Linked Server with ODBC.

      INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
      VALUES ('TEST 1:18am', cast (getdate() as date))

      Show
      On a windows machine with SQL Server, create a Linked Server with ODBC. INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK') VALUES ('TEST 1:18am', cast (getdate() as date))

      Getting an error when attempting to insert a new row into an virtualized Oracle Table in JDV.

      Here's the query
      INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
      VALUES ('TEST 1:18am', cast (getdate() as date))

      OLE DB provider "MSDASQL" for linked server "testb" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 7344, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "testb" could not INSERT INTO table "[MSDASQL]" because of column "LK_DT". The user did not have permission to write to the column.

            rhn-engineering-shawkins Steven Hawkins
            stran@redhat.com Steve Tran
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: