[Libreoffice-bugs] [Bug 122588] New: calc in win10 can't get data from "ORACLE RDB" database by ODBC and its Driver and VBA CODE

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122588

            Bug ID: 122588
           Summary: calc in win10 can't get data from "ORACLE RDB"
                    database by ODBC and its Driver and VBA CODE
           Product: LibreOffice
           Version: 6.1.2.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: madavidponyhot at gmail.com

Description:
we used did it on 32bits win7 os PC , also we use 32bits ODBC driver,and there
is only one odbc application in win7 !
but in win10 , odbc application has two version (64bits and 32bits)
libreoffice calc and base can only get the 64bits setting,
so we find new odbc driver for oracle rdb database 64bits!
then problem happend!

there is the vba code:
ConTQC.Open"provider=msdasql;dsn=______;uid=_____;pwd=_____;logintimeout=100"
sqlstr = "select cust_no from data where certif_no = '" & certif_no & "' order
by product_date desc"
rs.Open sqlstr, ConTQC, adOpenForwardOnly, adLockReadOnly
TQC.Cust_no = RS.Fields("cust_no") <----- this step will crash!


Steps to Reproduce:
1.ConTQC.Open"provider=msdasql;dsn=______;uid=_____;pwd=_____;logintimeout=100"
sqlstr = "select cust_no from data where certif_no = '" & certif_no & "' order
by product_date desc"
2.rs.Open sqlstr, ConTQC, adOpenForwardOnly, adLockReadOnly <---this step is ok
3.TQC.Cust_no = RS.Fields("cust_no") <----- this step will crash!

Actual Results:
crash 
and the error response form open 

Expected Results:
get the data from database (table column)


Reproducible: Always


User Profile Reset: Yes



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190109/1e4ef164/attachment.html>