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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
