[teiid-issues] [JBoss JIRA] (TEIID-3905) ODBC openquery permission issues when insert oracle date field

[Steve Tran (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13150143#comment-13150143 ] 

Steve Tran commented on TEIID-3905:
-----------------------------------

I think this was an ODBC and/or Linked Server configuration issue.  I switched my Linked Server setup to use MSDSQL instead of MSDSQL.1 as the provider as suggested from a source I didn't bookmark.  I'm able to update my date field now.

Also, the SQL syntax I was using wasn't correct.  It should be
{code}
INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
VALUES ('TEST 1:18am', getdate())
{code}

We can close this ticket out as a non-issue.

> ODBC openquery permission issues when insert oracle date field
> --------------------------------------------------------------
>
>                 Key: TEIID-3905
>                 URL: https://issues.jboss.org/browse/TEIID-3905
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1.6_2
>         Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
>            Reporter: Steve Tran
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> 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))
> {code}
> 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.
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)